[Mono-devel-list] Problem with DbDataAdapter...

[Konstantin Triger]

Hello Francisco,

Does the Npqsql initialize each property? i.e. if some column is not a 
key, will the corresponding code succeed?
bool b = (bool)schemaTable["IsKey"];

No, currently I don't use any additional metadata, thanks :).

Regards,
Konstantin Triger



Francisco Figueiredo Jr. wrote:

>-----BEGIN PGP SIGNED MESSAGE-----
>Hash: SHA1
>
>Konstantin Triger wrote:
>  
>
>>Hello Hubert,
>>
>>There was a change during this week end: the Mainsoft changes were
>>merged into the trunk (they were previously available at
>>Mainsoft.System.Data branch).
>>
>>From the stack I suppose that PG provider does not fully initialize the
>>SchemaTable and some columns contain nulls.
>>
>>    
>>
>
>Hi Konstantin!
>
>Npgsql is returning the following metadata schema:
>
>
>		result.Columns.Add ("ColumnName", typeof (string));
>                result.Columns.Add ("ColumnOrdinal", typeof (int));
>                result.Columns.Add ("ColumnSize", typeof (int));
>                result.Columns.Add ("NumericPrecision", typeof (int));
>                result.Columns.Add ("NumericScale", typeof (int));
>                result.Columns.Add ("IsUnique", typeof (bool));
>                result.Columns.Add ("IsKey", typeof (bool));
>                result.Columns.Add ("BaseCatalogName", typeof (string));
>                result.Columns.Add ("BaseColumnName", typeof (string));
>                result.Columns.Add ("BaseSchemaName", typeof (string));
>                result.Columns.Add ("BaseTableName", typeof (string));
>                result.Columns.Add ("DataType", typeof(Type));
>                result.Columns.Add ("AllowDBNull", typeof (bool));
>                result.Columns.Add ("ProviderType", typeof (int));
>                result.Columns.Add ("IsAliased", typeof (bool));
>                result.Columns.Add ("IsExpression", typeof (bool));
>                result.Columns.Add ("IsIdentity", typeof (bool));
>                result.Columns.Add ("IsAutoIncrement", typeof (bool));
>                result.Columns.Add ("IsRowVersion", typeof (bool));
>                result.Columns.Add ("IsHidden", typeof (bool));
>                result.Columns.Add ("IsLong", typeof (bool));
>                result.Columns.Add ("IsReadOnly", typeof (bool));
>
>
>Please, let me know if you are using any other metadata info so I can
>add it accordingly.
>
>Thanks in advance.
>
>
>
>
>- --
>Regards,
>
>Francisco Figueiredo Jr.
>Npgsql Lead Developer
>http://gborg.postgresql.org/project/npgsql
>MonoBrasil Project Founder Member
>http://monobrasil.softwarelivre.org
>
>
>- -------------
>"Science without religion is lame;
>religion without science is blind."
>
>                  ~ Albert Einstein
>-----BEGIN PGP SIGNATURE-----
>Version: GnuPG v1.2.6 (GNU/Linux)
>Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
>
>iQEVAwUBQo30PP7iFmsNzeXfAQJaTwf9H85e6MGVDWo6uyE6jnewkaL5ivq7JS4z
>6/Vvwwk3xmMkj5WhKcF2wQa9Zo4RWZYpTcmT5uoyYJl68Yl5puSnNinWeSa7h5rg
>QTD9FXrhQ+IGvylGqS+U1reKC6JGJZC/A2fwJZPKYqjKh7MXutNy3cwERVzLqpYr
>kSxHLdQt7kIPC5arpzcQMjOMAhg96X/03XxqnrupO7ACAdqyoC/uCfRGWte3+DDZ
>UHg8Uka+OK0EsNPwVGUH7PpUWZp5Cn1qbiJ/eFJphaXTxZMLKKOTawvYVFI5lOxP
>qCDe4RsFjosp4kYOkS+m9UtKbtr0vp2euY8+Y7l6TjyRADHNijemQg==
>=BBjE
>-----END PGP SIGNATURE-----
>
>_______________________________________________
>Mono-devel-list mailing list
>Mono-devel-list at lists.ximian.com
>http://lists.ximian.com/mailman/listinfo/mono-devel-list
>  
>