Adding a SQL connection to my ASP.NET Core application - how to define ConnectionStrings

Question

I am trying to connect my ASP.NET Core application to my database.

To do this I'm supposed to edit the appsettings.json file and define my default connection.

I am not sure what to put under Server and Database.

I am trying to connect the database StudentDB.

Here is what string I tried to use to connect to my database:

{
  "ConnectionStrings": {
    "DefaultConnection": "Server=ACTKPTP115;Database=StudentsDB;Trusted_Connection=True;MultipleActiveRes ultSets=true;"
},

As you can see I connected the database in Visual Studio.

Here is the database I'm trying to connect in Microsoft SQL management studio:

What do I type in the ConnectionStrings under Server and Database to properly connect my server?

ngobw · Accepted Answer · 2017-03-21 09:46:37Z

20

Can you try:

Server=ACTKPTP115\\SQLTEST;Database=StudentsDB;Trusted_Conn‌ection=True;Multiple‌ActiveResultSets=tru‌e;

Some resource from Microsoft about connection strings for ASP.NET Core: https://learn.microsoft.com/en-us/ef/core/miscellaneous/connection-strings

edited Mar 21, 2017 at 9:46

answered Mar 21, 2017 at 8:53

ngobw

4064 silver badges4 bronze badges

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

2 Comments

ire Over a year ago

That was it but it's actually "Server=ACTKPTP115\\SQLTEST;Database=StudentsDB;Trusted_Connection=True;MultipleActiveResultSets=true;"

ngobw Over a year ago

Cool, thanks for pointing that mistake out. Edited the answer to reflect correctly for those who references it in the future. Have a good one!

Nelly Sattari · Accepted Answer · 2017-11-17 04:10:35Z

20

This piece of code worked for me:

{
"ConnectionStrings": {
    "DefaultConnection": "Server=tcp:xxUAT.domain.com,64609;Initial Catalog=IdentityDB;MultipleActiveResultSets=true;User ID=xx;Password=xx"
} }

answered Nov 17, 2017 at 4:10

Nelly Sattari

2,7831 gold badge14 silver badges14 bronze badges

Comments

Zahra · Accepted Answer · 2024-07-16 13:32:11Z

2

This is my connection string when I want to connect to sql server database on my local machine:

"server=.; database=MyDB; Integrated Security=True;TrustServerCertificate=True; User Id=MyUserName; Password=123;"

AppSettings.Development.json:

  "ConnectionStrings": {
    "MyDbConnectionString": "server=.; database=MyDB; Integrated Security=True;TrustServerCertificate=True; User Id=MyUserName; Password=123;"
  }

and program.cs file :

builder.Services.AddDbContext<MyDbContext>(
    dbContextOptions => dbContextOptions.UseSqlServer(
        builder.Configuration["ConnectionStrings:MyDbConnectionString"])
    );

answered Jul 16, 2024 at 13:32

Zahra

2,8783 gold badges28 silver badges53 bronze badges

Collectives™ on Stack Overflow

Adding a SQL connection to my ASP.NET Core application - how to define ConnectionStrings

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related