简单查询,简单条件语句
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]