Multiple errors in your LINQ to Sql demo

Multiple errors in your LINQ to Sql demo

Postby 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.
robofx
 
Posts: 8
Joined: Fri 14 Nov 2008 22:13
Location: East Coast, USA

Postby AndreyR » Thu 16 Apr 2009 09:05

What version of dotConnect for PostgreSQL are you using?
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Postby robofx » Thu 16 Apr 2009 21:20

Pro version 4.00.26
robofx
 
Posts: 8
Joined: Fri 14 Nov 2008 22:13
Location: East Coast, USA

Postby 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.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Postby robofx » Fri 17 Apr 2009 14:59

Ok. Thank you very much for the prompt reply and the information.
robofx
 
Posts: 8
Joined: Fri 14 Nov 2008 22:13
Location: East Coast, USA


Return to LinqConnect (LINQ to SQL support)