ProviderIncompatibleException

ProviderIncompatibleException

Postby Breach » Thu 20 Jan 2011 03:14

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?

name="ConnectionString"
connectionString="Server=localhost;User ID=xxx;Password=xxx;"
providerName="Devart.Data.Oracle" />



description="Devart dotConnect for Oracle"
type="Devart.Data.Oracle.OracleProviderFactory, Devart.Data.Oracle,
Version=6.0.86.0, Culture=neutral, PublicKeyToken=09af7300eec23701" />
:?:
Breach
 
Posts: 2
Joined: Wed 19 Jan 2011 14:30

Postby AndreyR » Fri 21 Jan 2011 10:37

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:
Code: Select all

The solution for the problem of "dbo" schema was discussed here.

P.S. I have deleted your duplicate post.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Postby Breach » Mon 24 Jan 2011 20:00

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
Breach
 
Posts: 2
Joined: Wed 19 Jan 2011 14:30

Postby AndreyR » Tue 25 Jan 2011 14:49

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.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16


Return to dotConnect for Oracle