C
C#8mo ago
Mango

❔ EF Core LINQ translation document

In the process of upgrading a .NET Core 1.1 to 6 app, our EF Core LINQ queries are now hitting some translation issues with the usage of String.Equals(String, StringComparison) method in the IQueryable<DbSet<T>>.Where() method. I’m going through those to clean them up but I was wondering if anyone knew of a blog/SO post that has a list of all the LINQ translation gotchas we may run into?
3 Replies
Tvde1
Tvde18mo ago
SQL server by default does case insensitive comparison just in case
Mango
Mango8mo ago
Isn’t it Collation based though?
Accord
Accord8mo ago
Was this issue resolved? If so, run /close - otherwise I will mark this as stale and this post will be archived until there is new activity.
Want results from more Discord servers?
Add your server
More Posts
Is there a better (or more appropriate way) of implementing method overloading for my usecase here?I have two methods of a class I'm writing - in one usecase I want to update the field with no return❔ Referencing new projects with the main projectLet's say I have a main project `CoreProject` and I want to add 2 new projects: a `LoggerService` an❔ Refactoring strategy pattern to a simpler codeI have the following code and I want te refactor it to a less-boiler-plate code. Wha'ts suposed to❔ Avoid "Authorizing..." in Blazor Page (Identity)I am trying to avoid the loading text "Authorizing..." when going to my index.razor page. I have add❔ Trying to return```csharp using System; using System.Drawing; using System.Windows.Forms; using AForge.Imaging; usin❔ Cancel task on nested exceptionI have a series of nested async methods, when a exception is thrown I want to cancel the task. The m✅ Newtonsoft serializing returns nothing with custom converterSo I have a custom `JsonConverter` from newtonsoft that is supposed to replace object properties tha❔ 415 error from HttpClient put to a controller using FromBody``` (await _client.PutAsync("foo", new StringContent(5.ToString()))).EnsureSuccessStatusCode(); ``` ✅ Cors not adding headers on ASP.NET applicationI have a asp.net core web app, that will receive calls from a different origin (different port). To ❔ IServiceProvider, scoped services, scopesis it correct usage? ```csharp projectA: services.AddScoped<FooContext>(); var serviceProvider = ser