[CSHARP-2826] MongoDB Collections Join Created: 30/Oct/19 Updated: 31/Mar/22 |
|
| Status: | Backlog |
| Project: | C# Driver |
| Component/s: | Linq |
| Affects Version/s: | None |
| Fix Version/s: | None |
| Type: | New Feature | Priority: | Major - P3 |
| Reporter: | Farooq Awan | Assignee: | Unassigned |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Description |
|
Mongodb collection join using c# driver and LINQ. I found two relevant solutions list below equals new { a = y.ClaimId, b = y.CensusId }select x).ToList();}} This query will throw exception The Join query operator is not supported. This query will throw exception The SelectMany query operator is not supported But below query works The problem with this is that it loads the (claimIds and censusIds ) in memory, Actually I want to executes this on server so that it return only required data. I also found a blog for newly mongodb feature (Lookup) discussed in Blog: https://www.axonize.com/blog/iot-technology/joining-collections-in-mongodb-using-the-c-driver-and-linq/ I flow the blog to install required drivers |