Trying to get object from CosmosDb via MVC app via client.CreateDocumentQuery

Question

First attempt at accessing Cosmos db.

All this is in a DAL project layer of the solution (n-tier). EndPointURI and PrimaryKey and DBName are setup by the class constructor.

I execute the client.CreateDocumentQuery

But not seeing the expected cast to the out param of the function i.e. "user". I see the generated query string only.

I'm basing my code on this

public void  GetUserByEmail(string email, out IQueryable<Shared.User> user)
    {
        FeedOptions queryOptions = new FeedOptions { MaxItemCount = -1 };
        user = null;

        try
        { 
            user = this.client.CreateDocumentQuery<Shared.User>(
                       UriFactory.CreateDocumentCollectionUri(DBName, "Users"), queryOptions)
                       .Where(f => f.Email == email);
        }
        catch (Exception ex)
        {
        }

    }

If trying ReadDocumentAsync, I get the following

Have you tried executing the query in portal? with same email id? — Sajeetharan
– Sajeetharan, Commented Feb 21, 2022 at 10:55
SELECT * FROM c shows me my json, i.e. { "UserName": "[email protected]", "Email": "[email protected]", "Password": "P@ssw0rd1", "Role": { "id": "1", "Role": "Admin" }, "id": "d3e4351d-79fc-469f-8c22-8735e6f3fe71" } — Neal Rogers
– Neal Rogers, Commented Feb 21, 2022 at 10:58
If I use SELECT * FROM c WHERE c.id = "d3e4351d-79fc-469f-8c22-8735e6f3fe71" then it works in the portal, but it won't allow me to specify the where with the emailaddress — Neal Rogers
– Neal Rogers, Commented Feb 21, 2022 at 11:28

Sajeetharan · Accepted Answer · 2022-02-21 13:00:28Z

1

Try this, you need to return the first item

 var response = this.client.CreateDocumentQuery<eUser>( UriFactory.CreateDocumentCollectionUri("demo", "Users"), queryOptions) 
.Where(f => f.Email == email).AsEnumerable().ToArray().FirstOrDefault();

edited Feb 21, 2022 at 13:00

answered Feb 21, 2022 at 12:25

Sajeetharan

223k65 gold badges370 silver badges409 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Trying to get object from CosmosDb via MVC app via client.CreateDocumentQuery

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related