Wildly inconsistent and incorrect values...

Wildly inconsistent and incorrect values...

Postby 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
tracker1
 
Posts: 1
Joined: Fri 28 Jun 2013 18:45

Re: Wildly inconsistent and incorrect values...

Postby 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/docs/?dbmonitor.html
http://www.devart.com/dbmonitor/dbmon3.exe

If this tip doesn't help, send us a small complete test project for reproducing.
Shalex
Devart Team
 
Posts: 7530
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle