Skip to main content

Micrsosoft database (sql sever 2014 and older) - Microsoft.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near '$'.

You have a Micrsosoft database (sql sever 2014 and older) and EaInfoport does not work correctly since version 8.8.0.9195 or you get the error message Microsoft.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near '$'. ?

image-1743169580247.png

You need to install a newer version of Sql Sever see

https://learn.microsoft.com/en-us/ef/core/what-is-new/ef-core-8.0/breaking-changes#contains-in-linq-queries-may-stop-working-on-older-sql-server-versions