Entity Framework with working for mySQL Entity class

Question

I have this configuration:

<connectionStrings>
<!--<add name="NREticaretContext"
     connectionString="Data Source=localhost;Initial Catalog=myDBSqlServer;Persist Security Info=True;User ID=sa;Password=mypass;Timeout=20;"
     providerName="System.Data.SqlClient" />-->
<add name="NREticaretContext"
     connectionString="Server=localhost;Database=myDBMySQL;Uid=root;Pwd=mypass;port=3306;" providerName="MySql.Data.MySqlClient"/>

if I use first config setting(SQL Server) everythicg works fine in my project. But when I try to use second connection(mySQL) for mySQL connector which uses mySQL Entity Framework, application keeps on saying:

"Model compatibility cannot be checked because the EdmMetadata type was not included in the model. Ensure that IncludeMetadataConvention has been added to the DbModelBuilder conventions."

I have tried using :

protected override void OnModelCreating(DbModelBuilder modelBuilder)
    {
        modelBuilder.Conventions.Remove<IncludeMetadataConvention>();            
    }

in my Context class but it keeps on giving the same error... Your suggestions?

Devart · Accepted Answer · 2011-04-01 12:43:12Z

2

It seems that Connector /NET experiences some problems with EF 4.1 at the moment.
Try turning off the Initialization Strategy System.Data.Entity.Database.SetInitializer<MyContext>(null);
I recommend you to take a look at the Code First Support article at our blog. It describes some peculiarities of working with Code First in dotConnect for MySQL.

answered Apr 1, 2011 at 12:43

Devart

120k23 gold badges172 silver badges189 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Entity Framework with working for mySQL Entity class

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related