private IMap<Post> GenerateMap() {
var dialect = new SqlServerDialect();
var config = new Mock<IConfiguration>(MockBehavior.Strict);
var map = new Map<Post> { Table = "Posts", Schema = null, Configuration = config.Object };
map.Columns.Add(
"PostId",
new Column<int> {
Name = "PostId",
DbName = "PostId",
DbType = DbType.Int32,
Map = map,
IsPrimaryKey = true,
IsAutoGenerated = true,
IsNullable = false
});
map.PrimaryKey = map.Columns.First().Value;
return map;
}
private static ICountWriter MakeTarget() {
var dialect = new SqlServerDialect();
var configuration = MakeConfig();
var selectWriter = new CountWriter(dialect, configuration);
return selectWriter;
}
public void IfExistsGeneratesExpectedSql() {
var dialect = new SqlServerDialect();
var sql = dialect.WriteDropTableIfExists("<tablename>");
Assert.Equal("if exists (select 1 from INFORMATION_SCHEMA.TABLES where TABLE_NAME = '<tablename>') drop table [<tablename>]", sql);
}
