Linq给我们带来了很多的便利,不必时时刻刻写sql,可以让一个不懂T-SQL的程序猿也能实现简单编程,但是linq在效率上确实比不上SQL。数据量越大,效率问题就明显。
一般查询可以这样写
var v = (from c in en.T_AQI where c.DatState.Equals("2") && c.SiteID == siteID orderby c.DataTime descending //排序 select c).Take(30).ToList();//Take和top的作用一样。ToList()就不用说了
也可以指定列查询
var v = (from c in en.T_AQI where c.DatState.Equals("2") && c.SiteID == siteID orderby c.DataTime descending select new {name = st.Name, age= st.Age}).Take(30).ToList();//列名是自己随意写的
也可以链接查询
var v = (from c in en.T_AQI from u in r.TabUser where c.DatState.Equals("2") && c.SiteID == siteID orderby c.DataTime descending select new{u.Name,c.Age,...}).Take(30).ToList(); //这个是多对多查询
var v = (from c in en.T_AQI from u in en.T_AQI where c.DatState.Equals("2") && c.SiteID == c.SiteID orderby c.DataTime descending select new{name=c.Name,age=c.Age}).Take(30).ToList(); //这个是自连接查询
var v = (from c in en.User join u in en.Role on c .RoleId equals u.ID into userlist where c.DatState.Equals("2") && c.SiteID == c.SiteID orderby c.DataTime descending select new{c.Name,c.Age,u.RoleName}).Take(30).ToList(); //这个是双向接查询
var v = (from c in en.T_AQI from u in r.TabUser where c.DatState.Equals("2") && c.SiteID == siteID orderby c.DataTime descending select u).Take(30).ToList(); //这个是一对多查询
新闻热点
疑难解答