Replace @ params in Select query

ServiceStack.OrmLite
1

Hi all! I’m trying to make this query work, but it seems that it can’t replace @word with “chem”; if I write it in plain-text in the query everything works…

 var anagrafiche = Db.Select<AN01_ANAGGEN>(
                   @"SELECT AN01_IDANAGGEN, AN01_RAGSOCANAG 
                   FROM AN01_ANAGGEN
                   WHERE (AN01_IDANAGGEN LIKE '%@word%')
                   OR (AN01_RAGSOCANAG LIKE '%@word%')
                   OR (AN01_ALIAS LIKE '%@word%')", new { word = "chem" });

Where I’m wrong?

2

Please always provide the StackTrace if you’re reporting an error (and as much info about the error as you can), makes it very hard at identifying issues otherwise.

Your use of db params looks invalid, see: http://stackoverflow.com/questions/10937110/how-to-use-named-parameters-inside-like-operator-pattern-in-adobe-air for the correct usage.

3

Thanks mythz and I apologize for any inaccuracies in error reporting.
I let here the solution:

var anagrafiche = Db.Select<AN01_ANAGGEN>(
                  @"SELECT AN01_IDANAGGEN, AN01_RAGSOCANAG 
                  FROM AN01_ANAGGEN
                  WHERE (AN01_IDANAGGEN LIKE @word)
                  OR (AN01_RAGSOCANAG LIKE @word)
                  OR (AN01_ALIAS LIKE @word)", new { word = "%" + request.Word + "%" });