Hi
I am interested in DbConnection.GetSchema method of ODP.NET oracle library.
When I call (to get primary keys metadata)
DataTable pkeys = DbConnection.GetSchema("PrimaryKeys"...
foreach (DataRow dr in pkeys.Rows)
{
string pkTable = dr["TABLE_NAME"].ToString();
// COLUMN_NAME does not exist
//string columnName = dr["COLUMN_NAME"].ToString(); // Not Working in odp.net
}
I do not see a primary key column name in result.
In core GetOleDbSchema("PrimaryKeys"... method there was a column name called COLUMN_NAME.
How can I get primary key column names in this GetSchema method? Cause this is what I actually requested for.
Regards,
Sebastijan