paha wrote:
> maybe i don't understand what is made behind the curtain, but ... when
> provider populates schema for table, it checks if primary key for the table
> consists of 1..x fields (if any pk at all :-) ), and creates an array of
> DataColumn for the PrimaryKey property of DataTable, doesn't it? Could he do
AFAIK this is done by FW.
> just the same for constraints? I cannot agree, that it's not a bug, i have a
> table with unique constraint, i read it with dataadapter and get exception,
It's a bug, but probably on other side. The PK is created from schema
table from IsKey column. And because PK can be only one in a table, FW
creates composite PK on every column. But for IsUnique FW has no idea
about composite of simple keys - it's probably reason why mssql's
provider is doing what he's doing.
> because Constrains Collection was created wrong and data is consistent. I
> could fix it by creating Constraints collection manually, but this means, i
> should make such steps for every table i read (imho provider should make
> this job done). Can we ask Carlos, waht he thinks of this issue, i don't
> insist on anything, but...if you don't mind?
If Carlos is here, why not.
--
Jiri {x2} Cincura
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
