How to get Unique columns and Primary key constraints using SqlConnection.GetSchema()

[waleed_cs2000]

hi
I have some code of ADO.net to dynamically detect the database schema, what I need is how to get Unique columns constraints and Primary key constraints using SqlConnection GetSchema() method.
thanks

[kvprajapati]

Welcome waleed_cs2000,
GetSchema() Method return a DataTable instance.
Use "IndexColumns" argument to list the primary key meta info.

var lst =  dc.Connection.GetSchema("IndexColumns") ;

[waleed_cs2000]

Welcome waleed_cs2000,
GetSchema() Method return a DataTable instance.
Use "IndexColumns" argument to list the primary key meta info.

var lst =  dc.Connection.GetSchema("IndexColumns") ;

thanks a lot , that helped me, but is there any way to differntiate unique columns from primary keys in this method?

thanks