FutureStateMobile / AppCore.Data

A Portable, cross-platform, light weight, opinionated ORM designed to work across multiple Databases
9 stars 5 forks source link

UpdateTable in SQLite is generating invalid syntax #8

Closed ChaseFlorell closed 10 years ago

ChaseFlorell commented 10 years ago

Using this migration

var dialect = new SqliteDialect();
var migration = new DbMigration(dialect);
var database = new Database("MyDatabase", dialect);

var testTable = database.UpdateTable("Test");
testTable.AddColumn("Name", typeof(string), 100).Nullable();
testTable.AddColumn("Address", typeof(string), 100).Nullable();

var actualDDL = migration.GenerateDDL(database);

ActualDDL outputs

ALTER TABLE [Test] ADD COLUMN 
[Name] nvarchar(100) NULL,
[Address] nvarchar(100) NULL;

But Should Output

ALTER TABLE [Test] ADD
[Name] nvarchar(100) NULL;
ALTER TABLE [Test] ADD
[Address] nvarchar(100) NULL;
ChaseFlorell commented 10 years ago

Fixed in build build-1.0.0.43 6d808b6bd6549c39a65792487e1a1abd569efc98