EntityCommandExeceptionException error

Question

Dear all, 

 

When I call 'api/test/name=stop,tap,app...(24 names values)' from the following query below, I am experiencing the an error:

 

"Message":"An error has occurred.","ExceptionMessage":"Some part of your SQL statement is nested too deeply. Rewrite the query or break it up into smaller queries.","ExceptionType":"System.Data.SqlClient.SqlException

 

 

var data = db.database_bd.AsQueryable();

if (query.startDate != null)

{

data = data.Where(c => c.UploadDate >= query.startDate);

}

// If any other filters are specified, return records which match any of them:

var filteredData = new List<IQueryable<database_bd>>();

if (!string.IsNullOrEmpty(query.name))

{

var ids = query.name.Split(',');

foreach (string i in ids)

{

filteredData.Add(data.Where(c => c.Name != null && c.Name.Contains(i)));

}

}

// If no filters passed, return all data.

// Otherwise, combine the individual filters using the Union method

// to return all records which match at least one filter.

if (filteredData.Count != 0)

{

data = filteredData.Aggregate(Queryable.Union);

}

if (!data.Any()) // error line 

{

var message = string.Format("No data was found");

return Request.CreateErrorResponse(HttpStatusCode.NotFound, message);

}

return Request.CreateResponse(HttpStatusCode.OK, data);

}

 

Please Advice.  Any help would be very much appreciated.  

Thanks in advance.