Entity Framework Core 新特性

最新推荐文章于 2025-05-14 15:45:16 发布

flyingdream123

最新推荐文章于 2025-05-14 15:45:16 发布

阅读量186

点赞数

CC 4.0 BY-SA版权

分类专栏： Entity Framework Core

本文链接：https://blog.csdn.net/flyingdream123/article/details/99203073

Entity Framework Core 专栏收录该内容

8 篇文章

订阅专栏

本文探讨了使用C#的LINQ进行复杂查询的方法，包括调用C#方法、Include与ThenInclude加载关联实体、投影查询等技巧，并展示了如何在EntityFrameworkCore中实现这些查询及其对应的SQL语句。

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

LINQ-to-Entities查询时可以调用C#方法

 class Program
    {
        static void Main(string[] args)
        {
            using(var context=new SchoolContext())
            {
                var studentsWithSameName = context.Students.Where(m => m.FirstName == GetName()).ToList();
                Console.WriteLine(studentsWithSameName.First().FirstName);
            }
            Console.ReadKey();
        }

        public static string GetName()
        {
            return "Bill";
        }
    }

Include 查询时加载同一实例的导航属性

var context = new SchoolContext();

var studentWithGrade = context.Students
                           .Where(s => s.FirstName == "Bill")
                           .Include(s => s.Grade)
                           .FirstOrDefault();

生成的查询Sql

SELECT TOP(1) [s].[StudentId], [s].[DoB], [s].[FirstName], [s].[GradeId],[s].[LastName], 
        [s].[MiddleName], [s.Grade].[GradeId], [s.Grade].[GradeName], [s.Grade].[Section]
FROM [Students] AS [s]
LEFT JOIN [Grades] AS [s.Grade] ON [s].[GradeId] = [s.Grade].[GradeId]
WHERE [s].[FirstName] = N'Bill'

EF Core引入了新的ThenInclude（）扩展方法来加载多个级别的相关实体。

请考虑以下示例：

var context = new SchoolContext();

var student = context.Students.Where(s => s.FirstName == "Bill")
                        .Include(s => s.Grade)
                            .ThenInclude(g => g.Teachers)
                        .FirstOrDefault();

SELECT TOP(1) [s].[StudentId], [s].[DoB], [s].[FirstName], [s].[GradeId], [s].[LastName],
         [s].[MiddleName], [s.Grade].[GradeId], [s.Grade].[GradeName], [s.Grade].[Section]
FROM [Students] AS [s]
LEFT JOIN [Grades] AS [s.Grade] ON [s].[GradeId] = [s.Grade].[GradeId]
WHERE [s].[FirstName] = N'Bill'
ORDER BY [s.Grade].[GradeId]
Go

SELECT [s.Grade.Teachers].[TeacherId], [s.Grade.Teachers].[GradeId], [s.Grade.Teachers].[Name]
FROM [Teachers] AS [s.Grade.Teachers]
INNER JOIN (
    SELECT DISTINCT [t].*
    FROM (
        SELECT TOP(1) [s.Grade0].[GradeId]
        FROM [Students] AS [s0]
        LEFT JOIN [Grades] AS [s.Grade0] ON [s0].[GradeId] = [s.Grade0].[GradeId]
        WHERE [s0].[FirstName] = N'Bill'
        ORDER BY [s.Grade0].[GradeId]
    ) AS [t]
) AS [t0] ON [s.Grade.Teachers].[GradeId] = [t0].[GradeId]
ORDER BY [t0].[GradeId]
go

Projection Query投影查询

var context = new SchoolContext();

var stud = context.Students.Where(s => s.FirstName == "Bill")
                        .Select(s => new
                        {
                            Student = s,
                            Grade = s.Grade,
                            GradeTeachers = s.Grade.Teachers
                        })
                        .FirstOrDefault();

生成的Sql同上