title: Select from multiple tables in one call
body: <p>In my code I have a page that includes information from 3 different tables. To show this information I make 3 SQL select calls and unite them in one list to pass as Model to my view. Can I do it with one SQL call? Data has no connection with one another. </p>
  
  <p>My code:</p>
  
  <pre><code>public ActionResult Index()
  {
      StorePageData PageData = new StorePageData();
      return View(PageData);
  }
  public class StorePageData
  {
       public List&lt;Table1Data&gt; Table1 { get; set; }
       public List&lt;Table2Data&gt; Table2 { get; set; }
       public List&lt;Table3Data&gt; Table3 { get; set; }
  
       public StorePageData()
       {
            Table1  = //loading from Database1
            Table2  = //loading from Database2
            Table3  = //loading from Database3
       }
  }
  public class Table1Data
  {
       public int Id { get; set; }
       public double Info1 { get; set; }
       public string Info2 { get; set; }
  }
  public class Table2Data
  {
       public int Id { get; set; }
       public List&lt;int&gt; Info1 { get; set; }
       public List&lt;int&gt; Info2 { get; set; }
  }
  public class Table3Data
  {
       public int Id { get; set; }
       public List&lt;string&gt; Info1 { get; set; }
       public List&lt;string&gt; Info2 { get; set; }
  }
  </code></pre>
  
  <p>If there is a way to load all 3 tables in one SQL request it will improve significantly the load time of this page.</p>
  
  <p>Thank you.</p>