1 public class GenericDatabaseAccessComponent
 2     {
 3         public string ConnectToDatabase()
 4         {
 5             try
 6             {
 7                 DbProviderFactory theFactory = DbProviderFactories.GetFactory("System.Data.SqlClient");
 8                 
 9                 ConnectionStringSettings theConnectionStaring =
10                     ConfigurationManager.ConnectionStrings["SqlClientTestDB"];
11 
12                 DbConnection theConnection = theFactory.CreateConnection();
13 
14                // theConnection.ConnectionString = theConnectionStaring.ConnectionString;
15 
16                 theConnection.Open();
17 
18                 if (theConnection.State == System.Data.ConnectionState.Open)
19                     return "Database connection is open.";
20                 else
21                     return "Database connection is open fail without expetion.";
22             }
23             catch (DbException dEx)
24             {
25                 return dEx.Message;
26             }
27             catch (Exception ex)
28             {
29                 return ex.Message;
30             }
31         }
32     }