How to Solve the Microsoft.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near '$ Error | HackerNoon
EF8 may generate SQL queries incompatible with older SQL servers due to compatibility level mismatches.
Synchronizing server and client compatibility levels can resolve syntax errors.