public void MigrationOnDispose()
{
//testing Rob's super-cool migration on dispose pattern
using (Migration m = new Migration("Northwind"))
{
TableSchema.Table t = m.CreateTable("DisposeTable");
t.AddPrimaryKeyColumn();
t.AddColumn("Name", DbType.String);
m.AddSubSonicStateColumns(t);
}
DataService.ClearSchemaCache("Northwind");
TableSchema.Table table = DataService.GetSchema("DisposeTable", "Northwind");
Assert.IsNotNull(table);
}
public void CreateTable_Should_Allow_Char3_As_PrimaryKey()
{
new InlineQuery("Northwind").Execute("IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[MyTb]') AND type in (N'U')) \r\n DROP TABLE [dbo].[MyTb]");
using (Migration m = new Migration("Northwind")) {
TableSchema.Table tb = m.CreateTable("MyTb");
TableSchema.TableColumn col = new TableSchema.TableColumn(tb);
col.ColumnName = "Id";
col.DataType = System.Data.DbType.AnsiStringFixedLength;
col.MaxLength = 3;
col.IsPrimaryKey = true;
tb.AddColumn(col);
}
//pull the table out
DataService.ClearSchemaCache("Northwind");
TableSchema.Table table = DataService.GetSchema("MyTb", "Northwind");
Assert.IsNotNull(table);
Assert.AreEqual(3, table.PrimaryKey.MaxLength);
}
public void CreateTable_Should_Allow_Char3_As_PrimaryKey() {
new InlineQuery("Northwind").Execute("IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[MyTb]') AND type in (N'U')) \r\n DROP TABLE [dbo].[MyTb]");
using (Migration m = new Migration("Northwind")) {
TableSchema.Table tb = m.CreateTable("MyTb");
TableSchema.TableColumn col = new TableSchema.TableColumn(tb);
col.ColumnName = "Id";
col.DataType = System.Data.DbType.AnsiStringFixedLength;
col.MaxLength = 3;
col.IsPrimaryKey = true;
tb.AddColumn(col);
}
//pull the table out
DataService.ClearSchemaCache("Northwind");
TableSchema.Table table = DataService.GetSchema("MyTb", "Northwind");
Assert.IsNotNull(table);
Assert.AreEqual(3, table.PrimaryKey.MaxLength);
}
public void MigrationOnDispose()
{
//testing Rob's super-cool migration on dispose pattern
using(Migration m = new Migration("Northwind"))
{
TableSchema.Table t = m.CreateTable("DisposeTable");
t.AddPrimaryKeyColumn();
t.AddColumn("Name", DbType.String);
m.AddSubSonicStateColumns(t);
}
DataService.ClearSchemaCache("Northwind");
TableSchema.Table table = DataService.GetSchema("DisposeTable", "Northwind");
Assert.IsNotNull(table);
}