Maurycy Markowski

Query: add translation for string.Compare for Cosmos

8

both instance and static version

RevEng: add a way to handle shadow properties when generating a entity code file

1

Currently, when we generate c# code for entities during scaffolding, we add code for all properties in the class. This is a problem for temporal tables, since the period properties...

Add missing content to user defined function mapping

1

- The HasFunction overload which takes lambda with default params to register a function - DbFunctionAttribute and properties over that. (https://github.com/dotnet/EntityFramework.Docs/issues/2476) - Specifying a schema or marking function as built-in...

[release/7.0] Fix to #29667 - Count after Take throws "No column name was specified for column 1 of 't'."

1

Ported from https://github.com/dotnet/efcore/pull/30134 Fixes #29667 **Description** Query using keyless entities that also uses Take and Count throws SqlException. **Customer impact** Query using keyless entities that also uses Take and Count...

Issue pointed out by @roji Example query: ```cs ss.Set().OrderBy(x => x.FullName).Take(10) ``` result sql: ```sql @__p_0='10' SELECT COUNT(*) FROM ( SELECT TOP(@__p_0) [g].[Nickname], [g].[SquadId], [g].[FullName] FROM [Gears] AS [g] ORDER...

Query: IQueryable in subquery sometimes triggers validation which prevents IQueryables in the final projection

20

query: ```cs from l1 in ss.Set() orderby l1.Id let inner = (from l2 in l1.OneToMany_Optional1 where l2.Name != "Foo" let innerL1s = from innerL1 in ss.Set() where innerL1.OneToMany_Optional1.Any(innerL2 => innerL2.Id...

Problem was that we when accessing inner property on a JsonElement we used GetProperty. If property is not present (which should be allowed if we try to access optional navigation)...

test: Json_projection_deduplication_with_collection_indexer_in_original query ```cs ss.Set().Select(x => new { x.Id, Duplicate1 = x.OwnedCollectionRoot[0].OwnedReferenceBranch, Original = x.OwnedCollectionRoot[0], Duplicate2 = x.OwnedCollectionRoot[0].OwnedReferenceBranch.OwnedCollectionLeaf }).AsNoTracking() ``` in shaper we extract OwnedReferenceBranch twice: ```cs namelessParameter{3} = namelessParameter{1}.HasValue...

Problem was that for cases that compose on the collection of primitives and then project it, we need identifier to properly bucket the results. On SqlServer we can use hidden...

Port of https://github.com/dotnet/efcore/pull/29574 Fixes https://github.com/dotnet/efcore/issues/29572 **Description** Search condition visitor wasn't handling json scalar expressions properly - we should convert them into search conditions/values just like we do with regular columns...