This extension requires https://www.nuget.org/packages/ServiceStack.OrmLite This extension can keep your database schema in sync with your model, just by doing this:
var dbFactory = new OrmLiteConnectionFactory(connectionString, MySqlDialectProvider.Instance);
ISqlProvider customProvider = new MySqlProvider();
using (var db = dbFactory.OpenDbConnection())
{
db.UpdateTable<Customer>(customProvider, true);
db.UpdateTable<Order>(customProvider, true);
}Where: MySqlDialectProvider.Instance could be any DialectProvider given by OrmLite. ISqlProvider is a simple interface you quickly can derive, but is already implemented and tested for MySql and implemented for MsSql:
public interface ISqlProvider
{
string TableInformation { get; }
string TableColumn { get; }
string DropColumn { get; }
string DropTable { get; }
string AlterTable { get; }
}Still needs refining
Read more here https://github.com/NServiceKit/NServiceKit.OrmLite