Entity framework 5.0 code-first with MySQL in WPF

Question

This walkthrough works great with SQL Express: http://msdn.microsoft.com/en-us/library/gg197522(v=VS.103).aspx

I would like it to work with MySQL. I've done some research but none of the techniques I've found has been able to do it for me. Ideally I would like to do something like this:

      <entityFramework>
    <defaultConnectionFactory type="MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data" />
  </entityFramework>

This doesn't work (I have MySQL Connector Net 6.5.4 installed & MySql.Data referenced). I've tried deriving from IDbConnection factory as shown in this class here: http://www.vworker.com/RentACoder/misc/BidRequests/ShowBidRequest.asp?lngBidRequestId=1563829

and then using:

      <entityFramework>
<defaultConnectionFactory type="SchoolModel.MySqlConnectionFactory, SchoolModel" />

but that doesn't work either. Can anybody please give me some pointers as to how to get this to work?

Many thanks.

It doesn't work is not a description of the problem. Do you receive any exception? What is an exception stack trace and message? — Ladislav Mrnka
– Ladislav Mrnka, Commented May 18, 2012 at 9:10
It doesn't work means that the techniques described above do not connect the code to the MySQL database. No exceptions, the application continues it's connection to the default SQLEXPRESS database. Thank you for your reply! — Shunyata Kharg
– Shunyata Kharg, Commented May 21, 2012 at 8:38
Just to verify the basics, do you have your connection string properly setup to connect to MySQL, or did you leave that at its defaults (which would be either SQL Express or SQL CE)? — Chris Moschini
– Chris Moschini, Commented Jun 2, 2012 at 19:20

technopriest · Accepted Answer · 2012-10-22 09:47:23Z

3

To use Connector 6.5.4 with code-first EF5 on VS2012 you need:

Install MySql Connector 6.5.4 msi
Open VS2012 x86 Command Prompt as Admin and execute:

gacutil /i "C:\Program Files (x86)\MySQL\Connector NET 6.5.4\Assemblies\v4.0\mysql.data.dll" gacutil /i "C:\Program Files (x86)\MySQL\Connector NET 6.5.4\Assemblies\v4.0\mysql.data.entity.dll"

Add in your project's App.config this code to <configuration> section:

<system.data> 
    <DbProviderFactories> 
        <remove invariant="MySql.Data.MySqlClient" />
        <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.5.4.0, Culture=neutral, 
            PublicKeyToken=c5687fc88969c44d"
        /> 
    </DbProviderFactories> 
</system.data>

Now add references to MySql.Data and MySql.Data.Entity to your solution and some code like this (I create MySqlConnection, then pass it to constructor of MyDbContext)

public class MyDbContext : DbContext
{
    public MyDbContext(DbConnection connection) : base(connection, true) { }    

    public DbSet<Product> Products { get; set; }
}

[Table("sund_jshopping_products")]
public class Product
{
    [Key]
    [Column("product_id")]
    public int Id { get; set; }
    [Column("product_ean")]
    public string Ean { get; set; }
    [Column("product_manufacturer_id")]
    public int OperatorId { get; set; }
    [Column("months_status")]
    public string MonthsStatus { get; set; }
    [Column("extra_field_5")]
    public string SideId { get; set; }
}

edited Oct 22, 2012 at 9:47

answered Oct 22, 2012 at 9:41

technopriest

1912 silver badges5 bronze badges

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

1 Comment

Joao Coelho Over a year ago

Can you give an example on how you create a MySql DbConnection object? Also, have you upgraded to MySql Connector 6.6.5.0 and come up with a different way to do it where you can specify everything in app.config?

Bart Calixto · Accepted Answer · 2012-10-12 18:24:30Z

1

Connector 6.5.4 does not support code-first with EF 5. Actually it does not support code first.

You can try using dot net connector (at least the trial version).

answered Oct 12, 2012 at 18:24

Bart Calixto

19.8k12 gold badges81 silver badges119 bronze badges

Comments

muruge · Accepted Answer · 2012-10-04 15:06:41Z

0

Did you set the Datasource to MySQL while setting up your db connection. Also, click and make sure "Test Connection" succeeds before trying a connection directly from the code.

enter image description here

edited Oct 4, 2012 at 15:06

answered Oct 4, 2012 at 14:58

muruge

4,1433 gold badges40 silver badges45 bronze badges

Collectives™ on Stack Overflow

Entity framework 5.0 code-first with MySQL in WPF

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related