Hi, I upgraded from 2.17 to 2.19 the C# driver and I have a query like:
var data = collection
.AsQueryable()
.Select(x => new
{
A1 = (string)x.Data["a1"],
B2 = (string)x.Data["b2"],
C3 = (string)x.Data["c3"],
D4 = (long?)x.Data["d4"]["d5"],
E5 = (int?)x.Data["e5"]["e6"],
F6 = x.Data["f6"]["7"] == null
? null
: ((IEnumerable<BsonValue>)x.Data["f6"]["f7"]).Select(_ => (string)_["f8"])
})
.OrderByDescending(x => x.E5)
.FirstOrDefault();
This worked fine with 2.17, after upgrading (I found out you folks switched to LINQv3 provider which might be root cause) it fails with expression not supported exceptions for Nullable (long? and int?) casts.
Any ideas how to fix it and keep new LINQv3 provider?
I looked at related:
Issue with 2.18 to 2.19 NuGet Upgrade of MongoDB C# Driver
Thank you,
V.