public void SqlServerCreatesSqWithBooleanDefault() { ColumnPropertiesMapper mapper = new ColumnPropertiesMapper(new SqlServerDialect(), "bit"); mapper.MapColumnProperties(new Column("foo", DbType.Boolean, 0, false)); Assert.AreEqual("[foo] bit DEFAULT 0", mapper.ColumnSql); mapper.MapColumnProperties(new Column("bar", DbType.Boolean, 0, true)); Assert.AreEqual("[bar] bit DEFAULT 1", mapper.ColumnSql); }
public void SqlServerCreatesSql() { ColumnPropertiesMapper mapper = new ColumnPropertiesMapper(new SqlServerDialect(), "varchar(30)"); mapper.MapColumnProperties(new Column("foo", DbType.String, 0)); Assert.AreEqual("[foo] varchar(30)", mapper.ColumnSql); }
public void SqlServerCreatesSqWithNullDefault() { ColumnPropertiesMapper mapper = new ColumnPropertiesMapper(new SqlServerDialect(), "varchar(30)"); mapper.MapColumnProperties(new Column("foo", DbType.String, 0, "NULL")); Assert.AreEqual("[foo] varchar(30) DEFAULT NULL", mapper.ColumnSql); }
public void SQLiteIndexSqlWithEmptyStringDefault() { ColumnPropertiesMapper mapper = new ColumnPropertiesMapper(new SQLiteDialect(), "varchar(30)"); mapper.MapColumnProperties(new Column("foo", DbType.String, 1, ColumnProperty.NotNull, string.Empty)); Assert.AreEqual("foo varchar(30) NOT NULL DEFAULT ''", mapper.ColumnSql); }