Parker, Basically I am using a table with self join, like Employee table, which also have a column of BossId( in my case parented).
Although it's very simple using SQL or LINQ, but I am bound due to *.edmx file (image attached) Entity Framework etc. Under Navigation properties ProgressNoteType1 is parent Object. Understand.? Thanks in advance. Rregards, -N From: Jonathan Parker [mailto:[email protected]] Sent: Friday, February 06, 2009 11:14 AM To: [email protected] Subject: Re: Selft Join Please elaborate. On Fri, Feb 6, 2009 at 4:26 PM, Muhammad Niaz <[email protected]> wrote: PFA, Hi all, Can anybody help me in this regards, Here is the scenario, I have a table, with Id, Description, ParentId, (selft join). i want to get the records using Entity Framework and LINQ query. Thanks in Advance. Niaz _____ Support procedure: https://www.codify.com/lists/support List address: <mailto:[email protected]> [email protected] Subscribe: <mailto:[email protected]> [email protected] Unsubscribe: <mailto:[email protected]> [email protected] List FAQ: <http://www.codify.com/lists/ozsilverlight> http://www.codify.com/lists/ozsilverlight Other lists you might want to join: <http://www.codify.com/lists> http://www.codify.com/lists _____ Support procedure: https://www.codify.com/lists/support List address: <mailto:[email protected]> [email protected] Subscribe: <mailto:[email protected]> [email protected] Unsubscribe: <mailto:[email protected]> [email protected] List FAQ: <http://www.codify.com/lists/ozsilverlight> http://www.codify.com/lists/ozsilverlight Other lists you might want to join: <http://www.codify.com/lists> http://www.codify.com/lists -------------------------------------------------------------------------------- Support procedure: https://www.codify.com/lists/support List address: [email protected] Subscribe: [email protected] Unsubscribe: [email protected] List FAQ: http://www.codify.com/lists/ozsilverlight Other lists you might want to join: http://www.codify.com/lists
