Exception "incorrect syntax near 'TSEQUAL' when setting dbversion to 2012

MikeGriffinReborn / EntitySpaces

EntitySpaces - A Fluent SQL library for .NET

24 stars 20 forks source link

Exception "incorrect syntax near 'TSEQUAL' when setting dbversion to 2012 #9

Closed HeikoAdams closed 4 years ago

HeikoAdams commented 4 years ago

Hi, when using DatabaseVersion = "2012" as noticed in the project description saving data raises the exception from the title because in Providers\EntitySpaces.SqlClientProvider\Shared.cs the version check is only for if (request.DatabaseVersion == "2005" || request.DatabaseVersion == "2008") (line 360 and 490).

MikeGriffinReborn commented 4 years ago

Good catch, I'll fix that today. I'll turn the version into a number and then simply do a greater than. For now I guess you can temporarily set your version to 2008 and it should work. Also, check out what's coming ...

See => SQL "Over" methods and "out var" support for aliased columns

MikeGriffinReborn commented 4 years ago

This has been fixed in the SqlServer provider, 2020.2.1.0 which was just pushed, also, it supports the new OVER syntax, see the home page for OVER examples