If your database's collation is case insensitive, it will work out of the box (try it with SQL). If not, you can, for example, convert both the column and the value to lower case, as in:
session.Query<Customer>().Where(c => c.Name.ToLower().Contains(value.ToLower())).ToList(); RP On Thursday, August 29, 2013 7:18:25 PM UTC+1, Felipe Oriani wrote: > > Hello guys, I have a software and my users will use it with portuguese > language. In this language we have accenttuation in some characteres, for > sample: à, á, é, í, ã, etc... > > Is there any way to create a Linq Query to ignore it when I do some > filters? > > session.Query<Customer>().Where(c => c.Name.Contains(?)).ToList(); > > Thank you. > > -- > ______________________________________ > Felipe B Oriani > felipeoriani.com.br [email protected] <javascript:> > -- You received this message because you are subscribed to the Google Groups "nhusers" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/nhusers. For more options, visit https://groups.google.com/groups/opt_out.
