Wildly inconsistent and incorrect values...

[tracker1]

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]

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.