Hi all,

I'm trying to tweak some code in the DAL2 to use "like" in the where clause, like this:

select * from table where LastName like '%mark%'

Here's some code I copied and tweaked using a where clause to get some records but I can't figure out how to use "like" using a parameter passed in to a method:

IEnumerable t;
using (IDataContext ctx = DataContext.Instance())
{
var rep = ctx.GetRepository();
t = rep.Find("WHERE FirstName=@0", strLastName);
}

It works fine if the variable strLastName matches exactly but I'd like to find similiar matches too.

Thanks,
Mark

Instead of hoping we can guess why not tell us what you DID do and how it failed?

---

Best wishes,
- Richard
Agile Development Consultant, Practitioner, and Trainer
www.dynamisys.co.uk

Mark, that's exactly, how It should look like for the sql server;
rep.Find("WHERE FirstName Like '%@0%'", strLastName)

---

Cheers from Germany,
Sebastian Leupold

   

Speed up your DNN Websites with TurboDNN