title: Best practice for queries and WCF Service
body: <p>What would be the best practice for the following scenario:</p>
  
  <p>There´s a grid that will be filled and must be changed according to each row.  For instance, there´s a grid filled with products, then according to each product one of the columns will be dynamically populated.  Is it better to return from the service all the productdetail table and query it on the client side or have a method on the service that will return only the data needed?  The latter would mean that if there are n number of products on the grid, there will be n requests to that service method.</p>
  
  <p>My dilemma is that for some of the users the table will be relatively small and sending it to the client might not be a big deal, but other users do have a considerable amount of rows that would be returned (more than 15k).</p>
  
  <p>Thanks for any insight you may bring.</p>