linq 左连接 linqy 右链接

左连接加where 判断

var ls = from imag in _context.ImageAll
where imag.Proidid&&imag.I_mageLR"L"
from csv in _context.Csvdata.Where(csv => csv.ID==imag.I_magebhid).DefaultIfEmpty()
where csv.I_ImageType!=tie&& csv.I_ImageType!=bai_heng&&csv.I_ImageType!=bai_zong

                         select new { imag.I_mageName };


                var lsR = from imag in _context.ImageAll
                          where imag.Proid == id && imag.I_mageLR == "R"
                          from csv in _context.Csvdata.Where(csv => csv.ID == imag.I_magebhid).DefaultIfEmpty()
                          where csv.I_ImageType != tie && csv.I_ImageType != bai_heng && csv.I_ImageType != bai_zong



                          select new { imag.I_mageName };

右连接加where 判断

var ls = from imag in _context.ImageAll
where imag.Proidid&&imag.I_mageLR"L"
from csv in _context.Csvdata.Where(csv => csv.ID==imag.I_magebhid)
where csv.I_ImageType!=tie&& csv.I_ImageType!=bai_heng&&csv.I_ImageType!=bai_zong

                         select new { imag.I_mageName };


                var lsR = from imag in _context.ImageAll
                          where imag.Proid == id && imag.I_mageLR == "R"
                          from csv in _context.Csvdata.Where(csv => csv.ID == imag.I_magebhid)
                          where csv.I_ImageType != tie && csv.I_ImageType != bai_heng && csv.I_ImageType != bai_zong



                          select new { imag.I_mageName };