public static int DeleteByQuery <T>(this IDbConnection connection, Action <IRestrictable <T> > restriction)
where T : class
{
var parameters = new List <object>();
var sql = new DeleteByQuery <T>().GetSql(restriction, parameters);
return(AttachParamsAndRun(connection, sql, parameters));
}
public void DeleteByQuery()
{
var deleteByQuery = new DeleteByQuery <CompositeIdSample>();
var parameters = new List <object>();
var sql = deleteByQuery.GetSql(w => w.Equal(x => x.Id1, 5), parameters);
Assert.AreEqual("DELETE FROM `composite_id_table` WHERE (`Id1` = ?p0);", sql);
Assert.AreEqual(5, parameters[0]);
}