1

I have a C# project running from about 8 years without problems. Using .net 4.8 c# entity framework 6 MySql and SqLite.

This year I would like to upgrade mysql db drivers from version 8 to 9.

After this upgrade, running the project inside visual studio I have no problem.

Building the setup and install to a brand new computer with windows 11, I have this exception:

Using the same DbCompiledModel to create contexts against different types of database servers is not supported.

Wasting some days to understand this problem without success. Read some old posts on this argument but nothing helped me.

<connectionStrings>
    <add name="LumenEntities" providerName="MySql.Data.MySqlClient" connectionString="server=localhost;port=3306;database=lumen;uid=root;pwd=root" />
</connectionStrings>

<entityFramework>
    <providers>
      <provider invariantName="MySql.Data.MySqlClient" type="MySql.Data.MySqlClient.MySqlProviderServices, MySql.Data.EntityFramework, Version=9.1.0.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" />  
    </providers>
</entityFramework>

If I can't find a solution I think to downgrade to version 8 of the driver. Any help is apreciated.

Improve this question
Related questions
842
How can I retrieve Id of inserted entity using Entity framework?
817
Fastest Way of Inserting in Entity Framework
2440
Should 'using' directives be inside or outside the namespace in C#?
Load 6 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.