Entity Framework常用查询语句

方法一：Linq to Entitie

var info = from p in entity.Users where p.ID >= 10 orderby p.ID descending select p;foreach (var item in info){    Console.WriteLine("ID:" + itrnBnmhJem.ID + " " + "登录名:" + item.LoginName + " " + "密码:" + item.Password);}

方法二：Lamada表达式

var infwww.easck.como2 = entity.Users.Where<User>(p => p.ID >= 10).OrderByDescending(p => p.ID);foreach (var item in info){    Console.WriteLine("ID:" + item.ID + " " + "登录名:" + item.LoginName + " " + "密码:" + item.Password);}

方法三：Entity SQL Language

var info3 = ((IObjectContextAdapter)entity).ObjectContext.CreateQuery<User>(strSQL);foreach (var item in info){    Console.WriteLine("ID:" + item.ID + " " + "登录名:" + item.LoginName + " " + "密码:" + item.Password);}

方法四：SqlQuery

try{    string strSQL2 = "SEwww.easck.comLECT * FROM Users WHERE ID>=10 ORDER BY ID DESC";    var info4 = entity.Database.SqlQuery<User>(strSQL2);    foreach (var item in info)    {        Console.WriteLine("ID:" + item.ID + " " + "登录名:" + item.LoginName + " " + "密码:" + item.Password);    }}catch (Exception ex){    Console.WriteLine(ex.Message);}

到此这篇关于Entity Framework常用查询语句的文章就介绍到这了。希望对大家的学习有所帮助，也希望大家多多支持我们。