mysql Query Changing LINQ to Entitities of DB

Question

Select idSubmit_FlagAnswer(select name from question tb1 where tb1.question_id=tb2.secretQuestionID)Question from Vendor tb2 where AAA=@AAA and Type=@type;  this is mysql Query But I want to change the query in LINQ to Entities.

Abhishek Jain · Answer

Hi Suppose in my example i am considering tbl1 as Entity1 and tb2 as Entity2 List entity1List = new List (); List entity2List = new List (); List filteredList = new List (); Pleas let Entity2 have a property Name var aaa = ; var type = ; filteredList = entity2List.Where(elw => elw.AAA == aaa && elw.Type = type).Select(els => new Entity2() { Id = els.Id SubmitFlag = els.SubmitFlag Answer = els.Answer Name = entity1List.Where(elfw => elfw.QuestionId = els.SecretQuestionId).Select(elf => on.Name).First() }).ToList();