LINQ with casesensitive

Question

how to compare strings with respect to case sensitive using LINQ

var compare = db.NormalRegistrations .SingleOrDefault(d => d.Name == userr.Name && d.Password == userr.Password);

how to write above query comparision with respect to case sensitive .

Biswa Pujarini Mohapatra · Answer

As per my query it will not show error because if you see am converting the value toLower() So in your case it will convert database value Admin to admin d.Name.ToLower() == userr.Name.ToLower()

Sasi Reddy · Answer

If i stored username as Admin in databaseif i enter as admin it wiill show the error.how to do that?..

Biswa Pujarini Mohapatra · Answer

you can use ToLower()ToUpper() ex: var compare = db.NormalRegistrations .SingleOrDefault(d => d.Name.ToLower() == userr.Name.ToLower() && d.Password.ToLower() == userr.Password.ToLower());