12、Entity Framework Core: Data Query and Object Loading Strategies

最新推荐文章于 2025-09-03 15:47:30 发布

随身带U盘

最新推荐文章于 2025-09-03 15:47:30 发布

阅读量31

点赞数

CC 4.0 BY-SA版权

分类专栏：精通Entity Framework Core数据库编程文章标签： Entity Framework Core LINQ Data Query

本文链接：https://blog.youkuaiyun.com/vscode5coder/article/details/149531520

精通Entity Framework Core数据库编程专栏收录该内容

32 篇文章 ¥499.90

订阅专栏¥69.90

会员秒杀 ¥9.9 重磅福利

超级会员免费看

Entity Framework Core: Data Query and Object Loading Strategies

1. LINQ Data Query

1.1 Cross Join (Cartesian Product)

Cross join, also known as the Cartesian product, combines each row from one table with every row from another table. Here are two ways to perform a cross join using LINQ, along with the resulting SQL:

var flightDetailsSet3a = (from f in ctx.FlightSet
                          from b in ctx.BookingSet
                          from p in ctx.PassengerSet
                          where f.FlightNo == b.FlightNo && b.PassengerID == p.PersonID && f.Departure == "Rome"
                          select new { flight = f, passengers = p })
                         .ToList();

var flightD