Questions tagged [azure-tablequery]
126 questions
0
votes
1 answer
Azure Table Query : System.InvalidOperationException: 'There is already an open DataReader associated with this Command which must be closed first.'
I'm occasionally getting following error during my table execute query
System.InvalidOperationException: 'There is already an open DataReader associated with this Command which must be closed first.'
private CloudTable table;
public…
Randeep Singh
- 998
- 2
- 11
- 31
0
votes
1 answer
sql injection in no sql db azure table
Like SQL injection, is it possible to have a sql injection in azure table which is a no sql database. I do not have any specific example but is there a way through which a rogue data can create security risk in the table.
rdhaundiyal
- 169
- 10
0
votes
1 answer
Microsoft Azure Storage Explorer - how to query column containing JSON string
I am trying to perform a filtering using the query as shown in the image below, expecting it to filter specific matching rows. But, it doesn't filter the matching rows.
Any thoughts on how to limit it, short of exporting it to a file? I think it…
Athadu
- 854
- 7
- 13
0
votes
1 answer
Null values when reading rows from azure table
I'm trying to get all the rows from an azure storage table, but when i display them all the values except
PartitionKey and RowKey are null or 0. Am i missing something or am i doing something wrong causing all the values to not get read…
Silviu Alexandru
- 69
- 7
0
votes
2 answers
Why the CreateTableClient doesn't exist?
I am a new azure table user, and I am trying to write something to a table could someone please explain me why the storageAccount.CreateTableClient() doesn't work.
using System;
using System.Collections.Generic;
using System.Linq;
using…
user12100672
0
votes
1 answer
Microsoft.Azure.Cosmos.Table LocationMode.SecondaryOnly RA-GRS Exception This operation can only be executed against the primary storage location
I was having as tough time getting Microsoft.Azure.Cosmos.Table to automatically initialise the SecondaryUri when parsing a connection string that used a SAS token.
So I ended up explicitly specifying the TableSecondaryEndpoint in the connection…
golfalot
- 956
- 12
- 22
0
votes
1 answer
Unique list of PartionKey's in Azure Table Storage Account
I would like to get a unique list of PrimaryKey's used in an existing Azure Table Storage Account with a large amount of data. In this db there will be more than 20 unique Primary Key's and I would like to get this unique list back. Is there any…
user2047969
- 27
- 4
0
votes
1 answer
Finding delete entity calls to Azure storage table
Is there a way to find out if there was any delete entity call to a azure table in last 'N' minutes? Basically my goal is to find all operations that updated the table in last 'N' minutes.
Update: I am looking for a way to do it with a rest api call…
Sayantan Ghosh
- 998
- 2
- 9
- 29
0
votes
1 answer
Azure table query performance with partition key, rowkey and non-index
I have a table query below that search by PK, RK and a non-index key.
Will this slow down database search? Will the search by DOB be faster if it performs on web layer via c#?
var name = "John";
var wins = 20;
var dob =…
Pingpong
- 7,681
- 21
- 83
- 209
0
votes
1 answer
Azure Storage Services Api Call: How to use NextPartitionKey and NextRowKey?
The scenario is as follows:
The current MVC5 project provides several views the data of which is retrieved by using various API calls. These calls are carried out using only https://[some_url] strings, replacing variables if required.
All calls…
Sasquatch
- 17
- 1
- 9
0
votes
1 answer
Is there a way to configure Azure Table updates to preserve future/unknown properties/columns?
Suppose I create a model
public class Foo :TableEntity {
public int OriginalProperty {get;set;}
}
I then deploy a service that periodically updates the values of OriginalProperty with code similar to...
//use model-based query
var query = new…
NeilMacMullen
- 3,339
- 2
- 20
- 22
0
votes
1 answer
How to calculate size of all Azure Storage Tables from a Subscription using Powershell
How to calculate size of all Azure Storage Tables from a Subscription using Powershell.
I tried to search online if there is any direct way of querying table sizes but looks like there isn't.
Can you someone please give me a working model of…
Vinny
- 461
- 1
- 5
- 18
0
votes
2 answers
How to escape characters in Azure Table queries?
I want to query for rows where a column named message starts with: metric="foo"
I tried encoding = and " with percentage and hex codes but it did not work.
Microsoft documentations says special characters must be encoded but does not tell how:…
Igor Gatis
- 4,648
- 10
- 43
- 66
0
votes
0 answers
list of object not populating xamarin control if ExecuteQuerySegmentedAsync is called
i have an Azure Table that has 4 columns
public class CategoryTable : TableEntity
{
public bool IsChecked { get; set; }
public string IconUrl { get; set; }
public string IconActiveUrl { get; set; }
public string CategoryName {…
Raas Masood
- 1,475
- 3
- 23
- 61
0
votes
1 answer
Azure Table: What result does ExcuteBatch returns?
I have a azure function app which will generate multiple entries based on one partition key. In case any error during the function execution. I first delete all entities on my azure table which have the same partition key, in case the function get…
LittleFunny
- 8,155
- 15
- 87
- 198