Error - Only arguments that can be evaluated on the client are support

This error message suggests that the String.Contains method is not supported by the LINQ provider that is being used to translate the query into SQL. This can happen when the LINQ provider cannot translate a method call into the appropriate SQL expression.

LMSDBDataContext context = new LMSDBDataContext();

var query1 = from t in context.View_Recommendations
             where StudentCollection.Contains(t.StudentID.ToString())
             select t;

var query2 = from t in context.View_Recommendations
             where StudentCollection.Length == 0
             select t;

List Result = query1.Concat(query2).ToList();

Hi naimish

  I get the same error - Only arguments that can be evaluated on the client are supported for the String.Contains method.

Studentcollection is a string data type

Thanks

Hi Naimish

  In sql it is giving correct result I want only those records of STudent Id below , but according to above query it is returning other than these records also

21,24,272

Thanks

The error message you're seeing suggests that the String.Contains method cannot be used in this context because it can only accept arguments that can be evaluated on the client side.

Based on your code, it seems that StudentCollection is an array of strings that you are using to filter the results of your LINQ query. However, the Contains method cannot be used in this way because it is not supported in a SQL query.

One possible solution would be to filter the results using a different method, such as the Enumerable.Contains method from the System.Linq namespace. This method can be used to filter the results after they have been retrieved from the database:

LMSDBDataContext context = new LMSDBDataContext();
List Result = (from t in context.View_Recommendations
                select t).ToList();

if (StudentCollection.Length > 0)
{
    Result = Result.Where(t => StudentCollection.Contains(t.StudentID.ToString())).ToList();
}

Thanks