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());
}
