Hi, there seems to be a problem when update data tables.
Reading and Adding new rows to tables is fine. But when we attempt to update an existing row.
The update performs correctly, but then is immediately followed by one or more of these errors:
Exception thrown: 'System.OverflowException' in mscorlib.dll
Exception thrown: 'System.FormatException' in mscorlib.dll
Exception thrown: 'System.InvalidCastException' in mscorlib.dll
This seems to have only started happening on Thursday. That seems to have coincided with a Windows 10 update.
I rolled back the windows update, but the problem still exists. I'm running Windows 10 version 2004: (10.0.19041 Build 19041)
It does not prevent the program from building/running, but when multiple updates happen it severely slows down development. For example, closing our setup menu item takes nearly 20 seconds in visual studio, but less than a second when running the same .exe outside of visual studio.
It does not appear to be limited to a single project either. Other project using dotConnect PostgreSQL have the same issue on this machine.
We are running:
Devart.Data.PostgreSql.PgSqlConnection, Devart.Data.PostgreSql, Version=7.3.201.0
and .Net Framework 4.7.2
Thanks
Lots of System.FormatException/OverflowException/InvalidCastExceptions
Re: Lots of System.FormatException/OverflowException/InvalidCastExceptions
Your provider version 7.3.201 10-Jul-14 is outdated. Please upgrade to the newest version 7.18.1730 17-Sep-20.
If this doesn't help, send us a small test project and specify the steps we should follow for reproducing the issue.
If this doesn't help, send us a small test project and specify the steps we should follow for reproducing the issue.