CODEWITHSUNDEEP
c#asp.net-mvcentity-framework-6connection-string
user7861419
user7861419

Reputation: 51

How to get connection string in class library project

In my .net solution, I have two different projects: An MVC core web application project and a class library project. In web application project, database connection string is in appsettings.json file. I would like to access that connection string from class library project. Is it possible? If yes, how? If there is any better approach to get connection string, please let me know.

Upvotes: 5

Views: 7339

Answers (2)

Andrii Litvinov
Andrii Litvinov

Reputation: 13182

To make simple and trivial example you could create a class in your class library that will represent singleton or ambient context to provide connection string:

public static class ConnectionString
{
    public static string Value {get; set;}
}

And then in you app Startup class you set it's value:

var builder = new ConfigurationBuilder()
...
var configuration = builder.Build();
ConnectionString.Value = configuration["connectionString"]; // Or how you do it in your code.

And then you will be able to use it in your class library.

In real-world applications it is better to inject either connection string or settings that exposes connection string via constructor using Dependency injection technics.

Upvotes: 3

Shahzad
Shahzad

Reputation: 1705

Don't worry when your class library is called from the Web application, the connection string will be retrieved from the Web application app settings file.

For more info, see Get connection String

Upvotes: 0

Related Questions