Is it possible for me to use string formatting or equivalent in LINQ-to-SQL?

Question

My LINQ query has a piece like

where dataContext.MyTable.Any(r => $"%{r.Name}%" == name)

which is causing an exception

"Method 'System.String Format(System.String, System.Object)' has no supported translation to SQL

Possible to do what I'm trying to do or will I have to resort to writing raw SQL?

Why raw SQL? Just assign $"%{name}%" to a variable outside of the query and use it inside. — Ivan Stoev
– Ivan Stoev, Commented Feb 1, 2017 at 20:37
@IvanStoev, whoops, I had something backwards. Watch my edit. — Drain The Swamp
– Drain The Swamp, Commented Feb 1, 2017 at 20:39

Justin Niessner · Accepted Answer · 2017-02-01 20:39:11Z

3

Instead of using string interpolation (which uses String.Format underneath), just use string concatenation:

where dataContext.MyTable.Any(r => ("%" + r.Name + "%") == r.Name)

answered Feb 1, 2017 at 20:39

Justin Niessner

246k40 gold badges416 silver badges546 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

@DrainTheSwamp - That's why it always helps to know what's going on behind the curtain when using shortcuts. Feel free to upvote/accept.