title: this method cannot be translated into a store expression when i call another repository in my query
body: <p>I am trying to execute a query like this :</p>
  
  <pre><code>  List&lt;UserAssitanceView&gt; AllAssitance = objFirstIdeaAssistanceRepository.GetAll().Select(i =&gt; new UserAssitanceView()
      {
          assitanceId = i.Assistance.Id.ToString(),
          assitanceInternalTell = i.Assistance.AssistanceTell,
          assitanceName = i.Assistance.AssistanceName,
          experteName = objAssistanceRepository.ReturnExpertOfAssitance(i.AssistanceId).Name,
          expertFamily = objAssistanceRepository.ReturnExpertOfAssitance(i.AssistanceId).Family,
          ExperteMobile = objAssistanceRepository.ReturnExpertOfAssitance(i.AssistanceId).Mobile
      }).ToList();
  
  public class UserAssitanceView
      {
          public string assitanceId { set; get; }
          public string assitanceName { set; get; }
          public string experteName { set; get; }
          public string expertFamily { set; get; }
          public string assitanceInternalTell { set; get; }
          public string ExperteMobile { set; get; }
  
  
      }
  </code></pre>
  
  <p>FirstIdeaAssistance class :</p>
  
  <pre><code>namespace DomainClass
  {
      using System;
      using System.Collections.Generic;
  
      public partial class FirstIdeaAssistance
      {
          public int Id { get; set; }
          public string Date { get; set; }
          public long FirstIdeaId { get; set; }
          public int AssistanceId { get; set; }
  
          public virtual FirstIdea FirstIdea { get; set; }
          public virtual Assistance Assistance { get; set; }
      }
  }
  </code></pre>
  
  <p>In my query i call another repository method called <code>objAssistanceRepository.ReturnExpertOfAssitance</code> and the function is like this :</p>
  
  <pre><code>public class AssistanceRepository : GenericRepository&lt;InModelContainer, Assistance&gt;
  {
      public User ReturnExpertOfAssitance(int assitanceId)
      {
          return
              FindBy(i =&gt; i.Id == assitanceId &amp;&amp; i.AssistanceJurors.Any(j =&gt; j.User.Permission == "Assistance"))
                  .First().AssistanceJurors.Select(i =&gt; i.User).First();
      }
  }
  </code></pre>
  
  <p>After executing i got this error:</p>
  
  <pre><code>LINQ to Entities does not recognize the method 'DomainClass.User ReturnExpertOfAssitance(Int32)' method, and this method cannot be translated into a store expression.
  </code></pre>
  
  <p>When i remove these 3 lines from my code it works fine :</p>
  
  <pre><code>experteName = objAssistanceRepository.ReturnExpertOfAssitance(i.AssistanceId).Name,
              expertFamily = objAssistanceRepository.ReturnExpertOfAssitance(i.AssistanceId).Family,
              ExperteMobile = objAssistanceRepository.ReturnExpertOfAssitance(i.AssistanceId).Mobile
  </code></pre>
  
  <p>I did before like this and it worked fine but now i don't know why i get this error .</p>
  
  <p>Every ideas will be apprciated</p>
  
  <p>best regards</p>