How to find column value by comparing another column value in LINQ where case does not any matter

Question

Here string productname2="xyz" but actually in database PRODUCTNAME is "XYZ" when I compare it return false,so I could not get productcode,here I want not only compare but also some value from this satetement.

orderdetail.PRODUCTCODE = context.PRODUCTs.Where(pro => pro.PRODUCTNAME==productname2)
                         .Select(code => code.PRODUCTCODE).DefaultIfEmpty().Max();

Any help will be appreciated

How about using ToLowerInvariant() on both sides of your comparison? — wkl, Jan 09 '17 at 09:00
@wkl `ToLower` has internationalisation issues - always better to use the relevant override of `string.Equals(...)` — Rowland Shaw, Jan 09 '17 at 09:02
I don't believe that this is best solved in the query. Given that this is coming from the DB, it looks like you might better benefit from setting the correct (case-insensitive) collation on the column in the database. By converting case, you are discarding the benefit of any indexes you might have on the column. — spender, Jan 09 '17 at 09:04
@RowlandShaw You are right, I edited my comment to using ToLowerInvariant. I think that should do it. — wkl, Jan 09 '17 at 09:04
@wkl IIRC, that will blow up when it gets translated to SQL. — spender, Jan 09 '17 at 09:05
could you please specify the data provider you are querying against? objects, sql, ...? — , Jan 09 '17 at 09:08

score 3 · Answer 1 · answered Jan 09 '17 at 09:01

3

You have to compare strings ignoring case :

orderdetail.PRODUCTCODE = context.PRODUCTs.Where(pro => pro.PRODUCTNAME.Equals(productname2, StringComparison.InvariantCultureIgnoreCase).Select(code => code.PRODUCTCODE).DefaultIfEmpty().Max();

answered Jan 09 '17 at 09:01

PMerlet

2,568
4
23
39

I strongly suggest to use `string.Equals` instead of `instance.Equals`, as the former call is null-safe :) Additionally, I would also question if you need culture-aware comparison, or ordinal - the later one has better performance ... As always, depending on the data provider you querying against (some calls might not get translated to pure sql ...) – Jan 09 '17 at 09:04
4

Will this translate to SQL? – spender Jan 09 '17 at 09:06
.Select(code => code.PRODUCTCODE).DefaultIfEmpty().Max(); do not work properly this option,it show syntax error – anis programmer Jan 09 '17 at 09:14

score 0 · Answer 2 · edited Jan 09 '17 at 11:43

0

Hope this helps

.Where(pro => pro.PRODUCTNAME.Equals(productname2, StringComparison.OrdinalIgnoreCase))

OrdinalIgnoreCase and CultureIgnoreCase just differs in the rules applied for comparison, where the former performs better with less rules than latter.

edited Jan 09 '17 at 11:43

abc

2,285
5
29
64

answered Jan 09 '17 at 09:19

jvigneshprabhu

26
4

No syntax error but I have got the same result,I do not found the product code for case sensative – anis programmer Jan 09 '17 at 09:27

score 0 · Answer 3 · edited May 23 '17 at 10:29

0

It works

orderdetail.PRODUCTCODE = context.PRODUCTs.Where(pro => pro.PRODUCTNAME.ToLower().Contains(productname2.ToLower())).Select(code => code.PRODUCTCODE).DefaultIfEmpty().Max();

from this link LINQ Contains Case Insensitive

edited May 23 '17 at 10:29

Community

1
1

answered Jan 09 '17 at 10:42

anis programmer

989
1
10
25

How to find column value by comparing another column value in LINQ where case does not any matter

3 Answers3