表逻辑查询

从表中按逻辑查询数据

1. 接口

• IDataQuery

2. 类

TableQuery

3. 构造函数

3.1 使用table

filter默认AndLogic

public TableQuery(ITable table, Logic filter);
public TableQuery(ITable table)

var table = new UserTable();
var filter = new TableQuery(table)
     .And(table.Status.EqualValue(true));

SELECT * FROM [Users] WHERE [Status]=1

3.2 使用表名

filter默认AndLogic

public TableQuery(string tableName, Logic filter);
public TableQuery(string tableName);

var filter = new Tablefilter("Users")
    .And(u => u.Field("Id").Less("LastId"));

SELECT * FROM [Users] WHERE [Id]<@LastId

5. 其他相关功能

• 参看逻辑查询简介