Multiple errors in your LINQ to Sql demo

robofx · Post by **robofx** » Wed 15 Apr 2009 22:47

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.

AndreyR · Post by **AndreyR** » Thu 16 Apr 2009 09:05

What version of dotConnect for PostgreSQL are you using?

robofx · Post by **robofx** » Thu 16 Apr 2009 21:20

Pro version 4.00.26

AndreyR · Post by **AndreyR** » Fri 17 Apr 2009 13:20

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.

robofx · Post by **robofx** » Fri 17 Apr 2009 14:59

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