azure-samples / storage-table-dotnet-getting-started Goto Github PK

The getting started sample demonstrates how to perform common tasks using the Azure Table Service in .NET including creating a table, CRUD operations, batch operations and different querying techniques.

License: MIT License

C# 100.00%

storage-table-dotnet-getting-started's Introduction

services	platforms	author
storage	dotnet	jasonnewyork

Getting Started with Azure Table Storage in .NET

This demo demonstrates how to perform common tasks using Azure Table storage and Azure Cosmos DB Table API including creating a table, CRUD operations, batch operations and different querying techniques.

If you don't have a Microsoft Azure subscription you can get a FREE trial account here

Note: This sample uses the .NET 4.5 asynchronous programming model to demonstrate how to call the Storage Service using the storage client libraries asynchronous API's. When used in real applications this approach enables you to improve the responsiveness of your application. Calls to the storage service are prefixed by the await keyword. If you don't have a Microsoft Azure subscription you can get a FREE trial account here

Running this sample

Azure Cosmos DB Table API

NOTE: This sample will not work against tables in table account created during the preview period. It will only work against tables created in table accounts created after GA on 11/15/2017.

Go to your Azure Cosmos DB Table API instance in the Azure Portal and select "Connection String" in the menu, select the Read-write Keys tab and copy the value in the "CONNECTION STRING" field.
Open the App.config file and set StorageConnectionString to your connection string.
Load the project in Visual Studio (the community version is available for free)
Run

More Information

-Introduction to Azure Cosmos DB Table API

Azure Table storage

This sample can be run using either the Azure Storage Emulator that installs as part of this SDK - or by updating the App.Config file with your connection string.

To run the sample using the Storage Emulator (default option):

Download and Install the Azure Storage Emulator here.
Start the Azure Storage Emulator (once only) by pressing the Start button or the Windows key and searching for it by typing "Azure Storage Emulator". Select it from the list of applications to start it.
Open App.config and set the value of StorageConnectionString to "UseDevelopmentStorage=true;"
Load the project in Visual Studio (the community version is available for free)
Run

To run the sample using the Storage Service:

Go to your Azure Storage account in the Azure Portal and under "SETTINGS" click on "Access keys". Copy either key1 or key2's "CONNECTION STRING".
Open the app.config file and comment out the connection string for the emulator (UseDevelopmentStorage=True) and uncomment the connection string for the storage service (AccountName=[]...)
Load the project in Visual Studio (the community version is available for free)
Run

More information

storage-table-dotnet-getting-started's People

Contributors

Stargazers

Watchers

Forkers

mewilson01 tamram dineshmurthy rikvoorb alberto-tek stevenpicado chp013 matdonell 8106karlsson pavlovmilen yejia21 zeroinfinite mirogrg1 dikaarta pankajbajaj yaronyg jensnordenbro markopuhalovic mikaelgra fredatgithub girl89 chmitch ammonma per1215 coolya ishepherd feluxmaj markjbrown msanka georgenorberg nbendeaus wmengmsft thomaswurtz mraipsec-mra chugh97 t2kx dxdinh klcintw xochitlm jitendriyag2 gayathri-hepzi susanta-neudesic upadhyayap arsri1981 paganhub ravisolanki07 sree102006 malon875875 virtualitadmin kaidan41 devdigiacademy vdantuluri cloudyus mkornegay niloshima-srivastav einbahn isabella232 pgmstan koksdatapro motionlessdude

storage-table-dotnet-getting-started's Issues

MethodAccessException: Attempt by method

Trying to instantiate the following class:

namespace Server.Base.Azure.Table.Models
{
public class CosmosDbBase : TableEntity where T : TableEntity, new()
{
public string TableName { get; }
public CloudTable Table { get; }

    public CosmosDbBase(string tableName = "") <<------- Fails Here
    {
        if (string.IsNullOrEmpty(tableName))

           throw new ArgumentNullException("tableName");

        this.TableName = tableName;

        this.Table = CosmosDbStorageAdapter.GetCloudTable(tableName);
    }

I am getting the following error:

MethodAccessException: Attempt by method 'Microsoft.Azure.CosmosDB.Table.TableEntity.set_DisableCompiledSerializers(Boolean)' to access method 'Microsoft.Azure.Storage.Core.Util.PlatformAgnosticReflectionExtensions.FindStaticMethods(System.Type, System.String)' failed.

When I do it for Table storage it works perfectly any ideas whats going wrong?

Update for WindowsAzure.Storage 8.x

This would be most useful, as some of the samples don't work with 8.x. For example, CloudTable.ExecuteQuery no longer exists in 8.x

The call to "await ServicePropertiesSample(tableClient);" throws a Bad Request (400) exception...

When the demo gets to the line "await ServicePropertiesSample(tableClient);" under advanced samples, it throws a bad request (400) exception.

When commenting out that line the demo runs to completion without errors.

I'm running with the local storage emulator, and I'm using Visual Studio 2015.

Best regards
Michael

CosmosDB URL changed - should change method for checking iscosmosdb

Hi guys,

I just stumbled upon an error due to the fact that url for cosmos no longer is .table.cosmosdb. but is .table.cosmos. so the method IsAzureCosmosdbTable in SampleUtils class on line 110 should be changed to look for "table.cosmos" instead of "table.cosmosdb"

Best,
Tomislav

table.ExecuteAsync(insertOrMergeOperation) timing out.

 TableOperation insertOrMergeOperation = TableOperation.Insert(entity);
            // Execute the operation.
            TableResult result = await table.ExecuteAsync(insertOrMergeOperation); //times out.

Microsoft.Azure.Documents.GoneException: Message: The requested resource is no longer available at the server.

I've a question on stack overflow for this here.

Neither this sample or the code I have can do updates.

ExecuteAsync on Azure table storage with Sas Token is giving error

I am using Sas token and trying to perform ExecuteAsync Operation to retrieve data from Azure table storage. At times(Sometimes it works fine) i am getting "object reference not set to an instance of an object" after performing ExecuteAsync. When i run it from the test method it always works. I am sure that Sas token is valid and has all the permissions given. My startup project here is a MicrosoftBotFramework project. The code that i am using to initialize cloud storage account is:

 var sasToken = 
    configurationProvider.GetSetting(CommonConfig.TableStorageSasToken);
    var sasAccount = new StorageCredentials(sasToken);
    cloudStorageAccount = new Lazy<CloudStorageAccount>(() => new 
    CloudStorageAccount(sasAccount, 
    configurationProvider.GetSetting(CommonConfig.StorageAccountName), 
    endpointSuffix: null, useHttps: true), 
    LazyThreadSafetyMode.ExecutionAndPublication);

Code to retrieve data:

var table = await GetTableReference(tableName).ConfigureAwait(false);
           var retrieveOperation = TableOperation.Retrieve<T>(partitionKey, rowKey);
           try
           {
               var retrievedResult = await table.ExecuteAsync(retrieveOperation).ConfigureAwait(false);
               return (T)retrievedResult.Result;
           }

This same method works fine when i directly use the StorageConnection string instead of Sas token. Is there something wrong with my CloudStorageAccount initialization. Same code is being called from Unit test as well and it works fine. Can someone please help me solve this issue? Thanks.