<div>
<div class="content wysiwyg-content">
Hi... 
 
Is it possible to get the tables relations using the DbConnection.GetSchema? 
 
I'm able to get everything else I need except the relations. 
 
I can list the foreignkeys using: Connection.GetSchema(&quot;ForeignKeys&quot;); 
 
And the available options I think I have are: 
MetaDataCollections 
DataSourceInformation 
DataTypes 
Restrictions 
ReservedWords 
Users 
Databases 
Tables 
Columns 
StructuredTypeMembers 
Views 
ViewColumns 
ProcedureParameters 
Procedures 
ForeignKeys 
IndexColumns 
Indexes 
UserDefinedTypes 
 
 
Is it possible? 
 
Thanks, 
Alex
</div>
</div>

Hi...

Is it possible to get the tables relations using the DbConnection.GetSchema?

I'm able to get everything else I need except the relations.

I can list the foreignkeys using: Connection.GetSchema("ForeignKeys");

And the available options I think I have are:
MetaDataCollections
DataSourceInformation
DataTypes
Restrictions
ReservedWords
Users
Databases
Tables
Columns
StructuredTypeMembers
Views
ViewColumns
ProcedureParameters
Procedures
ForeignKeys
IndexColumns
Indexes
UserDefinedTypes


Is it possible?

Thanks,
Alex

Get table relations using DbConnection.GetSchema

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.