Dapper Tutorial - Knowledge Base (KB)

String.Format with SQL wildcard causing Dapper query to break

I'm having a bit of an odd problem with Dapper and string formatting. Here's the relevant code:...string end_wildcard = @" SELECT * FROM users WHERE (first_name LIKE CONCAT(@search_term, '%') OR last_name LIKE CONCAT(@search_term, '%'));"; string both_wi...