没有合适的资源?快使用搜索试试~ 我知道了~
LinQ集成化查询语言
资源推荐
资源详情
资源评论
LinQ――集成化查询语言
家族:
LinQ to SQL:专门用来操作SqlServer数据库的语言
LinQ to Object:专门用来操作内存中数组或集合的语言
LinQ to DataSet:专门用来操作内存中的DataTable的语言
LinQ to Entities:操作实体框架中的实体集合
LinQ查询:
1.查所有的
var query = from p in context.Work select p;
var query = context.Work;
2.行的简单筛选
var query = from p in context.Work where p.InfoCode=="p001" select p;
var query = context.Work.where(p=>p.InfoCode=="p001");
3.行的逻辑与逻辑或的筛选
var query = from p in context.Family where p.InfoCode == "p004" && p.Title == "T001" && p.Name == "唐杰" select p;
var query = context.Family.Where(p => p.InfoCode == "p004").Where(p=>p.Title == "T001" && p.Name == "唐杰");
var query = from p in context.Family where p.InfoCode == "p003" || (p.Title == "T001" && p.Name == "唐杰") select p;
var query = context.Family.Where(p=> p.InfoCode == "p003" || (p.Title == "T001" && p.Name == "唐杰") );
4.对列的投影(简单了解)
var query = from p in context.Family select new { p.Title, p.Name };
5.模糊查询
//var query = from p in context.Work where p.Firm.Contains("网") select p;
//var query = from p in context.Work where p.Firm.Substring(2, 1) == "网" select p;
//var query = from p in context.Work where p.Firm.StartsWith("山") select p;
//var query = from p in context.Work where p.Firm.EndsWith("大学") select p;
var query = context.Work.Where(p=>p.Firm.EndsWith("大学"));
6.排序
//var query = from p in context.Work orderby p.Orders select p;
//var query = context.Work.OrderBy(p=>p.Orders);
家族:
LinQ to SQL:专门用来操作SqlServer数据库的语言
LinQ to Object:专门用来操作内存中数组或集合的语言
LinQ to DataSet:专门用来操作内存中的DataTable的语言
LinQ to Entities:操作实体框架中的实体集合
LinQ查询:
1.查所有的
var query = from p in context.Work select p;
var query = context.Work;
2.行的简单筛选
var query = from p in context.Work where p.InfoCode=="p001" select p;
var query = context.Work.where(p=>p.InfoCode=="p001");
3.行的逻辑与逻辑或的筛选
var query = from p in context.Family where p.InfoCode == "p004" && p.Title == "T001" && p.Name == "唐杰" select p;
var query = context.Family.Where(p => p.InfoCode == "p004").Where(p=>p.Title == "T001" && p.Name == "唐杰");
var query = from p in context.Family where p.InfoCode == "p003" || (p.Title == "T001" && p.Name == "唐杰") select p;
var query = context.Family.Where(p=> p.InfoCode == "p003" || (p.Title == "T001" && p.Name == "唐杰") );
4.对列的投影(简单了解)
var query = from p in context.Family select new { p.Title, p.Name };
5.模糊查询
//var query = from p in context.Work where p.Firm.Contains("网") select p;
//var query = from p in context.Work where p.Firm.Substring(2, 1) == "网" select p;
//var query = from p in context.Work where p.Firm.StartsWith("山") select p;
//var query = from p in context.Work where p.Firm.EndsWith("大学") select p;
var query = context.Work.Where(p=>p.Firm.EndsWith("大学"));
6.排序
//var query = from p in context.Work orderby p.Orders select p;
//var query = context.Work.OrderBy(p=>p.Orders);
资源评论
轨迹行
- 粉丝: 2
- 资源: 25
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功