title: C# Database Connection Stored in DLL to Call
body: <p>I am New to the more enhanced features of the C# and .NET coding practices</p>
  
  <p>I have been trying to Find A solution to using a particular method in C# for Winforms, Windows Services And ASP.NET web Applications where you program your connection to SQL and Convert the C# Code file to a dll to be used in your project. </p>
  
  <p>The idea is to Create the Connection and Convert it to a dll so that every time you start a function and need to make a database connection you will just write it where you say</p>
  
  <pre><code>Function ABC
  {
      //VB Version would be like this as i have seen this
      Dim DCDLL as New Dataconn 
  
      //Where 'DCDLL' is the DLL file which is being declared as a new dataconnection
  
      //C# Version would be Alon these Lines
      SQLConnection DataConn = New SQLConnection(DCDLL)
  }
  </code></pre>
  
  <p>I have only seen the VB Code version of the Call so I am not keen on the C# Method that this would be done</p>
  
  <p>Meanwhile The DLL Holds all the other code like</p>
  
  <pre><code>string ConnectionString = 
                      "Data Source=Datasource; UID=User; PWD=Pass; Persist Security
                       Info=True; Initial Catalog= Catalog";
  Dataconn = new SqlConnection(ConnectionString);
  Dataconn.Open();
  </code></pre>
  
  <p>the purpose of the DLL would be to handle the connection to the database, Open it catch errors if dataconnection is not successfull and close the connection if needed so that you dont have to programatically do this every time. Also it is only responsible for the connection therefore you can use a function to call the connection execute the procedure and whatever else is required. </p>
  
  <p>The idea of using a DLL is just to make the Connection settings to the Database a little more secure, the Connection obviously wont become super secure but it adds more security than having the Code in you code pages etc.</p>
  
  <p>i have spoken to and seen people use this type of method but my research on how to achieve this via google and other sources does not seem to understand what i am searching for.</p>
  
  <p>I am trying to understand that when i code this file how it must be done as to ensure that it handles the database connection correctly without issues and doesnt break.</p>
  
  <p>If anyone can Give me Examples in C# of how to do this it would be appreciated or if you know of any pages that have explained how to achieve this i would be most grateful for your assistance</p>