syntax error at or near “[“

We change MS SQL to Postgres Database in asp.net application then we have to add Some migration with Postgres EntityFrameworkCore so getting “syntax error at or near “[“” so let fix this.

So fix this issue,
a. Removed the Migrations folder in your application that already we have
b. Run “Add-Migration ” in the package manager console
c. Rn “Update-Database”, to flush the SQL Server predefined context.

Now you see the Migration is done without any error now see in Schema in Postgre SQL.