public void EmptyPredicateWorks()
{
var bulkDeleteWriter = new BulkDeleteWriter(new SqlServerDialect(), MakeConfig());
var result = bulkDeleteWriter.GenerateBulkSql <Post>(Enumerable.Empty <Expression <Func <Post, bool> > >());
this.outputHelper.WriteLine(result.Sql);
Assert.Equal("delete from [Posts]", result.Sql);
}
public void NoPredicateWorks()
{
var bulkDeleteWriter = new BulkDeleteWriter(new SqlServerDialect(), MakeConfig());
var result = bulkDeleteWriter.GenerateBulkSql <Post>(null);
this.outputHelper.WriteLine(result.Sql);
Assert.Equal("delete from [Posts]", result.Sql);
}
public void SimplePredicateWorks()
{
var bulkDeleteWriter = new BulkDeleteWriter(new SqlServerDialect(), MakeConfig());
var result = bulkDeleteWriter.GenerateBulkSql(new Expression <Func <Post, bool> >[] { p => p.Title == "Foo" });
this.outputHelper.WriteLine(result.Sql);
Assert.Equal("delete from [Posts] where ([Title] = @l_1)", result.Sql);
Assert.Equal("Foo", result.Parameters.Get <string>("l_1"));
}
public void MultipleJoinWorks()
{
var bulkDeleteWriter = new BulkDeleteWriter(new SqlServerDialect(), MakeConfig());
var author = new User {
UserId = 98
};
var result = bulkDeleteWriter.GenerateBulkSql(new Expression <Func <Post, bool> >[] { p => p.Blog.Owner.EmailAddress.EndsWith("@acme.com") });
this.outputHelper.WriteLine(result.Sql);
Assert.Equal("delete t from [Posts] as t left join [Blogs] as t_100 on t.BlogId = t_100.BlogId left join [Users] as t_101 on t_100.OwnerId = t_101.UserId where t_101.[EmailAddress] like @l_1", result.Sql);
Assert.Equal("*****@*****.**", result.Parameters.Get <string>("l_1"));
}
public void MultipleJoinFkWorks()
{
var bulkDeleteWriter = new BulkDeleteWriter(new SqlServerDialect(), MakeConfig());
var author = new User {
UserId = 98
};
var result = bulkDeleteWriter.GenerateBulkSql(new Expression <Func <Post, bool> >[] { p => p.Blog.Owner == author });
this.outputHelper.WriteLine(result.Sql);
Assert.Equal("delete t from [Posts] as t inner join [Blogs] as t_100 on t.BlogId = t_100.BlogId where (t_100.[OwnerId] = @l_1)", result.Sql);
Assert.Equal(98, result.Parameters.Get <int>("l_1"));
}
public void ForeignKeyWorks()
{
var bulkDeleteWriter = new BulkDeleteWriter(new SqlServerDialect(), MakeConfig());
var author = new User {
UserId = 99
};
var result = bulkDeleteWriter.GenerateBulkSql(new Expression <Func <Post, bool> >[] { p => p.Author == author });
this.outputHelper.WriteLine(result.Sql);
Assert.Equal("delete from [Posts] where ([AuthorId] = @l_1)", result.Sql);
Assert.Equal(99, result.Parameters.Get <int>("l_1"));
}