Cannot add Model from Database using EF6
Posted by: Tim Snyder
Date: September 08, 2014 07:45AM

X Your project references the latest version of Entity Framework; however, an Entity Framework database provider compatible with this version could not be found for your data connection. …

I have read many threads in this forum and via Google. I have installed everything in the proper order and copied dlls to the Private Assemblies and the app bin file. Nothing I've tried allows be to add the Model.

There must be something else that 2 days of research have not uncovered. Help would be greatly appreciated.

Environment:
MySql Server 5.6.20
Windows Server 2012 R2

Development Environment
Win 8.1 Pro
VS-2013 Pro Update 3
.Net Framework 4.5.1
EF 6.1.1.0
MySql for Visual Studio plugin 1.2.3
Connector/Net 6.8.3

V4.5 folder dlls copied to ..\Private Assemblies
Added references to
• MySql.Data
• MySql.Data.Entity.EF6
• MySql.Web

Relevant sections of web.config
<entityFramework>
<defaultConnectionFactory type="MySql.Data.Entity.MySqlConnectionFactory, MySql.Data.Entity.EF6" />
<providers>
<provider invariantName="System.Data.SqlClient"
type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" />
<provider invariantName="MySql.Data.MySqlClient"
type="MySql.Data.MySqlClient.MySqlProviderServices, MySql.Data.Entity.EF6" />
</providers>
</entityFramework>
<system.data>
<DbProviderFactories>
<clear />
<add name="MySQL Data Provider" invariant="MySql.Data.MySqlClient"
description=".Net Framework Data Provider for MySQL"
type="MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data,
Version=6.8.3.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" />
</DbProviderFactories>
</system.data>
<connectionStrings>
<add name="myaddressEntities3"
connectionString="provider=MySql.Data.MySqlClient;
provider connection string=&quot;server=192.168.2.4;
user id=xxxxxx;password=yyyyyy;
persistsecurityinfo=True;database=myaddress&quot;" providerName="System.Data.EntityClient" />
</connectionStrings>

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.