只是闲来无事对Linq的一些笔记,不是什么技术分析文章。以简单的例子来展示Linq之美
1.简单查询一个字段(在VS2008中先要新建一个Linq to SQL类).
DataClasses1DataContext db = new DataClasses1DataContext();
var result = from q in db.t_customer
select q.Name; //只查询表中Name字段
2.匿名类型形式:
DataClasses1DataContext db = new DataClasses1DataContext();
var result = from q in db.t_customer
select new { Name=q.name,Tel=q.tel==""?"00000":q.tel};//其中TEL后面的和SQL语句中的 case when then一样,还是置换成case when then
3.其中 select new _可以为指定类型,不过要和查询的字段类型一样 (新建一个和查询结果一样的类Coutmer)
DataClasses1DataContext db = new DataClasses1DataContext();
var result = from q in db.t_customer
select new Coutmer{ Name=q.name,Tel=q.tel==""?"00000":q.tel};
4Distinct形式(去重复)
DataClasses1DataContext db = new DataClasses1DataContext();
var result = (from q in db.t_customer
select new Coutmer{ Name=q.name,Tel=q.tel==""?"00000":q.tel}).Distinct();
DataClasses1DataContext db = new DataClasses1DataContext();
var result = (from q in db.t_customer
select new Coutmer{ Name=q.name,Tel=q.tel==""?"00000":q.tel}).Distinct();