左连接加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 };