Devart Forums

Errors in your LINQ to Sql demo "VBasicLinqDemo.sln" as follows:

1. Queries.vb project:
All queries work fine EXCEPT:
"Orders for German companies" -- error is "PgSqlException was unhandled" and "invalid input syntax for type interval: "United Kingdom" at line 158 of MainForm.vb

2. MasterDetail.vb project:
When I change a company name in the dgCustomer datagridview and then click the toolstrip button labeled "Update" and named tsbUpdate, it generates error "DB concurrency violation" at line 38 in MainForm.vb


3. SubmitChanges.vb project:
a) Receive error "DBConcurrencyException" when change a company name and then click "Update" button -- error is at line 12 of Mainform.vb

b) Receive popup messagebox error "Input string was not in a correct format" when I type a name (e.g. "Joe" without quotes) in any cell of the PrimaryContact column of the datagridview named dgCompany


Please advise.

Also, I don't mind to send you "a small sample project showing the errors" but in this case, you already have it: that is to say, the demo project that ships with your software.

I emailed these details to support also. Thanks.

What version of dotConnect for PostgreSQL are you using?

Pro version 4.00.26

Thank you for the report, we have already found the problem.
The current 5.20.27 Beta build of dotConnect for PostgreSQL includes the modified version of LINQ samples.
The new Release build will also contain this modified version.

Ok. Thank you very much for the prompt reply and the information.