Entity Framework -- Linq To Entity使用方式

最新推荐文章于 2025-06-29 15:14:45 发布

转载最新推荐文章于 2025-06-29 15:14:45 发布 · 510 阅读

1 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/crossingdawn/archive/2009/07/27/1532212.html

文章标签：

#c#

该博客为转载内容，转载自https://www.cnblogs.com/crossingdawn/archive/2009/07/27/1532212.html ，涉及C#相关知识。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1. Projection

Code
using(var ctx=new SchoolEntities())
{
    ObjectQuery<Courses> courses = ctx.Courses;
    IQueryable<Courses> allcourses = from c in courses
                                     select c;
    Console.WriteLine(courses.ToTraceString());
}

2. Where

Code
using(var ctx=new SchoolEntities())
{
    ObjectQuery<Courses> courses = ctx.Courses;
    IQueryable<Courses> allcourses = from c in courses
                                     where c.CourseName == "Act"
                                     select c;
}

3.Pagination

Code
using(var ctx=new SchoolEntities())
{
    ObjectQuery<Courses> courses = ctx.Courses;
    IQueryable<Courses> allcourses = from c in courses
                                     orderby c.CourseType
                                     select c.Skip(0).Take(100);
}

4. Aggregation (Average, Max, Min, Count, Sum)

using(var ctx=new SchoolEntities())
{
var older = ctx.Persons.Max(p=>p.Age);
Console.WriteLine(older.Value);
}

5. Join

using(var ctx=new SchoolEntities())
{
    var query = from c in ctx.Courses
                join d in ctx.CourseDetails
                on d.CourseID equals c.CourseID
                select new{
                    c, d.Info};
}

转载于:https://www.cnblogs.com/crossingdawn/archive/2009/07/27/1532212.html