[Mono-dev] RV: Trying figure out EF6

[Raul U.]

Hi Daniel, that is not all the truth, I think. Entity Framework 6 has some
“little” breaking changes:

 

-
http://entityframework.codeplex.com/wikipage?title=Rebuilding%20EF%20provide
rs%20for%20EF6

-
http://entityframework.codeplex.com/wikipage?title=Updating%20Applications%2
0to%20use%20EF6

 

I´ve managed to do this changes. Unfortunately, there are some minor error
after that
 for instance, _migrationhistory table comes with a compound
primary key index, too long for MySql (see
http://entityframework.codeplex.com/discussions/403680 for details) and
more...

 

I hope those things can be fixed soon, I´ll post back about it if someone is
interested in.

 

 

De: daniel at d15.biz [mailto:daniel at d15.biz] En nombre de Daniel Lo Nigro
Enviado el: sábado, 10 de noviembre de 2012 1:51
Para: Raul U.
CC: mono-devel-list
Asunto: Re: [Mono-dev] Trying figure out EF6

 

Entity Framework uses the standard ADO.NET providers, so most ADO.NET
providers should work with it. This includes the MySQL one, which comes with
Ubuntu and Debian in the "libmysql6.4-cli" package, or you can download it
from http://dev.mysql.com/downloads/connector/net/. Just reference
MySQL.Data.dll and set up your App.config or Web.config correctly. Here is
an example config:

 

<?xml version="1.0" encoding="utf-8"?>

<configuration>

     <system.data>

          <DbProviderFactories>

              <add name="MySQL Data Provider"
invariant="MySql.Data.MySqlClient" description=".Net Framework Data Provider
for MySQL" type="MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data" />

          </DbProviderFactories>

     </system.data>

     <connectionStrings>

      <add name="BloggingContext" 

           connectionString="Server=localhost; Database=dotnettest;
Uid=root; Pwd=password"

           providerName="MySql.Data.MySqlClient" />

     </connectionStrings>

</configuration>

 

 

Obviously, change all the placeholder values (context name, server name,
database, username, password). You will need to use a very recent version of
Mono (3.0.1 or trunk) due to bug 7396
<https://bugzilla.xamarin.com/show_bug.cgi?id=7936> .

 

On Sat, Nov 10, 2012 at 7:45 AM, Raul U. <ruria60 at yahoo.es> wrote:

Hi, I´m trying to use Entity Framework, I would like to use MySql. In my
understanding there is no EF6 provider yet, so this is not possible. In
fact, I only found two providers available for EF, SQL Server and SQL CE.

 

Is this right? Is there any other option out there?

 

Thx.

 


_______________________________________________
Mono-devel-list mailing list
Mono-devel-list at lists.ximian.com
http://lists.ximian.com/mailman/listinfo/mono-devel-list

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ximian.com/pipermail/mono-devel-list/attachments/20121128/9952cdb8/attachment.html>