String.Equals() not working as intended

by

The string comparison with StringComparison.OrdinalIgnoreCase works in memory or with IEnumerable<T>. You are trying to use it with IQueryable<T>, but the provider of your queryable does not understand it.

This works for me:

db.Users.FirstOrDefault(
     s => s.Username.Equals(username, StringComparison.OrdinalIgnoreCase)
);

More Related Contents:

  1. Entity Framework/Linq EXpression converting from string to int
  2. LEFT JOIN in LINQ to entities?
  3. The result of a query cannot be enumerated more than once
  4. Creating dynamic queries with entity framework
  5. Add the where clause dynamically in Entity Framework
  6. LINQ to Entities group-by failure using .date
  7. Get a list greater than specific value from lists usinq linq c#
  8. System.Linq.Expression.Compile error
  9. Sort a list from another list IDs
  10. When to use Cast() and Oftype() in Linq
  11. Unable to create a constant value of type Only primitive types or enumeration types are supported in this context
  12. Entity Framework Timeouts
  13. How to perform Join between multiple tables in LINQ lambda
  14. LINQ: Select an object and change some properties without creating a new object
  15. For vs. Linq – Performance vs. Future
  16. Error: “The specified LINQ expression contains references to queries that are associated with different contexts”
  17. How to write Asynchronous LINQ query?
  18. LINQ to Entities does not recognize the method ‘Int32 Int32(System.String)’ method, and this method cannot be translated into a store expression
  19. LIKE operator in LINQ
  20. How can I split an IEnumerable into groups of IEnumerable [duplicate]
  21. Linq order by boolean
  22. How do I segment the elements iterated over in a foreach loop
  23. How do I dynamically create an Expression predicate from Expression?
  24. Linq Query Group By and Selecting First Items
  25. Get previous and next item in a IEnumerable using LINQ
  26. Creating a LINQ select from multiple tables
  27. how do access previous item in list using linQ?
  28. How do I compose Linq Expressions? ie Func
  29. If Else in LINQ
  30. Parsing a string C# LINQ expression

Leave a Comment