Entity Framework Question
C#
1
Posts
1
Posters
0
Views
1
Watching
-
How do I instantiate an EntityObject with a Referencekeys for browsable objects. I'd like to do an XML to LINQ then convert it back as an entity object. now my problem is when I do this.
GIVEN: XML from store procedure <Peoples> <People> <Name>name1</Name> <Work><Work> <Nickname>name1nick</Nickname> </People> </Peoples> People --> EntityObject People.Work --> Browsable Object (one to many relation) People.NickName --> Extended property, not a EdmScalarPropertyAttribute (just a simple custom scalar string property) var list = from peoples in XMLResult.Descendants("Peoples") select new People { Name = peoples.Element("Name").Value, Work = ??? (How do I load the this?), should I do (Work = _ObjectContext.Work.WorkID.Equals(peoples.Element("Work").Value), "Query in the object context?" Nickname = peopls.Element("Nickname").Value }; Now you might be thinking why not just do this... var list = from people [ObjectContext].People select people;
The reason is because People.NickName property is not a Table column, the data is generated from the stored procedure (which I had other processes) and is return as XML; If i skip People.Work it would give an error. hope its clear.