public void Model_GenerateCreateTableSql_permanent_table()
{
var temp = new TempModel();
DbTable <TempModel> .Create(temp, new Mock <DbSession>().Object, "Test");
var sqlBuilder = new IndentedStringBuilder();
temp.GenerateCreateTableSql(sqlBuilder, SqlVersion.Sql13, false);
var expectedSql =
@"CREATE TABLE [Test] (
[Id] INT NOT NULL,
[Name] NVARCHAR(4000) NULL DEFAULT(N'DEFAULT NAME'),
[Unique1] INT NULL,
[Unique2] INT NULL
CONSTRAINT [PK_Test] PRIMARY KEY CLUSTERED ([Id]),
CONSTRAINT [UQ_Temp] UNIQUE NONCLUSTERED ([Unique1], [Unique2] DESC),
CONSTRAINT [CK_Temp] CHECK ([Name] IS NOT NULL),
FOREIGN KEY ([Unique1])
REFERENCES [Test] ([Id])
ON DELETE NO ACTION
ON UPDATE NO ACTION
);
";
Assert.AreEqual(expectedSql, sqlBuilder.ToString());
}
public void Model_GenerateCreateTableSql_temp_table()
{
var temp = new TempModel();
temp.AddTempTableIdentity();
var sqlBuilder = new IndentedStringBuilder();
temp.GenerateCreateTableSql("#Temp", null, sqlBuilder, SqlVersion.Sql13, true);
var expectedSql =
@"CREATE TABLE [#Temp] (
[Id] INT NOT NULL,
[Name] NVARCHAR(4000) NULL DEFAULT(N'DEFAULT NAME'),
[Unique1] INT NULL,
[Unique2] INT NULL,
[sys_row_id] INT NOT NULL IDENTITY(1, 1)
CONSTRAINT [PK_Temp_] PRIMARY KEY NONCLUSTERED ([Id]),
CONSTRAINT [UQ_Temp_] UNIQUE NONCLUSTERED ([Unique1], [Unique2] DESC),
CONSTRAINT [CK_Temp_] CHECK ([Name] IS NOT NULL),
UNIQUE CLUSTERED ([sys_row_id] ASC)
);
";
Assert.AreEqual(expectedSql, sqlBuilder.ToString().RemoveGuids());
}
