title: Get parent entity according to some property filter in child table
body: <p>Id like to get all the parent that doesn't have in the signature table anything with </p>
  
  <p>(Roleid 1 OR Roleid 2 OR Roleid 3) AND SignatureStatus IS &lt;> NULL  </p>
  
  <p>RoleId - int: 0-13<br>
  SignatureStatus - bit: True, False, Null</p>
  
  <p>I have this code but i still get the parent when i shouldn't and not getting it when i should..</p>
  
  <pre><code> result = Context.APP_AuthorityHasamaForm.Where(x =&gt;
                  x.UpdateTypeId == (int)UpdateType.Unit &amp;&amp; x.AuthorityNum == authorityUnit.AuthorityNum &amp;&amp;
                  x.InsertDate &gt;= authorityUnit.FromDate &amp;&amp; x.HasamaFormStatus == (int)Status.Valid &amp;&amp;
                 !(x.APP_SignatureAuthorityHasamaForm.Any(s =&gt;
                      s.RoleId == (int)Role.EligibilityWorker1 || s.RoleId == (int)Role.DepartmentManager2 ||
                      s.RoleId == (int)Role.Treasurer3 &amp;&amp; ((bool)s.SignatureStatus || !(bool)s.SignatureStatus)))).ToList();
  </code></pre>