LINQ To SQL Wildcards
- by mcass20
How can I build in wildcards to my LINQ To SQL lambda expression?
This is what I have currently:
var query = from log in context.Logs select log;
foreach (string filter in CustomReport.ExtColsToFilter)
{
string tempFilter = filter;
query = query.Where(Log => Log.FormattedMessage.Contains(tempFilter));
}
This works fine up until I try and pass wildcards in the filter string. I'm experimenting with SqlMethods.Like() but to no avail.
The filters above look like this: "<key>NID</key><value>mcass</value>".
I'd like to be able to pass filters like this: "<key>NID</key><value>%m%</value>"
