Number(1) as a part of primary key

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
motuzko
Posts: 54
Joined: Tue 08 Sep 2009 18:02
Contact:

Number(1) as a part of primary key

Post by 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

AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by 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();

Post Reply