2

I have a scenario where I insert/update data to Azure storage table 2 values MyValue and MyDate.

There are few scenarios where I have to update only 1 value MyValue and not MyDate.

But When I do update operation, it updates bothe the values. It changes myValue but makes MyDate to null.

Is there any operation in update where I can skip MyDate update and keep its value as it is?

public class MyEntity : TableEntity
{
public MyEntity(string partitionKey, string rowKey) : 
 base(partitionKey, rowKey)
 {
 }
public string MyValue { get; set; }
public DateTime MyTime { get; set; }
}

This code insert or replaces data

   var entity = new MyEntity(partitionKey, rowKey)
     {
        MyValue = "test my value",
        MyTime = DateTime.Now();
     };

    AddEntity(entity);



     public void AddEntity(MyEntity entity)
     {
     CloudTable table =     _tableClient.GetTableReference("myAzureStorageTableName");
 TableOperation insertOp = TableOperation.InsertOrReplace(entity);
 table.Execute(insertOp);                         
      }

2 Answers 2

3

Here Both InsertOrMerge and Merge operation are ok.

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

Comments

2

You can leverage Merge operation. Please note that you should set ETag to "*" if you don't want to read the entity before updating it.

References:

  1. Merge Entity REST API
  2. TableOperation.Merge Method in .NET library

1 Comment

Link #2 is broken

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.