Guest User

Guest User

  • Tech Writer
  • 611
  • 127.8k

Get Record From three table in linq

Aug 19 2020 7:49 AM
I have use this query for get data from three table .But i have null Not record found issue.
var Fav = (from FV in _context.TblFavUserVideo
join VM in _context.TblVideoMaster on FV.CategoryId equals VM.CategoryId
join EV in _context.TblEducationalVideo on FV.EducationalVideoId equals EV.EducationalId
where FV.UserId == obj_parameter.UserId && VM.VideoFavStatus== Convert.ToBoolean(1) && FV.EdcuationalVideoStatus == Convert.ToBoolean(1)
select new
{
FV.FavId,
//FV.FileId,
FV.UpdatedDate,
VM.FilePath,
EV.VideoPath,
EV.ImagePath,
EV.EducationalId
}).ToList();
if (Fav.Count > 0)
 

Answers (1)