Connection string not working in ASP.NET Core

Question

"ConnectionStrings": {
"DefaultConnection": "Server=(localdb)\\mssqllocaldb; Database=ABC; Trusted_Connection=True; MultipleActiveResultSets=true"}

I am working with ASP.NET Core MVC. I have this connection string in my appsettings.json file but it doesn't seem to work. While running "dotnet ef database update" from cmd, I am getting this error keyword not supported: 'server.'. What's wrong with it?

Is it true to assume, you're using EntityFramework for this connection ? — Orel Eraki
@Nkosi, I know, that is why i'm trying to know if the OP is using it with EF which will explain the error. — Orel Eraki

Vista Vista · Accepted Answer · 2018-03-04T10:22:04

Apologies! In my ConfigureServices method in Startup.cs, I was using SQLite database provider

services.AddDbContext<ApplicationDbContext>(options => options.UseSqlite(Configuration.GetConnectionString("DefaultConnection")))

I changed it to the following, and it worked with my connection string.

services.AddDbContext<ApplicationDbContext>(options => options.UseSqlServer(Configuration.GetConnectionString("DefaultConnection")))

Connection string not working in ASP.NET Core

2 Answers