In my .net 4 solution, i have two different projects- an web application project and a class library project.
In web application project, database connection string is in web.config file. I would like to access that connection string from class library project. Is it possible? if yes, how?
If there is any better approach to get connection string, please let me know.
To access it from your class library add a reference to System.Configuration then use System.Confinguration.ConfigurationManager.ConnectionStrings.
It's not ideal to read this from a class library. After all, can you say that your class library will always be consumed by something with a configuration file? Certainly not if you share it with other developers, especially of different platforms.
Consider:
e.g.:
public class MyLibraryContainer
{
private string _connectionString;
public MyLibraryContainer(string connectionString)
{
_connectionString = connectionString;
}
}
ConfigurationManager directly in the class library is wrong, as this functionality is outside the scope of the library.
ConfigurationManager from a class library with a consuming application which does not support a configuration file. Behind the scenes, configuration manager creates a static class which accesses the config file through the Application object. In a non-.net application, the Application object does not exist and thus, the configuration information cannot be read.AppPool, so if no AppPool exists, there will be no user with which to access the config file on disk.