Solved

How to make Accent Insensitive search

Posted on 2008-10-16
5
394 Views
Last Modified: 2013-12-17
I need to modify this function so it will be case insensitive. My server (Sql2008) is set with the correct collation, so if i query directly against the database the result is OK. But i query from a preloaded list (to speed up things).

 How can this be achived?

Here is the C# function:

        internal IEnumerable<BO.DriverSearchGridBO> ApplySearchTextFilterTogrid IEnumerable<BO.DriverSearchGridBO> list, string textToSearch)
        {
            IEnumerable<BO.DriverSearchGridBO> newlist =
                  from d in list
                  where d.Name.Contains(textToSearch)
                  select d;
            return newlist;
        }

Thanks,
0
Comment
Question by:Morris7
  • 3
  • 2
5 Comments
 
LVL 13

Expert Comment

by:crazyman
ID: 22730658
have you tried
where d.Name.ToLower().Contains(textToSearch.ToLower())
0
 

Author Comment

by:Morris7
ID: 22730692
I asked ACCENT insensitive...

Your solution is for CASE insensitive comparison.

This one is a little bit tougher:)
0
 
LVL 13

Accepted Solution

by:
crazyman earned 500 total points
ID: 22730881
Quote :
"I need to modify this function so it will be case insensitive"
0
 

Author Comment

by:Morris7
ID: 22731320
Sorry for the typo. The title says ACCENT but i screw up the descriptions.

I will give you points:)
0
 

Author Closing Comment

by:Morris7
ID: 31506703
Now try to answer the corected question if you can...
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This document covers how to connect to SQL Server and browse its contents.  It is meant for those new to Visual Studio and/or working with Microsoft SQL Server.  It is not a guide to building SQL Server database connections in your code.  This is mo…
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
This is a video describing the growing solar energy use in Utah. This is a topic that greatly interests me and so I decided to produce a video about it.

930 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now