this is mysql Query But I want to change the query in LINQ to Entities.
"
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Abhishek JainPosted Aug 29, 2013, 9:32 AM
Suppose in my example i am considering tbl1 as Entity1 and tb2 as Entity2
List
List
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();