产品
GPT4.0+Midjourney绘画+国内大模型 会员永久免费使用！
【 如果你想靠AI翻身，你先需要一个靠谱的工具！ 】
1 2 3 4 5 | 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:" + item.ID + " " + "登录名:" + item.LoginName + " " + "密码:" + item.Password);} |
1 2 3 4 5 | var info2 = 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);} |
1 2 3 4 5 | var info3 = ((IObjectContextAdapter)entity).ObjectContext.CreateQuery<User>(strSQL);foreach (var item in info){ Console.WriteLine("ID:" + item.ID + " " + "登录名:" + item.LoginName + " " + "密码:" + item.Password);} |
1 2 3 4 5 6 7 8 9 10 11 12 13 | try{ string strSQL2 = "SELECT * 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常用查询语句的文章就介绍到这了。希望对大家的学习有所帮助，也希望大家多多支持脚本之家。
155-2731-8020
