title: Could not find an implementation of the query pattern - linq error
body: <p>Having trouble with my linq query in my model of MVC. I have an edmx which is composed of ObjectSet and EntityObject. this is where im getting the error "from c in <strong>CanaClie0012</strong>". when i go to definition it is going to my entityObject.</p>
  
  <pre><code>   public class ClientRepository
      {
  
          public List&lt;ClientSearchResult&gt; Search(ClientSearchFilter filter, string sortColumn, string sortOrder, int pageSize, int pageIndex, out int totalRecords)
          {
  
              var q = from c in CanaClie0012
                      select new ClientSearchResult
                      {
                          Client00130012 = c.Client00130012,
                          F1Pais00200012 = c.F1Pais00200012,
                          F1Cana02530012 = c.F1Cana02530012,
                          Direcc0012 = c.Direcc0012,
                      };
  
              if (!string.IsNullOrEmpty(filter.Client00130012))
              {
                  q = q.Where(c =&gt; c.Client00130012.ToLower().Contains(filter.Client00130012.ToLower()));
              }
              if (!string.IsNullOrEmpty(filter.F1Pais00200012))
              {
                  q = q.Where(c =&gt; c.F1Pais00200012.ToLower().Contains(filter.F1Pais00200012.ToLower()));
              }
              if (!string.IsNullOrEmpty(filter.F1Cana02530012))
              {
                  q = q.Where(c =&gt; c.F1Cana02530012.ToLower().Contains(filter.F1Cana02530012.ToLower()));
              }
              if (!string.IsNullOrEmpty(filter.Direcc0012))
              {
                  q = q.Where(c =&gt; c.F1Cana02530012.ToLower().Contains(filter.F1Cana02530012.ToLower()));
              }
  
  
              switch (sortColumn)
              {
                  case "Client00130012":
                      q = (sortOrder == "desc") ? q.OrderByDescending(c =&gt; c.Client00130012) : q.OrderBy(c =&gt; c.Client00130012);
                      break;
                  case "F1Pais00200012":
                      q = (sortOrder == "desc") ? q.OrderByDescending(c =&gt; c.F1Pais00200012) : q.OrderBy(c =&gt; c.F1Pais00200012);
                      break;
                  case "Direcc0012":
                      q = (sortOrder == "desc") ? q.OrderByDescending(c =&gt; c.Direcc0012) : q.OrderBy(c =&gt; c.Direcc0012);
                      break;
                  case "F1Cana02530012":
                      q = (sortOrder == "desc") ? q.OrderByDescending(c =&gt; c.F1Cana02530012) : q.OrderBy(c =&gt; c.F1Cana02530012);
                      break;
                  default:
                      break;
              }
              totalRecords = q.Count();
              return q.Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList();
          }
  
  
      }
  </code></pre>
  
  <p>I have already tried adding this:</p>
  
  <pre><code>List&lt;CanaClie0012&gt; clients = new List&lt;CanaClie0012&gt;();
  </code></pre>
  
  <p>But its returning null values. Kindly help me. Im lost here.</p>