Provider Type Problem on PostgreSQL
Posted: Fri 03 Dec 2010 19:59
Good evening,
I'm having trouble with the Provider Type for fields of type Boolean.
After you create a DataTable with TableAdapter Configuration Wizard, Visual Studio 2010, all commands (update, insert and remove) are correct.
The parameters for SqlCommands that are of type Boolean are:
DbType Boolean
ProviderType: Boolean
But once we make any changes on the table, is adding a new column or changing the update command, for example, the parameters of my SQL Command that are of type Boolean point as:
DbType Boolean
ProviderType: Int
Therefore, I must review parameter by parameter in each SqlCommand to adjust ProviderType: Int ProviderType for Boolean, as it was originally.
Any idea what might be happening? Some specific parameter in my StringConnection?
One thing I noticed was the Devart DataTables that he has no exclusive to the database in which I'm connecting. I saw the Devart for PostgreSQL has also PgSQLDataTables.
Does this not causing any problems?
Can I enable the use of PgSQLDataTables even having bought the package Universal (for all platforms Database)
I am using version 3.20.16.00 of the Devart dotConnect Professinal Universal." with the platform. NET Framework 4.0 and I configured the CommandTimeout property to zero before executing the query.
I'm having trouble with the Provider Type for fields of type Boolean.
After you create a DataTable with TableAdapter Configuration Wizard, Visual Studio 2010, all commands (update, insert and remove) are correct.
The parameters for SqlCommands that are of type Boolean are:
DbType Boolean
ProviderType: Boolean
But once we make any changes on the table, is adding a new column or changing the update command, for example, the parameters of my SQL Command that are of type Boolean point as:
DbType Boolean
ProviderType: Int
Therefore, I must review parameter by parameter in each SqlCommand to adjust ProviderType: Int ProviderType for Boolean, as it was originally.
Any idea what might be happening? Some specific parameter in my StringConnection?
One thing I noticed was the Devart DataTables that he has no exclusive to the database in which I'm connecting. I saw the Devart for PostgreSQL has also PgSQLDataTables.
Does this not causing any problems?
Can I enable the use of PgSQLDataTables even having bought the package Universal (for all platforms Database)
I am using version 3.20.16.00 of the Devart dotConnect Professinal Universal." with the platform. NET Framework 4.0 and I configured the CommandTimeout property to zero before executing the query.