Search a number in LinQ

Asked Apr 08 '17 at 11:01

Active Apr 08 '17 at 11:59

Viewed 34 times

public JsonResult SearchProduct(int page, int pageSize, string key)
        {
            using (context = new ACETeaEntities())
            {
                var lstCatalog = context.Drinks.Select(x => new { x.Id_drinks, x.Vie_name, x.Eng_name, x.Id_category, x.Cool, x.Numberoforder, x.Price }).Where(x => x.Id_drinks.Contains(key) || x.Vie_name.Contains(key) || x.Eng_name.Contains(key) || x.Id_category.Contains(key) || x.Numberoforder.ToString() == key || (x.Cool == true ? "Có Lạnh" : "").Contains(key)).ToList();
                var data = lstCatalog.Skip((page - 1) * pageSize).Take(pageSize);
                int totalRow = lstCatalog.Count();
                return Json(new
                {
                    data = data,
                    total = totalRow,
                    status = true
                }, JsonRequestBehavior.AllowGet);
            }
        }

I have a search warrant as above. But I can not find the number for the keyword. It will select all numbers containing the number 'key'. And I also can not convert into string to use Contains(key).

Error: System.NotSupportedException: 'LINQ to Entities does not recognize the method 'System.String ToString()' method, and this method cannot be translated into a store expression.'

Numberoforder : Number of orders (int);

Cool : (bool) Please help me. Thank you!

edited Apr 08 '17 at 11:59

asked Apr 08 '17 at 11:01

Vũ Thành Long

1

Include a variable - `int num = Convert.ToInt32(key)` and use `x.Numberoforder == num` in the query – Apr 08 '17 at 11:07
If so. The result will return the exact same number. Is there a way to find the approximate number? – Vũ Thành Long Apr 08 '17 at 11:24
hat do you mean 'approximate' number'? – Apr 08 '17 at 11:25
The closest number to the key – Vũ Thành Long Apr 08 '17 at 11:33
Sorry, your not making sense. – Apr 08 '17 at 11:34
so sorry. I do not know how to describe it. Example: Data {111,222,333}; Key search = "1"; Desired result is '111' – Vũ Thành Long Apr 08 '17 at 11:43
But what is the logic for that? What if values`11` and `10` and `1115` exist - which one would it select? – Apr 08 '17 at 11:45
It will select all numbers containing the number 1 – Vũ Thành Long Apr 08 '17 at 11:51
1

Then you should explain that in your question (it not an _approximate number_). Use `SqlFunctions.StringConvert((double)x.Numberoforder).Contains(key)` – Apr 08 '17 at 11:57
It has worked. Thank you very much! – Vũ Thành Long Apr 08 '17 at 12:08

Search a number in LinQ

0 Answers0