Tag: asp.net-core-webapi

Get different results with the same query in T-SQL and LINQ (EF Core)

asp.net-core-webapi entity-framework-core linq sql tsql

I’m trying to retrieve records from a database in Azure and for the checks I run T-SQL queries directly and then pass them to LINQ against the EF Core context, but I’m running into this problem. When I filter for the records with FechaOrientativa greater than or equal to Today, the Estudiar field …

The LINQ expression could not be translated. Translation of method failed

asp.net-core-webapi c# entity-framework-core sql

I want to return list of ItemNos (string), even if few characters match and even if characters match in different place. For eg: If I pass in “appl” or “apole” or “daple”. I want DB to list “apple”. Tried using levenshteinDistance: (Checking for strings with les…