title: Mapping from relational database
body: <p>For one to one relationships things are easy.<br>
  When it comes to one to many or many to many problems appear...<br>
  I am not using an ORM tool now for many reasons and i am wondering when i want to get data whether it is better to reassemble  one to many relationship using multiple queries or in code..</p>
  
  <p>For example.. Having a class Category and a class Product... </p>
  
  <p>A product table has a collumn for category id (one category many products).</p>
  
  <p>So for my full catalog is it better to execute 2 queries to get the categories and products i want and then populate  for each category its products List ? (It is very easy with LINQ) ..</p>
  
  <p>Or i should call query for each category ? Like <code>select id from products where category_id=5;</code></p>
  
  <p>Also i dont know how to name the functions like to set whether i want to fetch the other side of the relationship or not..</p>