Connection string in class library for asp.net core MVC project

Question

I would like to connect a class library to my project but .net core class library does not have web.config file where I can enter my connection string. I am using raw ADO.net not an ORM (EF).

Sachin Singh · Answer

You can always use configuration stored in Appsettings.json, in any of your layer. Means , store your connectionstring in your MVC App inside Appsettings.json as { "Logging" : { "LogLevel" : { "Default" : "Information" , "Microsoft" : "Warning" , "Microsoft.Hosting.Lifetime" : "Information" } }, "ConnectionStrings" : { "Cs" : "your con string" } } } then read it from another project (class library) as public abstract class SqlRepository : IGenericRepository where TEntity : class { //private EDbConnectionTypes _dbType; private readonly IConfiguration _config; private IDbConnection _conn; public SqlRepository(IConfiguration configuration) { _config = configuration; } public IDbConnection GetOpenConnection() { _conn = DbConnectionFactory.GetDbConnection( _config.GetConnectionString( "Cs" ) ); //notice here return _conn; } // namespace:-using Microsoft.Extensions.Configuration;

geetha geetha · Answer

.net core class library does not have a web.config file instead of that we use appsetting.json file. In code first approach you need to add a connection string in appseeting.json file. find your datasource in server explorer. { "ConnectionStrings" : { "Myconnection" : "Data Source=ASPLAPR271\MSSQLSERVER1;Initial Catalog=EMP1;Integrated Security=True" }, "Logging" : { "LogLevel" : { "Default" : "Information" , "Microsoft" : "Warning" , "Microsoft.Hosting.Lifetime" : "Information" } }, "AllowedHosts" : "*" } After that , you have to confiure the connection string in connection services. public void ConfigureServices(IServiceCollection services) { services.AddControllersWithViews(); services.AddDbContext (options => options.UseSqlServer(Configuration.GetConnectionString( "Myconnection" ))); }

Srinivasan Ramamoorthi · Answer

Check this link https://www.c-sharpcorner.com/forums/reading-from-connection-string-in-class-library-dotnet-core

Connection string in class library for asp.net core MVC project

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (3)