表删除

从表中删除数据

1. 接口

IDelete

2. 类

TableDelete

3. 相关方法

3.1 ToDelete扩展方法

TableDelete ToDelete(this ITable table, ISqlLogic where);

var table = new StudentTable();
var delete = table.ToDelete(table.Score.LessValue(60));

DELETE FROM [Students] WHERE [Score]<60

3.2 ToDelete重载扩展方法

TableDelete ToDelete<TTable>(this TTable table, Func<TTable, ISqlLogic> query)
    where TTable : ITable;

var delete = new StudentTable()
    .ToDelete(table => table.Score.LessValue(60));

DELETE FROM [Students] WHERE [Score]<60

4. 普通示例

var query = new TableSqlQuery("Students")
    .Where(table => table.Field("Score").LessValue(60));
var delete = new TableDelete("Students", query.Filter);

DELETE FROM [Students] WHERE [Score]<60