Questions tagged [azure-table-storage]
Azure Table storage is a cloud-based NoSQL service which is ideal for large amounts of structured, non-relational data.
azure-table-storage
2,390
questions
141
votes
22
answers
87k
views
Azure table storage returns 400 Bad Request
I ran this in debug mode, and I attach an image with the details of the exception. How can I know what went wrong? I was trying to inset data in a table. Can't azure give me more details?
Obs: The ...
- 5,506
81
votes
5
answers
16k
views
When should I use Sql Azure and when should I use table Storage?
When should i use Sql Azure and when should I use table Storage?
I was thinking , use table storage for transaction processing scenarios e.g. debit credit accounts kind of scenario and use Sql Azure ...
- 1,097
77
votes
29
answers
78k
views
Azure Storage Emulator error and does not start
This error is really driving me crazy. (Terminal running in administrator mode)
Initialization of azure storage emulator in sql server 2014:
C:\Program Files (x86)\Microsoft SDKs\Windows Azure\...
- 1,505
69
votes
3
answers
30k
views
How to execute an Azure table storage query async? client version 4.0.1
Want to execute queries Async on Azure Storage Client Version 4.0.1
There is NO method ExecuteQueryAsync()..
I am missing something? Should we continue to use the ExecuteQuerySegmentedAsync still?
...
- 3,876
68
votes
3
answers
45k
views
Azure storage tables vs SQL
I'm just starting to learn Azure and I can't see too many scenarios where you would want to put something into an Azure storage table as opposed to SQL. I guess maybe I'm used to working in ...
- 5,012
67
votes
7
answers
25k
views
Azure Table Vs MongoDB on Azure
I want to use a NoSQL database on Windows Azure and the data volume will be very large. Whether a Azure Table storage or a MongoDB database running using a Worker role can offer better performance and ...
- 1,313
61
votes
3
answers
66k
views
How to get all rows in Azure table Storage in C#?
I am trying to get a list of all entities inside an azure table.
Any idea of how I would write this query?
- 3,955
50
votes
5
answers
64k
views
Multiple filter conditions Azure table storage
How can I set multiple filters on a Azure Table Storage?
This is what I've tried:
string partitionFilter = TableQuery.GenerateFilterCondition("PartitionKey", QueryComparisons.Equal, "partition1");
...
- 4,288
46
votes
5
answers
17k
views
Where can I get a list of Unicode chars by class?
I'm new to learning Unicode, and not sure how much I have to learn based on my ASCII background, but I'm reading the C# spec on rules for identifiers to determine what chars are permitted within Azure ...
- 61k
46
votes
4
answers
27k
views
Painfully slow Azure table insert and delete batch operations
I am running into a huge performance bottleneck when using Azure table storage. My desire is to use tables as a sort of cache, so a long process may result in anywhere from hundreds to several ...
- 635
45
votes
1
answer
35k
views
Azure Table Storage vs CosmosDB Table API [closed]
In Microsoft Build 2017 event, I came across CosmosDB Table API. It looks like Azure Table Storage.
Does it mean Microsoft is going to stop supporting Azure Table Storage eventually?
Now, Document Db ...
- 5,023
44
votes
5
answers
23k
views
Microsoft Azure DocumentDB vs Azure Table Storage
For several recent years, Microsoft offers a "NoSQL" key/value storage, called "Table Storage" (http://azure.microsoft.com/en-us/documentation/articles/storage-dotnet-how-to-use-tables/)
Table ...
- 4,177
44
votes
3
answers
56k
views
NoSQL: Getting the latest values from tables DynamoDB/Azure Table Storage
I have a little problem that needs some suggestions:
Lets say we have a few hundred data tables with a few dozen million rows each.
Data tables are timestamp(key) - value
Data tables are written once ...
- 497
42
votes
5
answers
31k
views
Azure Table Storage RowKey restricted Character Patterns?
Are there restricted character patterns within Azure TableStorage RowKeys? I've not been able to find any documented via numerous searches. However, I'm getting behavior that implies such in some ...
- 463
41
votes
3
answers
20k
views
How to filter Azure logs, or WCF Data Services filters for Dummies
I am looking at my Azure logs in the WADLogsTable and would like to filter the results, but I'm clueless as to how to do so. There is a textbox that says:
"Enter a WCF Data Services filter to ...
- 90.2k
41
votes
2
answers
19k
views
Azure Tables: best practices for choosing partition/row keys
What would be best practices for choosing partition/row keys for entities in Azure Tables? The common advice is to magically balance between partition size and number of partitions. But no one seems ...
- 2,212
41
votes
3
answers
27k
views
What is the azure table storage query equivalent of T-sql's LIKE command?
I'm querying Azure table storage using the Azure Storage Explorer. I want to find all messages that contain the given text, like this in T-SQL:
message like '%SysFn%'
Executing the T-SQL gives "An ...
- 11.7k
40
votes
1
answer
17k
views
Difference between InsertOrMerge and InsertOrReplace TableOperations
I'm using Azure table storage for storing the data. I'm getting confused on when to use insertOrReplace and insertOrMerge. I'm using Azure SDK 1.7.
My understanding on insertOrReplace is replacing ...
- 3,015
37
votes
5
answers
67k
views
Could not load file or assembly Microsoft.Data.OData Version=5.2.0.0 error in Azure Cloud Worker Role using Table Storage
I have a very peculiar issue using Azure Table Storage. I have a .NET 4.5 project in Visual Studio 2012 where I deal with all my Azure Table Storage functions. This project/dll is referenced by two ...
- 3,092
34
votes
3
answers
4k
views
Do I use Azure Table Storage or SQL Azure for our CQRS Read System?
We are about to implement the Read portion of our CQRS system in-house with the goal being to vastly improve our read performance. Currently our reads are conducted through a web service which runs a ...
- 5,794
32
votes
2
answers
23k
views
Getting started with Azure storage: Blobs vs Tables vs SQL Azure
It's quite a topic, blobs vs tables vs SQL, and despite all I read so far I still can't find some proper reasoning on what to use when.
We have a multi-tenant SaaS web-application which we are about ...
- 14.5k
31
votes
1
answer
24k
views
How to add a new column to an existing azure table storage
We are using azure table storage and have thousands of tables using the same schema. Now we are looking to add another column to these tables. How do we add another column to our existing tables ...
- 343
31
votes
1
answer
10k
views
Microsoft.WindowsAzure.Storage vs Microsoft.WindowsAzure.StorageClient
What's the difference between these two assemblies and when should I use each? I find that there are class name collisions between them so I imagine that I should only use one.
Example
Microsoft....
- 3,386
29
votes
6
answers
24k
views
Querying azure table storage for null values
Does anyone know the proper way to query azure table storage for a null value. From what I've read, it's possible (although there is a bug which prevents it on development storage). However, I keep ...
- 4,495
29
votes
6
answers
12k
views
How do you exclude a property from being persisted in Azure Table storage?
If I have a class like this:
public class Facet : TableServiceEntity
{
public Guid ParentId { get; set; }
public string Name { get; set; }
public string Uri{ get; set; }
...
- 2,165
26
votes
5
answers
45k
views
Get all records from azure table storage
Using this code block
try
{
StorageCredentials creds = new StorageCredentials(accountName, accountKey);
CloudStorageAccount account = new CloudStorageAccount(creds, useHttps: true);
...
- 2,252
26
votes
1
answer
14k
views
Azure web/worker role read configuration settings
What is the best way/recommended way to read settings from a worker/web role?
Is it:
CloudConfigurationManager.GetSetting("ConnectionString") (this I'm using)
or
RoleEnvironment....
- 6,011
25
votes
1
answer
9k
views
Key differences between Azure DocumentDB and Azure Table Storage
I am choosing database technology for my new project. I am wondering what are the key differences between Azure DocumentDB and Azure Table Storage?
It seems that main advantage of DocumentDB is full ...
- 8,548
24
votes
8
answers
32k
views
Delete All Azure Table Records
I have an Azure Storage Table and it has 3k+ records.
What is the most efficient way to delete all the rows in the table?
- 2,272
24
votes
2
answers
6k
views
Is Azure CloudTable thread-safe?
I'm writing to Azure Table storage using Storage SDK 2.0 from different threads (ASP.NET application).
Is CloudTable object thread-safe? Can I initialize CloudStorageAccount, CloudTableClient and ...
- 8,440
23
votes
11
answers
5k
views
Azure Tables or SQL Azure?
I am at the planning stage of a web application that will be hosted in Azure with ASP.NET for the web site and Silverlight within the site for a rich user experience. Should I use Azure Tables or SQL ...
- 22.8k
23
votes
2
answers
19k
views
What is purpose of ETag in ITableEntity
for ETag in ITableEntity MSDN says:
Gets or sets the entity's current ETag. Set this value to '*' in order to blindly overwrite an entity as part of an update operation.
I am unable to undersatnd the ...
- 303
22
votes
6
answers
33k
views
Azure Table Storage - No connection could be made because the target machine actively refused it 127.0.0.1:10002
I'm developing an ASP.Net MVC & WebApi site that uses table storage in Visual Studio 2015 on Windows 8. It was working fine in the development environment (when I set UseDevelopmentStorage=true in ...
- 533
22
votes
6
answers
31k
views
Count rows within partition in Azure table storage
I've seen various questions around SO about how to get the total row count of an Azure storage table, but I want to know how to get the number of rows within a single partition.
How can I do this ...
- 508
21
votes
3
answers
11k
views
Can PartitionKey be queried with StartsWith?
In Azure Table Storage, is it possible to query PartitionKey with a StartsWith or some other operator e.g. Contains, etc.
I know I can do this with RowKeys but is it possible to do it with ...
- 29.2k
21
votes
4
answers
12k
views
Azure: Redis vs Table Storage for web cache
We currently use Redis as our persistent cache for our web application but with it's limited memory and cost I'm starting to consider whether Table storage is a viable option.
The data we store is ...
- 1,683
21
votes
2
answers
23k
views
Azure table storage - Simplest possible example
Whenever learning new technologies I like to write the simplest possible example. Usually this means a console app with the least number of references. I've been trying, with little success, to write ...
- 1,075
20
votes
3
answers
27k
views
Azure Table Storage Exception: 409 Conflict unexpected?
I'm using WindowsAzure.Storage nuget package version 9.0.0.
Install-Package WindowsAzure.Storage -Version 9.0.0
The following code (table.CreateIfNotExistsAsync()) throws the error: The remote ...
- 1,707
19
votes
4
answers
34k
views
How do I query an Azure storage table with Linq?
I'm not sure where exactly, but I've got the wrong idea somewhere with this.
I'm trying to, in a first instance, query an azure storage table using linq. But I can't work out how it's done. From ...
- 3,061
19
votes
1
answer
12k
views
Update RowKey or PartitionKey in Azure Table Storage
Can i update RowKey or PartitionKey properties of entity in Azure Table Storage?
I thought yes or maybe just PartitionKey but now i am trying to do that(try to change RowKey or PartitionKey) and get ...
- 233
19
votes
1
answer
7k
views
Storing a DateTime value of DateTime.MinValue in azure table storage fails
I am getting an aggregated exception while storing a DateTime value of either null or DateTime.MinValue. How do I store an acceptable default DateTime value in Azure table store?
- 237
19
votes
2
answers
9k
views
Azure Table Storage CreateQuery in .NET Core
I'm porting my existing class library that targets .NET Framework 4.6.2 to .NET Core 1.1.
Looks like some of the methods that are available in .NET Framework version are not there in .NET Core. Two ...
- 29.2k
19
votes
4
answers
17k
views
Code First & Identity with Azure Table Storage
I'm working on a small web app and I've just hit the point in development where I need to start making database decisions. My original plan was to go EF Code First with MSSQL on Azure because it just ...
- 2,874
18
votes
2
answers
19k
views
The correct way to delete and recreate a Windows Azure Storage Table = Error 409 Conflict - Code : TableBeingDeleted
Im really new to Windows Azure development and have a requirement to store some data in a windows azure storage table.
This table will really only exist to provide a quick lookup mechanism to some ...
- 1,187
18
votes
4
answers
9k
views
Atomic operations in azure table storage
I am looking to implement a page view counter in azure table storage. If say two users visit the page at the same time, and the current value on PageViews = 100, is it guaranteed that the PageViews = ...
- 548
18
votes
3
answers
20k
views
TableQuery<T> from Azure TableStorage that filters on PartitionKey
I'm trying to abstract geting all entities from a Table by partitionKey, like so:
public List<T> GetEntities<T>(string partitionKey, T entity) where T : TableEntity
{
try
...
- 2,572
18
votes
1
answer
7k
views
Azure Storage Table Paging
To implement simple paging in Azure Storage in relatively straight forward: Paging with Windows Azure Table Storage. This can be implemented with continuation token functionality.
But.
This is just ...
- 12.8k
18
votes
4
answers
16k
views
How to fake Azure Table Storage in .NET for Unit Testing? [closed]
I am working on a system that uses Azure Table Storage. In other systems (e.g., SQL, File based, etc), I can write a fake that allows me to test my data persistence logic. However, I can't see an easy ...
- 7,309
17
votes
3
answers
8k
views
Rename Azure Storage Table?
Is it not possible to rename an Azure Storage Table?
I cannot seem to find anything online (not even cmdlets). There are no options for this in Visual Studio Server Explorer, Cloud Storage Studio or ...
- 39.6k
17
votes
2
answers
28k
views
Querying Windows Azure Table Storage with multiple query criteria
I'm trying to query a table in Windows Azure storage and was initially using the TableQuery.CombineFilters in the TableQuery<RecordEntity>().Where function as follows:
TableQuery.CombineFilters(...
- 1,891