Apress/pro-asp.net-core-6

Keyword not supported: 'mutipleactiveresultsets' - Chapter 7 - Page 159

Opened this issue · 1 comments

I got this error message when trying to run the application: "Keyword not supported: 'mutipleactiveresultsets'"

To resolve, I removed 'mutipleactiveresultsets' from the connection string in appsettings.json.

"ConnectionStrings": {
"SportsStoreConnection": "Server=(localdb)\MSSQLLocalDB;Database=SportsStore"
}

7 chapter in file: SeedData getting error Microsoft.Data.SqlClient.SqlException: How to solve this , after trying many ways asking

if (context.Database.GetPendingMigrations().Any())
{
context.Database.Migrate();
}

resolved:
LaunchSetting.json remove the MultipleActiveResultSets=true

then it will work