Cosmos: Use the V4 SDK

[AndriySvyryd]

https://github.com/Azure/azure-cosmos-dotnet-v3/blob/v4/changelog.md

[bricelam]

👎 The number four is dead to us. We'll just have to wait for v5.

[onionhammer]

Is there any ETA on this?

[AndriySvyryd]

@onionhammer Depends on when V4 is going to be released. Not sooner than November 2021.

[onionhammer]

@AndriySvyryd Yeah it seems like the v4 branch has withered on the vine.. Right now I don't really see a good reason to use EF Core with Cosmos since Cosmos's .NET SDK own linq query builder does a (much) better job of generating queries than EF

[bricelam]

Cosmos's .NET SDK own linq query builder does a (much) better job of generating queries than EF

We'd love to know where we can do better. Can you provide specific examples?

[onionhammer]

@bricelam

Take for example creating a query like this:

db.Container.Where(p => p.SomeChildren.Any(s => s.Id == someVariable))

Fails to translate with EF Core, but works fine with container.GetItemLinqQueryable. There are a lot of foot guns with EF Core that you dont find until runtime

[klemmchr]

Can we even expect the v4 of the SDK in the next 5 years? Has been some time since the end of 2021.

[onionhammer]

I think V4 is abandoned