Thank you. Adding the requisite package solved the issue. To anyone 
reading this in the future, I used System.Data.SqlClient (4.6.1) for 
ASP.NET Core 3.0.  

On Monday, April 12, 2021 at 3:19:57 AM UTC-4 Frédéric Delaporte wrote:

> 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/fc4c08c7-1ee2-4b85-a02c-1036abcaf6a0n%40googlegroups.com.

Reply via email to