using migration with both System.Data.SqlClient and Devart.Data.Oracle

Discussion of open issues, suggestions and bugs regarding Entity Framework support in ADO.NET Data providers
Post Reply
ordelmans
Posts: 1
Joined: Tue 09 Dec 2014 09:25

using migration with both System.Data.SqlClient and Devart.Data.Oracle

Post by ordelmans » Tue 09 Dec 2014 09:38

Our product is tested using SqlServer, but for production it will be deployed on Oracle.

We use code first migrations, with automatic migrations disabled. We call new DbMigrator(config).Update() to initialize the database intially.

If I generate the initial migration targetting SqlServer it doesn't work on Oracle (complains about pending model changes) and if I generate the initial migration targetting Oracle it doesn't work on SqlServer.

The generated migration class contains only one difference (precision = 7 for a DateTime field).

Is there a way to create an initial migration that works with both System.Data.SqlClient and Devart.Data.Oracle ?


Post Reply