How do I perform an 'IN' query against delimited string?

drettberg

I am trying to get all records that have DisplayLocation_IDs within a delimited string (e.g. "1,6,12").

I have tried the following but I get "Incorrect syntax near '1'".

.Where( q => q.Where("DisplayLocation_ID", locIds, "in", false))

Any help is appreciated

allan

Try:

"(1,6,12)"

The would then look like:

DisplayLocation_ID IN ( 1,6,12 )

in the SQL.

Allan

drettberg

Thanks Allan. Did the trick