日本免费高清视频-国产福利视频导航-黄色在线播放国产-天天操天天操天天操天天操|www.shdianci.com

學無先后,達者為師

網站首頁 編程語言 正文

Entity?Framework常用查詢語句_實用技巧

作者:.NET開發菜鳥 ? 更新時間: 2022-05-02 編程語言

方法一: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:" + item.ID + " " + "登錄名:" + item.LoginName + " " + "密碼:" + item.Password);
}

方法二:Lamada表達式

var info2 = entity.Users.Where(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(strSQL);
foreach (var item in info)
{
    Console.WriteLine("ID:" + item.ID + " " + "登錄名:" + item.LoginName + " " + "密碼:" + item.Password);
}

方法四:SqlQuery

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

原文鏈接:https://www.cnblogs.com/dotnet261010/p/7249742.html

欄目分類
最近更新