I have a table "Connections" which has 2 "ParentConnections" (e.g. for a virtual Connection, which has 2 different physical Connections at each end).
So in my Form I have 2 ParentConnections and also 2 ClientConnections which will be generates via the 2 existing foreign key constraint. But now I want some sort of union of these 2 ClientConnections: Like a new Column - maybe a partial class - which contains
the two EntitySets of ClientConnections and get displayed on the List Page with a DropDownList, so that I can see, which Connections have the selected Connection as ParentConnection1 or ParentConnection2. They combined column should also appear on the details
page.
Soennichsen
Member
19 Points
17 Posts
Combine multiple hierarchy columns
Jan 25, 2012 01:00 PM|LINK
Hi,
I have a table "Connections" which has 2 "ParentConnections" (e.g. for a virtual Connection, which has 2 different physical Connections at each end).
So in my Form I have 2 ParentConnections and also 2 ClientConnections which will be generates via the 2 existing foreign key constraint. But now I want some sort of union of these 2 ClientConnections: Like a new Column - maybe a partial class - which contains the two EntitySets of ClientConnections and get displayed on the List Page with a DropDownList, so that I can see, which Connections have the selected Connection as ParentConnection1 or ParentConnection2. They combined column should also appear on the details page.
Any ideas how I can implemend this?
Thanks in advance
Sven
http://sven-s.de
http://twitter.com/sven_s
sjnaughton
All-Star
27308 Points
5458 Posts
MVP
Re: Combine multiple hierarchy columns
Jan 25, 2012 08:58 PM|LINK
if there is a relationship in the DB this should happen automatically see Employees table in Northwind.
Always seeking an elegant solution.