Display data from two table

Hi
I can displya record from single table with this code

 var query = _mgr.STUDENTs;
query.ExecuteAsync(op => op.Results.ForEach(Students.Add));
   StudentGrid.ItemsSource = Students;

but I like to make join with another table and wanted to show data in single grid

for that i write this linq
var query2 = from STUDENT in Students
                             join SORDER in Sorders
                             on STUDENT.ID equals SORDER.SORDER_ID
                             select new
                             {
                                 STUDENT.ID,
                                 STUDENT.NAME,
                                 STUDENT.ADDRESS,
                                 SORDER.SORDER_ID,
                                 SORDER.OCITY
                             };
               
problem is I am not able to bind this query with datagrid

any help?

I try to assing but giving error

There is no ExecuteAsync() for query2

query.Ex....



Do you know How can I assing with this query. I made query with lambda but they also have error

Hi

This is still giving error
EntityManager.Students

Error:Does not contrain the defination of Students and no extension method studen accepting first
arugment type 'Students.Model.StudentEntities

Still i am stucking on this..


Thanks

Hi

Thanks very much

its working just need more figureout due to list.. but finally acheived result..

Thanks a Million..