title: Data Access Layer (DAL) design
body: <p>I'm using .Net enterprise library data access application block for my Data Access layer  design.</p>
  
  <p>In my Category DAL class, I've methods like : </p>
  
  <p>GetProductsInCategory(int CatId), GetAllProducts, GetCategories, etc.</p>
  
  <p>My question is: where do I put this line of code ?</p>
  
  <pre><code>DatabaseFactory.CreateDatabase("MyDB");
  </code></pre>
  
  <p>shall I put it in every method above or shall I have a base class which would return Database object to my DAL class.</p>
  
  <p>Also, shall I keep these DAL class methods as static?</p>