方法一:Linq to Entitie var info = from p in entity.Users where p.ID >= 10 orderby p.ID
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);
}
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);
}
var info3 = ((iobjectContextAdapter)entity).ObjectContext.CreateQuery<User>(strSQL);
foreach (var item in info)
{
Console.WriteLine("ID:" + item.ID + " " + "登录名:" + item.LoginName + " " + "密码:" + item.Password);
}
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常用查询语句的文章就介绍到这了。希望对大家的学习有所帮助,也希望大家多多支持编程网。
--结束END--
本文标题: EntityFramework常用查询语句
本文链接: https://www.lsjlt.com/news/140891.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2023-05-21
2023-05-21
2023-05-21
2023-05-21
2023-05-20
2023-05-20
2023-05-20
2023-05-20
2023-05-20
2023-05-20
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0