public void AddDefaultAutoName() { var tbl = new Table("test") .AddColumn(new Column("testid", System.Data.DbType.Int32)); tbl.Default("100500"); Assert.AreEqual("DF_TEST_TESTID", tbl.Columns[0].Constraint.Name); }
public void AddDefaultAtPrimaryKeyColumn() { var tbl = new Table("test") .AddColumn(new Column("testid", System.Data.DbType.Int32)) .AddPrimaryKey("testid"); Assert.Throws<ConflictingDataException>(() => tbl.Default("test")); }
public void AddOneDefaultAtLastColumn() { var tbl = new Table("test") .AddColumn(new Column("testid", System.Data.DbType.Int32)) .AddColumn(new Column("col2", System.Data.DbType.Int32)) .AddColumn(new Column("col3", System.Data.DbType.Int32)) .AddPrimaryKey("testid"); tbl.Default("100500"); var constraint = tbl.Columns.Last().Constraint as ValueDefault; Assert.IsNotNull(constraint); Assert.AreEqual("100500", constraint.Value); }
public void AddDefaultWithoutColumn() { var tbl = new Table("test"); Assert.Throws<ColumnExpectedException>(() => tbl.Default("test")); }