Hello ,
We use the method ToDataSourceResult ( Telerik UI for Asp.net Core 2024.1) and EF Core (8.0) to perform a simple query on a table. The primary key of the table is a String type and is case-sensitive. There are two pieces of data in our database. Their primary key values only differ in case.
ID: DEHE061800005DTF, Name: First
ID: DEHE061800005DTf, Name: Second
When we filter based on the primary key, we always get two pieces of data, but they are actually the same piece of data. In other words, another piece of data was not returned. Such as:
ID: DEHE061800005DTF, Name: First
ID: DEHE061800005DTF, Name: First
It seems that some kind of operation is performed internally according to the primary key, but because the case is not taken into account, the same piece of data is used twice.
We wanted to know if we could somehow solve this problem.
Thanks!