public void RequiredAttribute_sql_generation() { using (var testDb = new TestDb(SqlVersion.Sql13)) { var command = testDb.GetCreateTableCommand(testDb.TestTable._, false); var expectedSql = @"CREATE TABLE [TestTable] ( [Id] INT NOT NULL ); "; Assert.AreEqual(expectedSql, command.CommandText); } }
public void AutoGuidAttribute_sql_generation() { using (var testDb = new TestDb(SqlVersion.Sql13)) { var command = testDb.GetCreateTableCommand(testDb.TestTable._, false); var expectedSql = @"CREATE TABLE [TestTable] ( [Guid] UNIQUEIDENTIFIER NULL DEFAULT(NEWID()) ); "; Assert.AreEqual(expectedSql, command.CommandText); } }
public void AutoDateTimeAttribute_sql_generation() { using (var testDb = new TestDb(SqlVersion.Sql13)) { var command = testDb.GetCreateTableCommand(testDb.TestTable._, false); var expectedSql = @"CREATE TABLE [TestTable] ( [DateTime] DATETIME NULL DEFAULT(GETDATE()) ); "; Assert.AreEqual(expectedSql, command.CommandText); } }
public void DbColumnNameAttribute() { using (var testDb = new TestDb(SqlVersion.Sql13)) { var command = testDb.GetCreateTableCommand(testDb.TestTable._, false); var expectedSql = @"CREATE TABLE [TestTable] ( [DB_ID] INT NULL ); "; Assert.AreEqual(expectedSql, command.CommandText); } }
public void ComputationAttribute_sql_generation() { using (var testDb = new TestDb(SqlVersion.Sql13)) { var command = testDb.GetCreateTableCommand(testDb.Headers._, false); var expectedSql = @"CREATE TABLE [Headers] ( [Id] INT NULL, [IdPlusOne] AS (([Id] + 1)), [TotalValue] INT NULL ); "; Assert.AreEqual(expectedSql, command.CommandText); } }
public void UniqueAttribute_sql_generation() { using (var testDb = new TestDb(SqlVersion.Sql13)) { var command = testDb.GetCreateTableCommand(testDb.TestTable._, false); var expectedSql = @"CREATE TABLE [TestTable] ( [Id] INT NULL CONSTRAINT [AK_Id] UNIQUE NONCLUSTERED ([Id]) ); "; Assert.AreEqual(expectedSql, command.CommandText); } }
public void DefaultValueAttribute_sql_generation() { using (var testDb = new TestDb(SqlVersion.Sql13)) { var command = testDb.GetCreateTableCommand(DbTable <TestModel> .Create(new TestModel(), testDb, nameof(TestDb.TestTable))._, false); var expectedSql = @"CREATE TABLE [TestTable] ( [Int] INT NULL DEFAULT(5), [WeekDay] TINYINT NULL DEFAULT(1), [Status] CHAR(1) NULL DEFAULT('I') ); "; Assert.AreEqual(expectedSql, command.CommandText); } }
public void CheckAttribute_sql_generation() { using (var testDb = new TestDb(SqlVersion.Sql13)) { var command = testDb.GetCreateTableCommand(testDb.TestTable.Model, false); var expectedSql = @"CREATE TABLE [TestTable] ( [Id] INT NULL CONSTRAINT [CK_TestModel_Id] CHECK ([Id] > 0) ); "; Assert.AreEqual(expectedSql, command.CommandText); } }
public void DbIndexAttribute_sql_generation() { using (var testDb = new TestDb(SqlVersion.Sql13)) { var command = testDb.GetCreateTableCommand(testDb.TestTable._, false); var expectedSql = @"CREATE TABLE [TestTable] ( [Id] INT NULL, [Value] INT NULL INDEX [IDX_ID] UNIQUE NONCLUSTERED ([Id] ASC), INDEX [IDX_ID_VALUE] NONCLUSTERED ([Id], [Value] DESC) ); "; Assert.AreEqual(expectedSql, command.CommandText); } }