Advertise with us

Control Panel Forum Hosting Help ASP.NET 4.5 & SQL 2012 Hosting Resources Notice

Home » Resources » Static class to get ConnectionString and Provider from web.config

ASP.NET	ADO.NET	Web Services	Remoting	Visual Studio 2005
Error Bank	Interview Questions	Tips & Tricks	XML	HTML
Jscript/Javascript	IIS	Windows		General

Submit Resource or code snippet ... and get surprise gifts ASP.NET web hosting

Win Digital camera, ASP.NET Books, Free softwares!!

Static class to get ConnectionString and Provider from web.config

08 Apr, 2008

Author: Brian Oburak

Summary
Connectionstring and providername

.NET Classes used :

using System.Configuration;

This class gives some static method that are used to exract the connection string and provider name from the web.config file.
Here we go:

public class Config
{
//cache de connnectie string naar de databank
private readonly static string dbConnectionString;
//cache de data provider naam (sql, oracle etc.)
private readonly static string dbProviderName;

static Config()
{
//database connectie string
dbConnectionString = ConfigurationManager.ConnectionStrings["connection-string-name"].ConnectionString;

//database provider
dbProviderName = ConfigurationManager.ConnectionStrings["connection-string-name"].ProviderName;
}

//getter methode voor connectie string
public static string DBConnectionString
{
get
{
return dbConnectionString;
}
}

//getter methode voor provider name
public static string DBProviderName
{
get
{
return dbProviderName;
}
}
}

Feedbacks about this page from members:

- No Feedbacks yet !! -

Submit Feedback View All Feedbacks

Total members: 251034
Average new registrations per day (in last 7 days): 8

New Registration: Open

Register Now

Talk to Webmaster
Tony John

Facebook
Google+
Twitter