Incorrect syntax near the keyword 'NOT'. error during ef database update
I've been following a Asp.net core web api tutorial https://www.youtube.com/watch?v=SIQhe-yt3mA&t=436s and I keep getting this error when trying to do the dotnet ef database update command. I've tried lots of things, but I'm a bit stumped here
Error Number:156,State:1,Class:15
Incorrect syntax near the keyword 'NOT'.
Error Number:156,State:1,Class:15
Incorrect syntax near the keyword 'NOT'.

YouTubeTeddy Smith
ASP.NET Core Web API .NET 8 2024 - 3. Entity Framework
Github: https://github.com/teddysmithdev/FinShark
SQL Server Connection String Template (WINDOWS):
"Data Source={PCNAME}\SQLEXPRESS;Initial Catalog={DATABASENAME};Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSub...
Github: https://github.com/teddysmithdev/FinShark
SQL Server Connection String Template (WINDOWS):
"Data Source={PCNAME}\SQLEXPRESS;Initial Catalog={DATABASENAME};Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSub...

