Search code examples
asp.net-coreentity-framework-core

DbContext scaffolding

Scaffold-DbContext  'Data Source=""; Database=""; User Id="";Password="";TrustServerCertificate=Yes' Microsoft.EntityFrameworkCore.SqlServer -OutputDir Models

while running this command i get the following error:

ClientConnectionId:f433cc07-6534-4bb4-ad0e-eab15d75ed67
Error Number:207,State:1,Class:16
Invalid column name 'has_filter'.
Invalid column name 'filter_definition'.
Solution

  • EF Core does not support SQL Server 2005, or database with a compatibility level under 110. Upgrade to a supported version or alter the compatibility level:

    ALTER DATABASE database_name SET COMPATIBILITY_LEVEL = 110