connection string in asp.net core library project -
i have asp.net core library project. want add connection string in it. don't have startup class in this. need place connection string , how fetch it?
please suggest.
in dotnet core can manage configuration using json files, 1 in many ways configure application.
according dotnet core configuration documentation can (copied link reference)
using microsoft.extensions.configuration; using system; using system.io; // add nuget <package id="microsoft.extensions.configuration" , // <package id="microsoft.extensions.configuration.json" // .net framework 4.x use following path: //.setbasepath(path.combine(directory.getcurrentdirectory(), @"..\..")) public class program { static public iconfigurationroot configuration { get; set; } public static void main(string[] args = null) { var builder = new configurationbuilder() .setbasepath(directory.getcurrentdirectory()) .addjsonfile("appsettings.json"); configuration = builder.build(); console.writeline($"option1 = {configuration["option1"]}"); console.writeline($"option2 = {configuration["option2"]}"); console.writeline( $"option1 = {configuration["subsection:suboption1"]}"); } }
then in appsettings.json
file can add:
{ "connectionstrings": { "bloggingdatabase": "server=(localdb)\\mssqllocaldb;database=efgetstarted.consoleapp.newdb;trusted_connection=true;" }, }
and access in code using configuration.getconnectionstring("bloggingdatabase")
i can recommend reading dotnet core documentation regarding connection strings
edit: commentors mention on post, don't add connection strings , config files library code - console application or web application!
additional forms of configuration dotnet core includes user secrets, environment variables , perhaps xml files or other forms of storage, pointed out in comments
Comments
Post a Comment