public void TestBuildsManyToManyDeleteQuery()
{
//--Act
var query = new SqlServerDeleteQueryBuilder().Delete(new PredicateBuilder <ClientUser>().Filter(x => x.UserId).Filter(x => x.IsActive));
//--Assert
Console.WriteLine(query);
var queryLines = SplitQuery(query);
Assert.AreEqual(2, queryLines.Length);
Assert.AreEqual("delete from [Client_User]", queryLines[0]);
Assert.AreEqual("where [UserId] = @UserId and [IsActive] = @IsActive", queryLines[1]);
}
public void TestBuildsDeleteQueryWhereFieldHasValue()
{
//--Act
var query = new SqlServerDeleteQueryBuilder().Delete(new ValuedPredicateBuilder <SuperEmployee>().Filter(x => x.SomeAwesomeFieldA, Guid.NewGuid().ToString()));
//--Assert
Console.WriteLine(query);
var queryLines = SplitQuery(query);
Assert.AreEqual(2, queryLines.Length);
Assert.AreEqual("delete from [SuperEmployee]", queryLines[0]);
Assert.AreEqual("where [SomeAwesomeFieldA] = @SomeAwesomeFieldA", queryLines[1]);
}
public void TestBuildsManyToManyDeleteByKeyQuery()
{
//--Act
var query = new SqlServerDeleteQueryBuilder().DeleteKey <ClientUser>();
//--Assert
Console.WriteLine(query);
var queryLines = SplitQuery(query);
Assert.AreEqual(2, queryLines.Length);
Assert.AreEqual("delete from [Client_User]", queryLines[0]);
Assert.AreEqual("where [ClientId] = @ClientId and [UserId] = @UserId", queryLines[1]);
}
