freeSql查询语句左右链接写法

 

var resultArray = await _lisfreeSql.Select<CodeSex, DzCodeSex>()
                                 .LeftJoin((a, b) => a.Code == b.SexCode)
                                 .Where((a, b) => b.HospitalId == null || b.HospitalId == inputDto.HospitalCode)
                                 .Where((a, b) => b.Fl == inputDto.Fl || b.Fl == null)
                                 .ToListAsync<DzCodeSex>();