DEV Community

Manu Radhakrishnan
Manu Radhakrishnan

Posted on

How to effectively do dynamic query using LINQ against a Azure Cosmos Document DB SQL API?

I know that Azure Cosmos DB SQL API allows using SQL syntax to query the documents from it and working for me.

For eg: SELECT * FROM c WHERE c.DynamicContent.MailingAddress.City LIKE '%PORT%' is working well.

The data I'm trying to save is like this:

{
  "Id": 1001
  "AttentionName": "Keyword list",

Top comments (0)

A Workflow Copilot. Tailored to You.

Pieces.app image

Our desktop app, with its intelligent copilot, streamlines coding by generating snippets, extracting code from screenshots, and accelerating problem-solving.

Read the docs

👋 Kindness is contagious

Please leave a ❤️ or a friendly comment on this post if you found it helpful!

Okay