title: How do I retrieve a single record on Microsoft CRM using c# if I don't know the GUID?
body: <p>We have a vendor solution here where it uses Microsoft Dynamics CRM as base. The application includes this custom entity which has the following attributes (truncated to only show the relevant bits)</p>
  
  <p><strong>relationship entity</strong> (works like a list of values. like values for populating a dropdown list)</p>
  
  <pre><code>relationshipid (guid datatype. primary key)
  description (string and sample values would include "staff" or "customer" or "visitor" and etc)
  </code></pre>
  
  <p>I want to retrieve a single record from the entity. something like:</p>
  
  <pre><code>select * from relationship where description like "staff%"
  </code></pre>
  
  <p>I know there's a Retrieve function but I need the guid to use that. I want to emulate the SQL above without having to possibly use QueryExpression. I <strong>want to get an object of type Entity instead of EntityCollection which is what a QueryExpression will give me.</strong></p>
  
  <p>thanks a lot :) </p>