var Image = (from TV in _context.TblEducationalVideo
join TBE in _context.TblEducationImageCategoryMaster on TV.EducationImageCategoryId equals TBE.EducationImageCategoryId
select new
{
TBE.EducationImageCategoryId,
TBE.EducationImageCategoryName,
TV.Title,
TV.ImagePath,
TV.EducationalId,
TV.ImageStatus
}).ToList();
It's my query i have use this get data from two table .But response very late max 5 min this show record.
How to solve this,
Junaid MuslaPosted Oct 12, 2020, 5:56 AM
Did you checked the response time in sql ? Try to fire same query in sql and check the response time. If ithe response time is same as that in entity framework then it will be the issue at server side.