title: Getting one row from a Strongly Typed dataset without getting who table
body: <p>I currently have this code:</p>
  
  <pre><code>   /// &lt;summary&gt;
      /// This is an ineffecient method of getting a tenant by their id.
      /// &lt;/summary&gt;
      /// &lt;param name="id"&gt;int ID of the tenant to be selected&lt;/param&gt;
      /// &lt;returns&gt;Tenant with the specific ID, or null if not found.&lt;/returns&gt;
      public static Tenant GetTenantByID(int id){
          RentalEaseDataSetTableAdapters.tblTenantTableAdapter adapter = new RentalEaseLogic.Database.RentalEaseDataSetTableAdapters.tblTenantTableAdapter();
          RentalEaseDataSet ds = new RentalEaseDataSet();
  
          adapter.Fill(ds.tblTenant);
  
          DataRow[] rows = ds.tblTenant.Select("ID = " + id);
  
          if (rows.Length &gt; 0) {
              return new Tenant(rows[0] as RentalEaseDataSet.tblTenantRow);
          } else {
              return null;
          }
      }
  </code></pre>
  
  <p>Which is pretty terrible in performance. It grabs and loads a large table everytime someone wants one row. There has to be a better way.</p>
  
  <p>How can I select one row from a table, without having to fill an entire table and still keep the strong data typing?</p>