Hi, I am working on an SQL Server client for .NET and I have created a simple recordlist class that accepts a table or row-returning sql command on construction and provides a list view of the resultant query. It would be good if i could create a relationship-aware version of the recordlist class, that could determine if a particular field forms part of a relationship and if so perform the required lookups. I've looked over the dataadapter and dataset classes and they appear to work the other way around, i.e you impose a set of relationships upon your queries or define them using data shaping. I understand that the relationships are stored in the dtproperties system table, so i guess it must be possible to create a stored proc or function to return the relationship properties of any database column. But i dont want to implement this myself if the sqlclient consumer classes can do it. If anyone can offer advice, i'd be most greatful as im a little unsure of how best to proceed and I dont want to waste time reinventing wheels! regards and happy new year!
Hi papalazarou: I don't have VS with me here, but as I can remember, you can look for the ParentRows or ChildRows in the corresponding DataRow. Hope this helps, -- Rafael "papalazarou" wrote: > Hi, > > I am working on an SQL Server client for .NET and I have created a simple > recordlist class that accepts a table or row-returning sql command on > construction and provides a list view of the resultant query. > > It would be good if i could create a relationship-aware version of the > recordlist class, that could determine if a particular field forms part of a > relationship and if so perform the required lookups. > > I've looked over the dataadapter and dataset classes and they appear to work > the other way around, i.e you impose a set of relationships upon your queries > or define them using data shaping. > > I understand that the relationships are stored in the dtproperties system > table, so i guess it must be possible to create a stored proc or function to > return the relationship properties of any database column. But i dont want to > implement this myself if the sqlclient consumer classes can do it. > > If anyone can offer advice, i'd be most greatful as im a little unsure of > how best to proceed and I dont want to waste time reinventing wheels! > > regards and happy new year!
