How to Write connection string in asp.net core Web Api?

Question

I want to create the database connection in my .net core Web API how to I write the connection string. In App setting file how to I write the connection string.

How to add a connection string

Dalorzo
– Dalorzo

2016-12-01 14:11:29 +00:00
Commented Dec 1, 2016 at 14:11 — Dalorzo
– Dalorzo, Commented Dec 1, 2016 at 14:11

Admin · Accepted Answer · 2016-12-01 14:18:26Z

12

I got my answer

"Data": {
  "DefaultConnection": {
    "ConnectionString": "Server=(localdb)\\mssqllocaldb;Database=aspnet5-ConfigurationSample-ad90971f-6620-4bc1-ad28-650c59478cc1;Trusted_Connection=True;MultipleActiveResultSets=true"
  }
}

here is link http://aspnetmonsters.com/2016/01/json-config-in-aspnetcoremvc/

answered Dec 1, 2016 at 14:18

Admin

3031 gold badge2 silver badges12 bronze badges

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

Comments

Daniel Sánchez · Accepted Answer · 2019-07-30 19:53:42Z

WEB API has a configuration file 'appsettings.json', in this file you can put all the configuration or variables that you need, for example would be like this:

{
  "Logging": {
    "LogLevel": {
      "Default": "Warning"
    }
  },
  "AllowedHosts": "*",
  //->
  "ConnectionStrings": {
    "DefaultConnection": "Server=localhost;Initial Catalog=dbname;MultipleActiveResultSets=true;User ID=sa;Password=mypass"
  },
  "Jwt": {
    "SecretKey": "myjwtpass"
  },
  "EmailConfiguration": {
    "SmtpServer": "mysmtpserver",
    "SmtpPort": 2525,
    "SmtpUsername": "myusername",
    "SmtpPassword": "mypassword"
  }
  //<-
}

To obtain the values of the configuration we show the following example:

In the constructor get this from injection:

public IConfiguration Configuration { get; }
public MyClassName(IConfiguration configuration)
{
    Configuration = configuration;
}

In some method:

public void SomeMethod()
{
     var jwtPass = Configuration["Jwt:SecretKey"];
     var connStr = Configuration["ConnectionStrings:DefaultConnection"];
}

กะละมัง ใส่น้ํา · Accepted Answer · 2021-03-16 06:48:38Z

-1

--I use Solution
string condb = "";
public readonly IConfiguration _configuration;
public ValuesController(IConfiguration configuration)
{
_configuration = configuration;
condb = _configuration[ConnectionStrings:DefaultConnection];
}

edited Mar 16, 2021 at 6:48

answered Mar 16, 2021 at 5:00

กะละมัง ใส่น้ํา

11 bronze badge

2 Comments

frankenapps Over a year ago

Please also explain what the posted code does and why it will resolve the question.

S M De Savic Nov 15 at 18:04

"ConnectionStrings": { "DefaultConnection": "Server=localhost;Database=YourAppDb;User Id=yourUsername;Password=yourPassword;Trusted_Connection=false;MultipleActiveResultSets=true;", }

Collectives™ on Stack Overflow

How to Write connection string in asp.net core Web Api?

3 Answers 3

Comments

Comments

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

2 Comments

Related