public void WithDefault() { strategy = ObjectFactory.GetInstance<IDatabaseStrategy>(); command.SetupSet(x => x.CommandText = It.IsAny<string>()).Verifiable(); var table = new Table("TestTable"); table.AddColumn(new Column("test", DbType.Int32)).Default("100500"); table.AddColumn(new Column("test2", DbType.String.Size(50))).Default("this is the test"); strategy.CreateTable(table); command.VerifySet(x => x.CommandText = WithDefaultCommand); }
public void WithStandartDefaultGuid() { strategy = ObjectFactory.GetInstance<IDatabaseStrategy>(); command.SetupSet(x => x.CommandText = It.IsAny<string>()).Verifiable(); var table = new Table("TestTable"); table.AddColumn(new Column("test", DbType.Int32)).Default(StandartDefaultType.guid); strategy.CreateTable(table); command.VerifySet(x => x.CommandText = WithStandartDefaultGuidCommand); }
public void RegularCreateTableWithIdentity() { strategy = ObjectFactory.GetInstance<IDatabaseStrategy>(); command.SetupSet(x => x.CommandText = It.IsAny<string>()).Verifiable(); var table = new Table("TestTable"); table.AddColumn(new Column("test", DbType.Int32, false, true)); table.AddColumn(new Column("test2", DbType.String.Size(50))); strategy.CreateTable(table); command.VerifySet(x => x.CommandText = RegularCreateTableWithIdentityCommand); }