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!