Query results not matching actual data

Query results not matching actual data

Postby midnit » Tue 23 Mar 2010 19:57

We are having several issues where the result from a LINQ does not match the data that we expect and get from a sql query. My latest issue should return all the data in the table (232 rows) but it only returns 187. This is a straight query, no conditions. I am pretty frustrated at this point and need some ideas to discover where the problem lies.

Our other issue is a a query that depending on the conditions return wildly different data (rows) and neither reflected the actual results a sql query would. The resulting queries of the linq statements where too different to even diff. These conditions should not have resulted in any additional joins yet the resulting queries where vastly different.
midnit
 
Posts: 10
Joined: Tue 23 Mar 2010 19:50

Postby AndreyR » Wed 24 Mar 2010 11:11

Could you please send us the LINQ queries, generated queries and the queries you were expecting?
Please include the DDL scripts of the objects you are using.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16


Return to dotConnect for Oracle