Hello,
I’m using EF4, I have a master-detail relation, the master entity is “Students” and the detail entity is “Grades”, I can reach the detail entity like the following:Students.Grades
My problem is: When I get the master- detail entities I need some columns to show in the detail entity “Grades” that are existing in the other entities, So I was thinking to do the following:
-Use a stored procedure to get the detail columns from the related tables in the database.
-Send the result to a complex type “GradesComplex” in my web application.
-Connect the complex type to the master entity “Students”
-Reach to the new detail data like the following Students.GradesComplex
Is the above solution the right way? If not is there another solution that you recommend??
As always, your advice is greatly appreciated...