.netcore 同时获取二个表的联合数据 EFCore联合查询 Inner Join 查询

//获取用户信息

//上下文
var dbContext = DBServerProvider.DbContext;

//设置要查询的二张表
var leftDb = dbContext.Set<Sys_User>();
var rightDb = dbContext.Set<Sys_WxUser>();

//获取二个表的联合数据
var user = await leftDb.Where(x => x.User_Id == UserContext.Current.UserId)
   .SelectMany(b => rightDb.Where(x => x.User_Id == b.User_Id), (us, wx) => new { us, wx })
   .FirstOrDefaultAsync();

//两表join Ling写法

var query = from u in oae .Users
            join p in oae.Parent on u.Id equals p,ParentId
            select new
            {
                username = u.UserName ,
                father = p.Father
            }


lamdba写法:

/*
第一个参数:join的表
第二，三参数:连接条件
第四个参数:返回值
*/

var query = oae.Users.Join(oae.Parent, a => a.Id, b => b.ParentId, (a, b) => new
            {
                username = a.UserName,
                fahter = b.Father
            }