how to using Microsoft.Data.SqlClient fluent-nhibernate

[rogeryamato]

Is fluent-nhibernate can use Microsoft.Data.SqlClient?

And how to use it..

I see in this issue nhibernate/nhibernate-core#2216 has fix it, But how about for fluent-nhibernate?

Thanks.

[gliljas]

Fluent NHibernate is used for mapping and doesn't care how NHibernate connects to the database.

[jornhd]

You need to add .Driver<MicrosoftDataSqlClientDriver>() in the configuration:

Fluently.Configure()
    .Database(
        MsSqlConfiguration.MsSql2012
            .Driver<MicrosoftDataSqlClientDriver>()
            .ConnectionString(connectionString)
    )
    .Mappings(...)
    .BuildSessionFactory();