Linq equivalent to '_' in SQL

Question

is there an equivalent from '_' in SQL to Linq.

In SQL it is like a white-space, so it selects everything and ignores this char.

e.g. SELECT * FROM customers WHERE customers.ID LIKE '12431466_1'selects all IDs with 12431266 and at the end 1

Please provide the context by specifying an example SQL query with `'_'` in it. — Sergey Kalinichenko, Nov 21 '18 at 16:16
Do you mean Linq _in general_ or Linq that is supported by the SQL provider (mean it generates SQL with the `_` wildcard character)? — D Stanley, Nov 21 '18 at 16:17
That's *not* a whitespace in SQL. It's a single character placeholder in LIKE patterns — Panagiotis Kanavos, Nov 21 '18 at 16:21
You can simulate this with `StartsWith` and `EndsWith` and `Length` combined, but LINQ to SQL / EF doesn't have direct support for `LIKE` except for certain specific database providers. — NetMage, Nov 21 '18 at 17:08
@NetMage I accepted your proposal, it works because I expact just one `_`. In other cases it would be a bigger problem. But thanks a lot. — user2369332, Nov 22 '18 at 09:15
A general solution for `_` would involve using `Substring` but would require knowing the position and number of the `_` ahead of time. — NetMage, Nov 26 '18 at 18:30

score 0 · Answer 1 · answered Nov 22 '18 at 09:28

The answer depends on your specific needs:

If you're using linq-to-sql and would like it to run the query you posted, you can use the same string with SqlMethods.Like.

If you want to have a solution for linq-to-objects or a custom linq provider, you'll need to either use string methods running inside the C# runtime, like StartsWith and EndsWith or use Regext.IsMatch or something similar.

Linq equivalent to '_' in SQL

1 Answers1