How to insert C# variables in Azure Blob Index Queries

Question

Foolowing MS Docs here:

https://learn.microsoft.com/en-us/azure/storage/blobs/storage-blob-index-how-to?tabs=net

Some examples are given for queries:

// Blob index queries and selection
String singleEqualityQuery = @"""Archive"" = 'false'";
String andQuery = @"""Archive"" = 'false' AND ""Priority"" = '01'";
String rangeQuery = @"""Date"" >= '2020-04-20' AND ""Date"" <= '2020-04-30'";
String containerScopedQuery = @"@container = 'mycontainer' AND ""Archive"" = 'false'";

These examples are useless as no one in the real world is going to hard code queries using static values.

If i try to insert a variable into a query when using the 'AND' staement then the string won't compile. Example:

var varibale1 = "test1";
var varibale2 = "test2";
// Not working!
query = @"""folderDepth"" = '" + varibale1 + "' AND ""parentFolder"" = 'hardCodedvalue'";
// Hard coded values
query = @"""folderDepth"" = 'test1' AND ""parentFolder"" = 'test2'";

try to compose the query with use $"" and \" (escape) to put " in your string learn.microsoft.com/en-us/dotnet/csharp/programming-guide/… — user3401335
– user3401335, Commented Nov 20, 2021 at 22:47

OJB1 · Accepted Answer · 2021-11-21 11:49:09Z

1

The screenshot below shows the MS code example I was trying to work with:

Each index tag in the above example queries are wrapped in two sets of double quotes. This would work until I started inserting variables into the query as shown below:

The query that worked for me was to escape the second index tag in the string i.e. ParentFolder.

// -----------------------------
// ----- Tested and worked -----
// -----------------------------
string query4 = @"""FolderDepth"" = '" + varibale1 + "' AND \"ParentFolder\" = '" + varibale2 + "'";

answered Nov 21, 2021 at 11:49

OJB1

2,8757 gold badges43 silver badges77 bronze badges

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

Collectives™ on Stack Overflow

How to insert C# variables in Azure Blob Index Queries

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