Armin CSharp

Armin CSharp

  • 2k
  • 96
  • 6.8k

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

Nov 24 2019 1:38 PM
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 ! ;)
 

Answers (2)