how use like in sql on linq c#

Question

this not work

string[] DATE_Group = { "2020", "2021" }; //changing values
var query = _context.c10
            .Where(u => DATE_Group.Any(s => u.ON_DATE.Contains(s)))
            .ToList()
            .Select(u => new
            {
                User_NumberID = u.User_NumberID.ToString(),
            }).ToList();

I use this u.ON_DATE.Contains("2020") and work but not list or array only one value

in sql SELECT * from C10 where ON_DATE like '%2020%' or ON_DATE like '%2021%' and in ON_DATE column content like this 1-3-2023 1-1-2021 5-1-2020

this error when used enter image description here

and in ON_DATE column content like this 1-3-2023 1-1-2021 5-1-2020 — sp 4_4, Jul 20 '22 at 07:09
Are you getting any error? if so please share it. If the output is unlike the expected, share it as well. @sp 4_4 — Wael Moughrbel, Jul 20 '22 at 07:13
Answered similar a lot of times. There is no support in EF Core for such query, but with helper function you can do that: [answer1](https://stackoverflow.com/a/69823896/10646316), [answer2](https://stackoverflow.com/a/68164647/10646316). If it is still not clear, will create another similar answer, — Svyatoslav Danyliv, Jul 20 '22 at 07:50

score 1 · Answer 1 · answered Jul 20 '22 at 07:03

1

Use this below code for your linq where statement.

var myVar=context.Students.where(x=>x.Name.Contains("John")).SingleOrDefault();

answered Jul 20 '22 at 07:03

Reza Karim

24
2

the same this u.ON_DATE.Contains("2020") I want multiple values – sp 4_4 Jul 20 '22 at 07:12
Multiple like this ("2020","2021","2022") ? – Reza Karim Jul 20 '22 at 07:14
yes in sql SELECT * from C10 where ON_DATE like '%2020%' or ON_DATE like '%2021%' or ON_DATE like '%2022%' – sp 4_4 Jul 20 '22 at 07:21
var myVar=context.Students.where(x=>x.Name.Contains("John")||x.Name.Contains("Joseph")).SingleOrDefault(); – Reza Karim Jul 20 '22 at 08:37

tymtam · Answer 2 · 2022-07-20T09:01:45.407

1

I think this is a better way to get the data:

var from = new DateTime(2020,1,1);
var to   = new DateTime(2022,1,1);
var query = _context.c10
            .Where(u => u.ON_DATE > from && u.ON_DATE < to )
            ...

edited Jul 20 '22 at 09:01

answered Jul 20 '22 at 08:17

tymtam

31,798
8
86
126

This is the real answer – Charlieface Jul 20 '22 at 09:00

score 0 · Accepted Answer · answered Jul 20 '22 at 08:08

EF Core cannot use Any with local collections (with small excpetion), only Contains is supported.

I would suggest to use function FilterByItems. And use in query:


string[] DATE_Group = { "2020", "2021" }; //changing values

var query = _context.c10
    .FilterByItems(DATE_Group, (u, s) => u.ON_DATE.Contains(s), true)
    .Select(u => new
    {
        User_NumberID = u.User_NumberID.ToString()
    })
    .ToList();

how use like in sql on linq c#

3 Answers3