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

Georgie Lato

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).

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh4y ago
Accepted 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 geetha4y ago
.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 Ramamoorthi4y ago
Check this link https://www.c-sharpcorner.com/forums/reading-from-connection-string-in-class-library-dotnet-core