retrieve datarelation?

  • Thread starter Thread starter Lore Leuneog
  • Start date Start date
L

Lore Leuneog

Hello.

Is there any way to retrieve the DataRelation from the Database or do I
always have to build it manually after retrieving the tables structures?

Thank you
Sincerely

Lore
 
Hi Lore,

No, there is no automated way of retrieving relations from database.
You might use database specific DDL or OleDbConnection.GetOleDbSchemaTable
method to retrieve metadata you are interested int.
 
There are templates at http://www.ericjsmith.net/codesmith/ that will create
strongly typed datasets including relatinships in either VB.Net or C#.

Miha Markic said:
Hi Lore,

No, there is no automated way of retrieving relations from database.
You might use database specific DDL or OleDbConnection.GetOleDbSchemaTable
method to retrieve metadata you are interested int.

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

Lore Leuneog said:
Hello.

Is there any way to retrieve the DataRelation from the Database or do I
always have to build it manually after retrieving the tables structures?

Thank you
Sincerely

Lore
Click to expand...
Click to expand...
 
Not to mention those on www.rthand.com under .net utilities :-)

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

Jim Hughes said:
There are templates at http://www.ericjsmith.net/codesmith/ that will
create strongly typed datasets including relatinships in either VB.Net or
C#.

Miha Markic said:
Hi Lore,

No, there is no automated way of retrieving relations from database.
You might use database specific DDL or
OleDbConnection.GetOleDbSchemaTable method to retrieve metadata you are
interested int.

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

Lore Leuneog said:
Hello.

Is there any way to retrieve the DataRelation from the Database or do I
always have to build it manually after retrieving the tables structures?

Thank you
Sincerely

Lore
Click to expand...
Click to expand...
Click to expand...
 
Back
Top