entity framework and where with like

Question

I' m using this instruction:

db_user = db.CBR_User.FirstOrDefault(p => p.Codice_Fiscale == code);

I want use "like" operator instead == for manage case insensitive

How can do it?

thanks

Answer 1

If you want to do an equality comparison anyway, I suggest two ways:

db_user = db.CBR_User.FirstOrDefault(p => p.Codice_Fiscale.Equals(code, StringComparison.OrdinalIgnoreCase));

Or

db_user = db.CBR_User.FirstOrDefault(p => p.Codice_Fiscale.ToUpper() == code.ToUpper());

If you don't want that, you can use StartsWith, Contains, etc, with the parameter StringComparison.OrdinalIgnoreCase.