简单查询，简单条件语句

new DBHelper<DTStudentModel>()
.Select(p => new
{
    p.IdentityID,
    p.StuCode,
    p.StuName,
    p.StuAge,
    p.StuSex
})
.Where(p => p.StuSex == p.StuSex)
.ToEntityList<DTStudentModel>(new
{
    StuSex = "男"
});
-- 对应 SQL
select [T_Student].[IdentityID],[T_Student].[StuCode],[T_Student].[StuName],[T_Student].[StuAge],[T_Student].[StuSex] from [T_Student] where ([T_Student].[StuSex] = @StuSex)
    

简单查询，Distinct 和 Top 语句

new DBHelper<DTStudentModel>()
.Distinct()
.Take(10)
.Select(p => new
{
    p.IdentityID,
    p.StuCode,
    p.StuName,
    p.StuAge,
    p.StuSex
})
.Where(p => p.StuSex == p.StuSex)
.ToEntityList<DTStudentModel>(new
{
    StuSex = "男"
});
-- 对应 SQL
select distinct top 10 [T_Student].[IdentityID],[T_Student].[StuCode],[T_Student].[StuName],[T_Student].[StuAge],[T_Student].[StuSex] from [T_Student] where ([T_Student].[StuSex] = @StuSex)
    

查询单条数据

new DBHelper<DTStudentModel>()
.Select(p => new
{
    IncID = p.IdentityID,
    p.StuCode,
    p.StuName,
    p.StuAge,
    p.StuSex
})
.Where(p => p.IdentityID == p.IdentityID)
.ToEntity<DTStudentModel>(new
{
    IdentityID = 1
});
-- 对应 SQL
select [T_Student].[IdentityID] as [IncID],[T_Student].[StuCode],[T_Student].[StuName],[T_Student].[StuAge],[T_Student].[StuSex] from [T_Student] where ([T_Student].[IdentityID] = @IdentityID)
    

查询首行首列

new DBHelper<DTStudentModel>()
.Select(p => new
{
    p.IdentityID,
})
.Where(p => p.IdentityID == p.IdentityID)
.First<int>(new
{
    IdentityID = 1
});
-- 对应 SQL
select [T_Student].[IdentityID] from [T_Student] where ([T_Student].[IdentityID] = @IdentityID)
    

设置新表名

new DBHelper<DTStudentModel>()
.As("newTable")
.Select(p => new
{
    p.IdentityID,
    p.StuCode,
    p.StuName,
    p.StuAge,
    p.StuSex
})
.ToEntityList<DTStudentModel>();
-- 对应 SQL
select [newTable].[IdentityID],[newTable].[StuCode],[newTable].[StuName],[newTable].[StuAge],[newTable].[StuSex] from [T_Student] as [newTable]