Linq queries not working when object name is not match with collection name

[DilanJayamuni]

We are facing a problem integrating Linq queries with Couchbase. Basically, "SpinAggregate" in the code is our class name (object name) for the collection and our collection name is "SpinAggregates" in the database (with an "s" added to the end of the class name).

Related to this reason Linq queries are not working correctly on the code. Because our object name and collection name of the DB is different and query is not returning result from DB. Can you tell me how we can solve this problem to use Couchbase Linq queries on code?

I have attached query (code) that how we are quering by using Linq here. That code is correct. But the problem is it not picking data from collection.

I guess _bucketContext dll not picking correct collection from the DB based on object (_bucketContext.Query())

Thank you
Dilan Jayamuni

[brantburnett]

Dilan,

Try the instructions on using scopes/collections in this document and see if it helps: https://github.com/couchbaselabs/Linq2Couchbase/blob/master/docs/scopes-collections.md

If not, please let me know. Note that your attachments did not come through on the issue in GitHub.