Any collation that ends with "CI" is case insensitive. In order to find
out, you can do a:
SELECT DATABASEPROPERTYEX('MyDatabase', 'Collation')
RP
On Friday, August 30, 2013 10:49:47 AM UTC+1, Ricardo Peres wrote:
>
> 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]
>>
>
--
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.
