I'm using
VS 2012 update 3
EF 6
Connector/Net 6.7.0.4
MySql for VS 1.0.2
for a C3 app that needs to connect to a remote 5.5.13 MySQL Community Server Db.
I have generated the edmx file an the entity/mapping/context classes from the Db and have an application that compiles... The issue is with the app.config file.
I've added the DbProviderFactory ...
<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.7.4.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" />
</DbProviderFactories>
But get the error
"Schema specified is not valid. Errors: \r\nCVCommand.ssdl(2,2) : error 0152: No Entity Framework provider found for the ADO.NET provider with invariant name 'MySql.Data.MySqlClient'. Make sure the provider is registered in the 'entityFramework' section of the application config file. See
http://go.microsoft.com/fwlink/?LinkId=260882 for more information."
I presume that this in inferring that I need to add an entry in to the <entityFramework><providers> section. I have found an example on the net ...
<providers>
<provider invariantName="MySql.Data.MySqlClient"
type="MySql.Data.MySqlClient.MySqlProviderServices,
MySql.Data.Entity" />
</providers>
But that doesn't work.
So What do I need to do? Is EF6 supported.