Question

我正在使用 Windows Azure 存储表, 想要查询对象。用户输入字符串, 我在数据库中查找 :

var myKey = "SomeCaseSensitiveKeyInputByTheUser";

var someObject = (from o in dataContext.Objects
    where o.SomeString.Equals(myKey)
    select o).FirstOrDefault();

然而,出于某种原因,所有字符串比较似乎都对案例不敏感(包括 和 stringing.Equals () )。然而,我需要匹配用户输入字符串的确切外壳。



在LINQ的查询中我怎么能做这个呢?

Answer 1

Using == is the same as .Equals(..), as it just calls that method. You can force to use a case sensitive comparison using an overload of Equal() passing a string.comparison enum

CurrentCulture                   Compare strings using culture-sensitive sort rules and the current culture.
CurrentCultureIgnoreCase         Compare strings using culture-sensitive sort rules, the current culture, and ignoring the case of the strings being compared.
InvariantCulture                 Compare strings using culture-sensitive sort rules and the invariant culture.
InvariantCultureIgnoreCase       Compare strings using culture-sensitive sort rules, the invariant culture, and ignoring the case of the strings being compared.
Ordinal                          Compare strings using ordinal sort rules.
OrdinalIgnoreCase                Compare strings using ordinal sort rules and ignoring the case of the strings being compared.

更多信息 :

http://msdn.microsoft.com/en-us/library/system.stringcomparisson.aspx" rel=“nofollow'>http://msdn.microsoft.com/en-us/library/system.stringcomparison.aspx

友情链接