It looks much improved, especailly for Oracle. I do have a question though about navigating the Object Graph of Entities.
I have create an a .rlinq model of tables in an Oracle 11g database. I have configured the associations in the model designer.
When I access the model from within the project that holds the model, I can navigate perfectly through the entities using dot notation:
DSTUModel.
EntityDiagrams1 cntxt = new DSTUModel.EntityDiagrams1();
var student = (from s in cntxt.STUDENT_DETAILs where s.STUDENT_ID == "9999999" select s).FirstOrDefault();
string teacherName = student.STUDENT_CLASS_SCHEDULEs[0].SCHOOL_CLASS_SCHEDULE.EMPLOYEE_DETAIL.FIRST_NAME;
So in this case I get a student entity and navigate to the student class schedule entity then to the school class schedule entity and then finally to the empolyee_detail entity.
This works fine.
But if I reference the model in a different project either through an assembly reference or a DataService, the navigation does not work.
So in the above query in can easily retrieve the first entity STUDENT_DETAIL , but when I access the related class property to get the collection of STUDENT_CLASS_SCHEDULEs, this collection is never retrieved.
I can retrieve the collection by doing a join in a linq query, but the dot notaion naviagion does not work.
I have tried setting the LoadBehavior property to Eager, but this has no effect.
I am not sure if I am just not getting something, or if this is by design.
If there is a way to use the dot notation navigation when accessing the model through an external assembly reference, could you point me in the right direction?
Is there some programmatic way I can create the the associations?
Thanks,
Alec von Brand