Wildly inconsistent and incorrect values...

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
tracker1
Posts: 1
Joined: Fri 28 Jun 2013 18:45

Wildly inconsistent and incorrect values...

Post by tracker1 » Mon 22 Jul 2013 17:32

Given the following table fields...

Code: Select all

  CREATE TABLE "EMPLOYEES" (
    "EMPLOYEEID"  NUMBER  NOT NULL
    ,...
    ,"AVAILABLEREGULARDAYS"  NUMBER  NOT NULL
  )

The following query...

Code: Select all

  SELECT EmployeeId, AvailableRegularDays 
  FROM Employees 
  WHERE IsEligible = 'Y'
  ORDER BY SeniorityNumber

Returns the following values...

Code: Select all

  24    30
  80    30
  1     30
  2     30

In C# EF code, I get the following values for an equivalent query...

Code: Select all

  24    0
  80    866
  1     816
  2     741
WTF?!?

Devart.Data v5.0.701.0
Devart.Data.Oracle v7.7.242.0
Devart.Data.Oracle.Entity v7.7.242.0

Shalex
Devart Team
Posts: 8083
Joined: Thu 14 Aug 2008 12:44

Re: Wildly inconsistent and incorrect values...

Post by Shalex » Tue 23 Jul 2013 08:13

Please turn on the dbMonitor tool and make sure that EF query generates the same SQL:
http://www.devart.com/dotconnect/oracle ... nitor.html
http://www.devart.com/dbmonitor/dbmon3.exe

If this tip doesn't help, send us a small complete test project for reproducing.

Post Reply