How to configure fluent nHibernate with MySQL

Question

I'm trying to configure nHibernate to use a MySql database. I found examples for mssql and sqlite but none for mysql. So, how do I change this so it uses mysql:

Fluently.Configure().Database(
        MsSqlConfiguration.MsSql2005.ConnectionString(
            c => c.FromConnectionStringWithKey("ConnectionString")
        )
    )
    .Mappings(m => m.FluentMappings.AddFromAssemblyOf<MyAutofacModule>())
    .BuildSessionFactory())

Mark Rogers · Accepted Answer · 2016-10-30 02:25:02Z

49

Change MsSqlConfiguration.MsSql2005, to MySqlConfiguration.Standard, it was the one thing I contributed to the project.

Example:

Fluently.Configure().Database(
        MySqlConfiguration.Standard.ConnectionString(
            c => c.FromConnectionStringWithKey("ConnectionString")
        )
    )
    .Mappings(m => m.FluentMappings.AddFromAssemblyOf<MyAutofacModule>())
    .BuildSessionFactory())

edited Oct 30, 2016 at 2:25

answered Mar 9, 2009 at 14:00

Mark Rogers

97.9k19 gold badges92 silver badges142 bronze badges

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

8 Comments

Spikolynn Over a year ago

Thank you, funny I missed this.

jake Over a year ago

signed in just to vote you guys up. now, can someone help me with nhibernate? i get error unable to create drive for mysql

Mark Rogers Over a year ago

Cool, you might want to ask a whole new question with as much details as you can possibly give. I'm not familiar with that error off hand, so I can't give you much help without more details. I will say that the error sounds unusual, I don't think I've ever got that one and I mess around with Fluent NHib and MySql all the time.

Mark Rogers Over a year ago

Yes, I did need a driver from MySql Connector, specifically a reference to MySql.Data. I don't think the version is relevant as long as it's not an ancient one. I've never had a problem in terms of which version I was using. I don't think FluentNhibernate directly references the MySql.Data library, so there should not be a version mismatch.

Chazt3n Over a year ago

I actually was able to solve the problem using MySQLcon... instead of MySql... it has had to have changed, because in every resource I see how you have it. Thank you for the response good sir.

|

Spikolynn · Accepted Answer · 2017-09-13 16:23:21Z

0

var SessionFactory = Fluently.Configure()
    .Database(MySQLConfiguration.Standard.ConnectionString(connectionString))
    .Mappings(m => m.FluentMappings.AddFromAssembly(Assembly.GetExecutingAssembly()))
    .BuildSessionFactory();`

Try this Configuration.

edited Sep 13, 2017 at 16:23

Spikolynn

4,1932 gold badges40 silver badges49 bronze badges

answered Nov 20, 2014 at 7:42

Mohit Arora

3576 silver badges19 bronze badges

Collectives™ on Stack Overflow

How to configure fluent nHibernate with MySQL

2 Answers 2

8 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

8 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related