Which SqlServerDialect for Azure


your connection looks like this but i can’t find any later sql server version for the IOrmLiteDialectProvider.

Latest version is 2019.

new OrmLiteConnectionFactory(Configuration.GetConnectionString("db"), SqlServerDialect.Provider));

They’re placeholders in case we need to use SQL Server features in newer versions, but OrmLite doesn’t rely on any new features after SqlServer2016OrmLiteDialectProvider which are all the same after then, so you can use SqlServer2016Dialect.Provider up to SqlServer2019Dialect.Provider which are functionally equivalent.

I’ve added a SqlServer2022Dialect placeholder which you can move to for the next release.

1 Like