Page 1 of 1

ProviderIncompatibleException

Posted: Thu 20 Jan 2011 03:14
by Breach
Hi,

I encounter a ProviderIncompatibleException when I try to conenct on a Oracle database with dotConnect and entity framework 4 ctp5. I have Oracle Express 10g and I download the trial version for Orace express today, so I have version number 6.0.86.0 of your dlls

Here's my config any idea?






:?:

Posted: Fri 21 Jan 2011 10:37
by AndreyR
This is a code snippet that worked for me

Code: Select all

public class MyOracleContext : DbContext {

    public DbSet Products { get; set; }
    public DbSet ProductCategories { get; set; }
    
    static MyOracleContext() {

      System.Data.Entity.Database.DbDatabase.SetInitializer(null);
    }

    protected override void OnModelCreating(ModelBuilder modelBuilder) {

      base.OnModelCreating(modelBuilder);

      modelBuilder.Conventions.Remove();
    }
  }
My connection string in app.config had the following structure: The solution for the problem of "dbo" schema was discussed here.

P.S. I have deleted your duplicate post.

Posted: Mon 24 Jan 2011 20:00
by Breach
It seems that the problem was related to the version of dotConnect that I downloaded. It didnt work with dotConnect for Oracle 6.00 Express but it worked with dotConnect for Oracle 6.00 Professional Trial

Posted: Tue 25 Jan 2011 14:49
by AndreyR
dotConnect for Oracle Express Edition is not intended for Oracle Express database. It is just a free edition having support for basic ADO.NET connectivity only.
Entity Framework support is available in Professional (and Developer) editions of dotConnect for Oracle. You can try full functionality using Trial Edition; the only limitation is 30 days usage term limitation.
More information concerning editions is available in our Edition Matrix.