Could not create the driver from NHibernate.Driver.SqlClientDriver,

76 views
Skip to first unread message

ho ihu

unread,
Jan 2, 2022, 11:21:25 AMJan 2
to nhusers
Dear all,
I am using FluentNhibernate in .Net 6. I want to do crud operations on mssql. 
my code and the error is as below. the sam code is working with framework 4.8 but not working in .net 6

Error: could not create the driver from nhibernate.driver.sqlclientdriver, nhibernate, version=5.3.0.0, culture=neutral, publickeytoken=aa95f207798dfdb4

Code in .net 6 mvc project
    public class DatabaseContext
    {
        private static ISessionFactory session;

        private static ISessionFactory CreateSession()
        {
            const string connectionString = "Data source=HAFIZULLAH-OZGU\\SQLEXPRESS;Database=IHU_AcademicPerformance;Integrated Security=True";

            if (session != null)
            {
                return session;
            }
            var sqlConfiguration = MsSqlConfiguration.MsSql2012.ConnectionString(connectionString);

            return Fluently.Configure()
                .Database(sqlConfiguration)
                .Mappings(m => m.FluentMappings.AddFromAssemblyOf<TokenMapping>())
                .ExposeConfiguration(cfg => new SchemaExport(cfg).Execute(false, true, false))
                .BuildSessionFactory();

        }
        public static NHibernate.ISession SessionOpen()
        {
            return CreateSession().OpenSession();
        }
    }

I will be happy for your valuable helpings.

Frédéric Delaporte

unread,
Jan 2, 2022, 11:24:37 AMJan 2
to nhusers
The exception inner exception details is surely telling what is the trouble. Something like a missing dependency: the default driver for MsSql requires System.Data.SqlClient, which is no more part of the base framework in .Net Core. You have to add a reference on it.

Alexander Zaytsev

unread,
Jan 2, 2022, 6:54:55 PMJan 2
to nhu...@googlegroups.com
Change

var sqlConfiguration = MsSqlConfiguration.MsSql2012.ConnectionString(connectionString);

To

var sqlConfiguration = MsSqlConfiguration.MsSql2012.Driver<MicrosoftDataSqlClientDriver>().ConnectionString(connectionString);


Best Regards,
Alexander

--
You received this message because you are subscribed to the Google Groups "nhusers" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nhusers+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/nhusers/ab81c6e8-07d3-4a20-8de5-2edb0fe5cf19n%40googlegroups.com.

ho ihu

unread,
Jan 4, 2022, 3:20:07 PMJan 4
to nhusers
Thank you bro, the problem solved with the mentioned driver.


3 Ocak 2022 Pazartesi tarihinde saat 02:54:55 UTC+3 itibarıyla haz...@gmail.com şunları yazdı:
Reply all
Reply to author
Forward
0 new messages