Number(1) as a part of primary key

Number(1) as a part of primary key

Postby motuzko » Fri 02 Apr 2010 00:24

1) Create a table where primary key is
Field1 NUMBER(9) NOT NULL
Field2 NUMBER(9) NOT NULL
Field3 NUMBER(1) NOT NULL

2) Add the table into the DataContext (LINQ to Oracle)

3) Change the Type of Field3 from Int32 to Boolean

4) try to retrieve records from the table

All the rows where the value of the boolean field was set to true will have false values
motuzko
 
Posts: 43
Joined: Tue 08 Sep 2009 18:02

Postby AndreyR » Fri 02 Apr 2010 13:17

I am unable to reproduce the problem at my side.
What version of dotConnect for Oracle are you using?
The following code gave me correct values:
Code: Select all
var q = db.Booleancompositepks.Select(c=>c).ToList();
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16


Return to dotConnect for Oracle