load related tables in one gridview with EF (Without Join)

Armin CSharp

Hello Friends, I have 3 tables with relation between them.

for example

pic 1

after this i made a EntityDataModel (EDM) for my database ( DBFirst)

and i want to load all the data in one datagrid view is it possible for this tables ?

because one my relations is 1:N

how can i load all data in one datagrid view without Join in linq ( Creating ViewModel or AnonymousType)

when i use that line of code for DataSource Property of Datagridview ... my gridview is like this ..

notice that again : i dont want to use join is it possible for entity framework to do this ?

Thank You ! ;)

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Dhara Patel7y ago
Hi, Without join use multiple table. LINQ: from p in Tbl_Student from c in Tbl_StudenDetails from m in Tbl_StudentTerm where c.studentID == p.studentID && m.StudentID == p.studentID select new { p.FirstName, c.FatherName,m.CurrentBook};
+1
Salman Beg7y ago
Hi.As per my knowledge, without join it is not possible. Thanks.
+1