title: Problems with connection strings with DAL in separate project
body: <p>I originally wrote a data access layer inside an App_Code folder in my website. Then we developed a web service in a separate project. So that both the website and the web service can access the same DAL, I moved it to a different project. I have a dataset with tableadapters and to make the DAL project compile I had to add the connection string to the Application property settings. But this means that I have to recompile the DAL for every deployment. Also I may have 2 or 3 websites on the server using the same DAL. So I want to set the connection string in each website's web.config and leave it at that.
  Do I have to go through my code and change every time i create an instance of a tableadapter?
  e.g. From </p>
  
  <pre><code>using (MessageQueue adaptor = new MessageQueue())
  {
      return adaptor.GetMessages(UserId, MobileId, StartDate, EndDate);
  }
  </code></pre>
  
  <p>to </p>
  
  <pre><code>using (MessageQueue adaptor = new MessageQueue())
  using (OracleConnection connection = new OracleConnection(OracleUtilities.ConnectionString))
  {
      adaptor.Connection = connection;
      return adaptor.GetMessages(UserId, MobileId, StartDate, EndDate);
  }
  </code></pre>
  
  <p>Or is there a better way?</p>
  
  <p>Colin</p>