I have a “Client” table that has a string field called Name. I have created an index that seems to work vary quickly when I execute the N1QL statement 'select * from
Ngage data where type=‘Client’ and name = ‘Some Client Name’.
The index creation looks like this:
name) WHERE (
type = “Client”)
When it comes to me using a Linq call like this:
var query = from client in CacheProvider.BucketContext.Query()
where client.Name == n
The call takes forever. I have to assume that the parameter names described in the index create are not the same in the N1QL created. Can anyone please help me figure out how I should create the index to work with Linq?