title: How to "extend" query in Lightswitch?
body: <p>I need to present data from two tables in the same view. When I use a calculated property I get a performance penalty that is currently not acceptable.</p>
  
  <p>If I would have done it using only SQL it would be possible using a JOIN. I also know how to do it using linq and entity framework.</p>
  
  <p>The problem is that Lightswitch only lets me execute queries that results in a list of existing entities.</p>
  
  <p>I'm creating a Desktop Client.</p>