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
– Orel Eraki, Commented Mar 3, 2018 at 18:47
@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
– Orel Eraki, Commented Mar 3, 2018 at 18:50

ColinM · Accepted Answer · 2018-03-04 10:32:20Z

6

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")))

edited Mar 4, 2018 at 10:32

ColinM

2,68119 silver badges31 bronze badges

answered Mar 4, 2018 at 10:22

Vista

931 silver badge7 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Brandon Turpy · Accepted Answer · 2018-03-04 08:13:37Z

-4

The connection string should start of with Data Source=.

In Visual Studio if you open the SQL Server Object Explorer and click on the database you are wanting to connect to. The connection string will be displayed in the Properties window. The connections string should look something like this for localDb

Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=DbName;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=True;ApplicationIntent=ReadWrite;MultiSubnetFailover=Fals

answered Mar 4, 2018 at 8:13

Brandon Turpy

9211 gold badge13 silver badges33 bronze badges

Collectives™ on Stack Overflow

Connection string not working in ASP.NET Core

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related