title: How can I use condition and filters in LinkEntity?
body: <p>I want to create a <code>QueryExpression</code> to simulate this SQL statement</p>
  
  <pre><code>select * from A
  inner join B on A.b_id=B.ID
  where B.Name like "% what ever %"
  </code></pre>
  
  <p>this is how the FetchXML might look like</p>
  
  <pre><code>&lt;?xml version="1.0" encoding="UTF-8"?&gt;
  &lt;fetch distinct="true" mapping="logical" output-format="xml-platform" version="1.0"&gt;
     &lt;entity name="A"&gt;
        &lt;attribute name="ID" /&gt;
        &lt;attribute name="sce_name" /&gt;
        &lt;link-entity name="B" alias="ab" to="b_id" from="A"&gt;
           &lt;filter type="and"&gt;
              &lt;condition attribute="Name" value="% what ever %" operator="like" /&gt;
           &lt;/filter&gt;
        &lt;/link-entity&gt;
     &lt;/entity&gt;
  &lt;/fetch&gt;
  </code></pre>
  
  <p>How I can make this in <code>QueryExpression</code> <code>LinkQuery</code> <code>Conditions</code> and <code>Filters</code>, also I don't want to start from <strong>B</strong> since <strong>A</strong> might have its conditions too.</p>
  
  <p>This is what I have tried so far</p>
  
  <pre><code>QueryExpression query = new QueryExpression("A");
              query.ColumnSet.AllColumns = true;
              var link = new LinkEntity()
              {
                  JoinOperator = JoinOperator.Inner,
                  EntityAlias = "c",
                  LinkFromEntityName = "A",
                  LinkToEntityName = "B",
                  LinkFromAttributeName = "b_id",
                  LinkToAttributeName = "ID",
              };
  
               using (var Service = new OrganizationService("con"))
              {
                      EntityCollection entities = Service.RetrieveMultiple(query);
              }
  </code></pre>