public void TheDeleteCanCreateAValidWithAnAlsoThatContainsTheSameName()
{
var firstColumnIsEqualToFirstValue =
new Where()
[
FirstColumn.IsEqualTo(FirstValue),
Also.And(FirstColumn.IsEqualTo(FirstValue))
];
var deleteStatement =
new Delete(SomeTable)
.Where(firstColumnIsEqualToFirstValue);
deleteStatement.CreateSql().Should().NotBe("DELETE FROM " + SomeTable + " WHERE " + FirstColumn + " = @where_" + FirstColumn + " AND (" + FirstColumn + " = @where_" + FirstColumn + ")");
}
public void TheDeleteCanCreateAValidStatementWithConditions()
{
var firstColumnIsEqualToFirstValue =
new Where()
[
FirstColumn.IsEqualTo(FirstValue)
];
var deleteStatement =
new Delete(SomeTable)
.Where(firstColumnIsEqualToFirstValue);
var whereItem =
firstColumnIsEqualToFirstValue.GetType().GetProperty("WhereItems", BindingFlagsToSeeAll)
.GetValue(firstColumnIsEqualToFirstValue, BindingFlagsToSeeAll, null, null, null)
.As<IList<WhereItem>>()
.First();
deleteStatement.CreateSql().Should().Be("DELETE FROM " + SomeTable + " WHERE " + FirstColumn + " = @" + whereItem.Name + whereItem.UniqueKey);
}
public void TheDeleteCanCreateAValidStatement()
{
var deleteStatement = new Delete(SomeTable);
deleteStatement.CreateSql().Should().Be("DELETE FROM " + SomeTable);
}
