It is easy to use.
Retrieve methods in dbconn class by reflection
Public static sqlconnection getconnection (string ID) // create a connection. The parameter determines which connection string to call.
{
Dbconn mydbcon = new dbconn ();
Type mytype = mydbcon. GetType ();
System. reflection. propertyinfo mypi = mytype. getproperty ("connectionstring" + id );
Sqlconnection connection = new sqlconnection (mypi. getvalue (mydbcon, null). tostring ());
Connection. open ();
Return connection;
}
Dbconn class:
Public class dbconn
{
# Region gets sqlserver onstring from the configuration file web. config
Public String connectionstring1
{
Get {return configurationmanager. connectionstrings ["sqlconnstring1"]. connectionstring ;}
}
Public String connectionstring2
{
Get {return configurationmanager. connectionstrings ["sqlconnstring2"]. connectionstring ;}
}
# Endregion
}