title: ASP.NET MySQL WebApp Architecture
body: <p>I'd like to know the best architecture. </p>
  
  <p>We have a web application running different domains. Each domain has its own MySQL database but the db structure is the same for all of them.</p>
  
  <ul>
  <li>We have a web application for the visible part of the application.</li>
  <li>We have a dataLogic project</li>
  <li>We have a dataEntities project</li>
  <li>We have a dataAccess that contains only the methods to connect to the data base.</li>
  </ul>
  
  <p>Before we called stored procedures on a database. But we had to change it because the performance was bad. Also, the problem was that every change we made we had in a stored procedure we had to copy to every database.</p>
  
  <p>We are thinking in using a WebService to retrieve the data. Every domain can call the web service with a connection string and connect its database to retrieve data. This way when we change a SQL query we only have to compile the webService and change it, we don't have to change versions on multiples domains.</p>
  
  <p>Also, what do you think about the SQL queries? Since we don't want to keep using stored procedures, what is the best way to do it? Directly from code?</p>
  
  <p>Thanks</p>
  
  <p>T</p>