Page 1 of 1

Number(1) as a part of primary key

Posted: Fri 02 Apr 2010 00:24
by motuzko
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

Posted: Fri 02 Apr 2010 13:17
by AndreyR
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();