ASP.NET

public HttpResponseMessage Get([FromUri] Query query)
        {
            var data = db.database.AsQueryable();

            int pageSize = 10;

            if (query.price_type != null)
            {
                data = data.Where(c => c.Cover == query.price_type);
            }
            
            int total = data.Count();
            // If any other filters are specified, return records which match any of them:
            var filteredData = new List<IQueryable<database_BWICs>>();

            if (!string.IsNullOrEmpty(query.isin))
            {
                var ids = query.isin.Split(',');
                foreach (string i in ids)
                {
                    filteredData.Add(data.Where(c => c.ISINs != null && c.ISINs.Contains(i)));
                }
            }

            if (!string.IsNullOrEmpty(query.cusip))
            {
                var ids = query.cusip.Split(',');
                foreach (string i in ids)
                {
                    filteredData.Add(data.Where(c => c.CUSIP != null && c.CUSIP.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).OrderByDescending(c => c.UploadDate).Take(pageSize);
            }

           
            if (!data.Any())
            {
                var message = string.Format("No data was found");
                return Request.CreateErrorResponse(HttpStatusCode.NotFound, message);
            }

            if (query.price_type != null)
            {
                data = data.OrderByDescending(c => c.Cover == query.price_type).Take(pageSize);
            }
            

            //return Request.CreateResponse(HttpStatusCode.OK, data);
            return Request.CreateResponse(HttpStatusCode.OK, new { total, data });
        }
    }

if (query.price_type != null)
            {
                data = data.Where(c => c.Cover == query.price_type);
            }