title: MVP Pattern, n-tier application architecture in .NET
body: <p>I'm at the beginning of my road concerning Programming and Software Development and Design. I want to develop some applications in .NET(C#) WinForms with a SQL server as back-end (haven't decided yet: PostgreSQL, MSSQL or other). What I want to ask is where do I get information on:</p>
  
  <ol>
  <li><p>How do i structure my SQL tables, Schemas, users, stored procedures etc. ?</p></li>
  <li><p>How to design the application to conform to the n-tier structure?</p></li>
  <li><p>How does the MVP/MVC pattern couple with the above?</p></li>
  </ol>
  
  <p>What I'm actually for is to please refer me to Web-Sites, books or any kind of learning material. Or if one would be so kind as to guide me through the process I would highly appreciate it.  </p>
  
  <p>The first app will be a small "pilot" app just to test these designs and tweak them. I thought it would be better than to just start writing the main ones. </p>
  
  <p>There is also a plethora of information and books. But I don't want to waste time with reading them if they aren't on the subject because at the moment this is what I want to focus on. </p>
  
  <p>Another thing. How to separate SQL code from the rest of the code? and how to interact with the database without breaking the MVP pattern and keeping sql code separate? </p>