How to ignore case with LINQ-to-SQL?

Question

I'm having problems with getting data using LINQ-to-SQL. I use the following piece of code to look up a user for our web app (user name is email address):

var referenceUser = 
    db.ReferenceUsers
      .SingleOrDefault(rf => rf.Email == values["emailAddress"]);

If I type [email protected] I get a ReferenceUser however if I type [email protected] I don't. How can I get LINQ to ignore the case when selecting a user?

Answer 1

Does:

var referenceUser = 
    db.ReferenceUsers.SingleOrDefault(
        rf => rf.Email.ToLower() == values["emailAddress"].ToLower());

work?

The ToLower() should be translated into the correct SQL to run as a database query, and then return both results.

Answer 2

var referenceUser = db.ReferenceUsers.SingleOrDefault(rf => string.Compare(rf.Email, values["emailAddress"],true)==0);

Where the "true" is whether to ignore case or not

Answer 3

This is how I did it. Might give you a hint. I have a List with Profiles and I want to search for profilenames containing "aR", "Ar" or "AR".

List<Profile> profileList = CreateProfile();
string search = "aR".ToLower();

profileList = (from p in profileList where p.Name.ToLower().Contains(search)
        orderby p.Name select p).ToList();