Devart Forums

Posted: **Fri 14 Oct 2011 19:00**

There seems to be a bug that if your Code First model does not contain any AutoNumber (DatabaseGeneratedOption.Identity) Columns, then it will not initialize the schema (create the tables).

It sends the following command:

Code: Select all

SELECT COUNT(*)
  FROM SYS.ALL_SEQUENCES
 WHERE

and it errors out because it has an incomplete WHERE statement, and then creates no tables...

If I create a dummy table with an AutoNumber column, then it works:

Code: Select all

SELECT COUNT(*)
  FROM SYS.ALL_SEQUENCES
 WHERE (SEQUENCE_OWNER = SYS_CONTEXT('USERENV', 'CURRENT_SCHEMA') AND SEQUENCE_NAME = 'Dmy_SEQ')

Posted: **Mon 24 Oct 2011 12:19**

We have reproduced the problem with incomplete SQL. We will investigate the issue and notify you about the results.

Posted: **Thu 27 Oct 2011 10:31**

The bug with Database.Exists() when there is no entities with DatabaseGeneratedOption.Identity in model is fixed. We will post here when the corresponding build of dotConnect for Oracle is available for download.

Posted: **Fri 11 Nov 2011 16:23**

New build of dotConnect for Oracle 6.50.244 is available for download now!
It can be downloaded from http://www.devart.com/dotconnect/oracle/download.html (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to http://www.devart.com/forums/viewtopic.php?t=22547 .

Devart Forums

Oracle EF 4.1 Code First with no AutoNumber Column

Oracle EF 4.1 Code First with no AutoNumber Column