There is no need for a 2019 dialect. The 2012 one works just fine with any newer SQL Server version. Newer dialects are provided only when NHibernate may need to directly use some new features of the newer database versions. By example, the 2012 dialect make use of offset fetch paging syntax, while previous versions are using the sub-query trick with row_number. (A lot of new features do not require any changes in NHibernate.)
The trouble with the driver is not related to the dialect version, but most likely to your application targeting .Net Core without taking a dependency on System.Data.SqlClient. The default driver for SQL Server depends on it, but under .Net Core, it is no more part of the base framework. You must add the package for it to your project. Normally the detail of the error raised by NHibernate allows to infer this, but you have not provided it. Le lundi 12 avril 2021 à 09:09:08 UTC+2, Gregory a écrit : > NHibernate doesn't have the 2019 dialect for MS SQL server. > > I tried using the 2012 dialect but it gives me an error saying "Could not > create the driver from NHibernate.Driver.SqlClientDriver" > > What should I do? > -- 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+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/nhusers/6b5cd54c-1eda-4777-8668-48d792973705n%40googlegroups.com.