使用实体框架从多个表中选择数据

using System.Linq;

// 创建实体框架上下文对象
using (var context = new YourDbContext())
{
    // 使用LINQ查询语法从多个表中选择数据
    var result = (from t1 in context.Table1
                  join t2 in context.Table2 on t1.Id equals t2.Table1Id
                  where t1.SomeProperty == "SomeValue"
                  select new
                  {
                      Column1 = t1.Column1,
                      Column2 = t2.Column2
                  }).ToList();

    // 使用方法链式调用方式查询数据
    var result = context.Table1
        .Join(context.Table2, t1 => t1.Id, t2 => t2.Table1Id, (t1, t2) => new { t1, t2 })
        .Where(x => x.t1.SomeProperty == "SomeValue")
        .Select(x => new
        {
            Column1 = x.t1.Column1,
            Column2 = x.t2.Column2
        })
        .ToList();
}