creating Database connection

Question

creating Database connection

c# dapper model-view-controller

Question

public class DbConnection
{         
    private static string strConnectionString;
    public string strconn;

    public static string SqlConnectionStringProp
    {
        get { return strConnectionString; }
        private set { strConnectionString = ConfigurationManager.ConnectionStrings["MedicalConnection"].ConnectionString; }
    }
}

This is my Dbconnection.cs file

private IDbConnection db = new SqlConnection(DbConnection.SqlConnectionStringProp);

this is in file categoryDal.cs

String is not passing from SqlConnectionStringProp property. Sql server is not connecting.

Yash patel

View more on Stack Overflow

Amit Joshi · Accepted Answer · 2/26/2018 6:54:08 AM

String is not being passed from SqlConnectionStringProp property because setter is never being called. As simple as that.

You can either convert the property to method to return connection string; OR call setter of your property somewhere; OR simply remove the setter all together and use only getter like below:

public static string SqlConnectionStringProp
{
    get { return ConfigurationManager.ConnectionStrings["MedicalConnection"].ConnectionString; }
}

creating Database connection

Question

Fastest Dapper Plus Extensions

Accepted Answer

Performance

Expression Evaluator