Windows Phone 8 and Azure Table Storage (Windows Azure)

using Microsoft.WindowsAzure.Storage;
using Microsoft.WindowsAzure.Storage.Auth;
using Microsoft.WindowsAzure.Storage.Table;

// Create the connectionstring
String StorageConnectionString = "DefaultEndpointsProtocol=https;AccountName=[yourAccount];AccountKey=[yourKey]";

// Retrieve storage account from connection string.
 CloudStorageAccount storageAccount = CloudStorageAccount.Parse(StorageConnectionString);

// Create the table client.
CloudTableClient tableClient = storageAccount.CreateCloudTableClient();

    public partial class MainPage : PhoneApplicationPage
    {
        // Constructor
        public MainPage()
        {
            InitializeComponent();
            Loaded += MainPage_Loaded;
        }

        private async void MainPage_Loaded(object sender, System.Windows.RoutedEventArgs e)
        {
            // Create the connectionstring
            String StorageConnectionString = "DefaultEndpointsProtocol=https;AccountName=[yourAccount];AccountKey=[yourKey]";

            // Retrieve storage account from connection string.
            CloudStorageAccount storageAccount = CloudStorageAccount.Parse(StorageConnectionString);

            // Create the table client.
            CloudTableClient tableClient = storageAccount.CreateCloudTableClient();

            // Create the table if it doesn't exist.
            CloudTable table = tableClient.GetTableReference("customer");
            await table.CreateIfNotExistsAsync();

        }
    }

using Microsoft.WindowsAzure;
using Microsoft.WindowsAzure.Storage.Table;

namespace myPhoneApp
{
    class CustomerEntity : TableEntity
    {

        public CustomerEntity(string pKey, string rKey)
        {
            this.PartitionKey = pKey;
            this.RowKey = rKey;
        }

        public string CustomerID { get; set; }

        public string Name { get; set; }

        public string Email { get; set; }

        public string CountryCode { get; set; }

        public string Budget { get; set; }

        public string Used { get; set; }

    }
}

    public partial class MainPage : PhoneApplicationPage
    {
        // Constructor
        public MainPage()
        {
            InitializeComponent();
            Loaded += MainPage_Loaded;
        }

        private async void MainPage_Loaded(object sender, System.Windows.RoutedEventArgs e)
        {
            // Create the connectionstring
            String StorageConnectionString = "DefaultEndpointsProtocol=https;AccountName=[yourAccount];AccountKey=[yourKey]";

            // Retrieve storage account from connection string.
            CloudStorageAccount storageAccount = CloudStorageAccount.Parse(StorageConnectionString);

            // Create the table client.
            CloudTableClient tableClient = storageAccount.CreateCloudTableClient();

            // Create the CloudTable object that represents the "customer" table.
            CloudTable table = tableClient.GetTableReference("customer");

            // Create a new customer entity.
            CustomerEntity cus = new CustomerEntity("myCustomer", "C001");
            cus.CustomerID = "C001";
            cus.Name = "Win Weerachai";
            cus.Email = "[email protected]";
            cus.CountryCode = "TH";
            cus.Budget = "1000000.00";
            cus.Used = "600000.00";

            // Create the TableOperation that inserts the customer entity.
            TableOperation insertOperation = TableOperation.Insert(cus);

            // Execute the insert operation.
            await table.ExecuteAsync(insertOperation);

        }
    }

    public partial class MainPage : PhoneApplicationPage
    {
        // Constructor
        public MainPage()
        {
            InitializeComponent();
            Loaded += MainPage_Loaded;
        }

        private async void MainPage_Loaded(object sender, System.Windows.RoutedEventArgs e)
        {
            // Create the connectionstring
            String StorageConnectionString = "DefaultEndpointsProtocol=https;AccountName=[yourAccount];AccountKey=[yourKey]";

            // Retrieve storage account from connection string.
            CloudStorageAccount storageAccount = CloudStorageAccount.Parse(StorageConnectionString);

            // Create the table client.
            CloudTableClient tableClient = storageAccount.CreateCloudTableClient();

            // Create the CloudTable object that represents the "customer" table.
            CloudTable table = tableClient.GetTableReference("customer");

            // Construct the query operation for all customer entities where PartitionKey="myCustomer".
            TableQuery<CustomerEntity> query = new TableQuery<CustomerEntity>().Where(TableQuery.GenerateFilterCondition("PartitionKey", QueryComparisons.Equal, "myCustomer"));

            // Create List Customer
            List<CustomerEntity> ls = new List<CustomerEntity>();

            // Print the fields for each customer.
            foreach (CustomerEntity entity in table.ExecuteAsync(query))
            {
                // Create a new customer entity.
                CustomerEntity cus = new CustomerEntity(entity.PartitionKey, entity.RowKey);
                cus.CustomerID = entity.CustomerID;
                cus.Name = entity.Name;
                cus.Email = entity.Email;
                cus.CountryCode = entity.CountryCode;
                cus.Budget = entity.Budget;
                cus.Used = entity.Used;
                ls.Add(cus);
            }

        }
    }

    public partial class MainPage : PhoneApplicationPage
    {
        // Constructor
        public MainPage()
        {
            InitializeComponent();
            Loaded += MainPage_Loaded;
        }

        private async void MainPage_Loaded(object sender, System.Windows.RoutedEventArgs e)
        {
            // Create the connectionstring
            String StorageConnectionString = "DefaultEndpointsProtocol=https;AccountName=[yourAccount];AccountKey=[yourKey]";

            // Retrieve storage account from connection string.
            CloudStorageAccount storageAccount = CloudStorageAccount.Parse(StorageConnectionString);

            // Create the table client.
            CloudTableClient tableClient = storageAccount.CreateCloudTableClient();

            // Create the CloudTable object that represents the "customer" table.
            CloudTable table = tableClient.GetTableReference("customer");

            // Create a retrieve operation that takes a customer entity.
            TableOperation retrieveOperation = TableOperation.Retrieve<CustomerEntity>("myCustomer", "C001");

            // Execute the operation.
            TableResult retrievedResult = table.ExecuteBatchAsync(retrieveOperation);

            // Assign the result to a CustomerEntity object.
            CustomerEntity updateEntity = (CustomerEntity)retrievedResult.Result;

            if (updateEntity != null)
            {
                updateEntity.CustomerID = txtCustomerID.Text;
                updateEntity.Name = txtName.Text;
                updateEntity.Email = txtEmail.Text;
                updateEntity.CountryCode = txtCountryCode.Text;
                updateEntity.Budget = txtBudget.Text;
                updateEntity.Used = txtUsed.Text;

                // Create the InsertOrReplace TableOperation
                TableOperation insertOrReplaceOperation = TableOperation.InsertOrReplace(updateEntity);

                // Execute the operation.
                table.ExecuteBatchAsync(insertOrReplaceOperation);

            }

        }
    }

TableOperation retrieveOperation = TableOperation.Retrieve<CustomerEntity>("myCustomer", "C001");

                updateEntity.CustomerID = txtCustomerID.Text;
                updateEntity.Name = txtName.Text;
                updateEntity.Email = txtEmail.Text;
                updateEntity.CountryCode = txtCountryCode.Text;
                updateEntity.Budget = txtBudget.Text;
                updateEntity.Used = txtUsed.Text;

    public partial class MainPage : PhoneApplicationPage
    {
        // Constructor
        public MainPage()
        {
            InitializeComponent();
            Loaded += MainPage_Loaded;
        }

        private async void MainPage_Loaded(object sender, System.Windows.RoutedEventArgs e)
        {
            // Create the connectionstring
            String StorageConnectionString = "DefaultEndpointsProtocol=https;AccountName=[yourAccount];AccountKey=[yourKey]";

            // Retrieve storage account from connection string.
            CloudStorageAccount storageAccount = CloudStorageAccount.Parse(StorageConnectionString);

            // Create the table client.
            CloudTableClient tableClient = storageAccount.CreateCloudTableClient();

            // Create the CloudTable object that represents the "customer" table.
            CloudTable table = tableClient.GetTableReference("customer");

            // Create a retrieve operation that expects a customer entity.
            TableOperation retrieveOperation = TableOperation.Retrieve<CustomerEntity>("myCustomer", "C001");

            // Execute the operation.
            TableResult retrievedResult = table.ExecuteBatchAsync(retrieveOperation);

            // Assign the result to a CustomerEntity.
            CustomerEntity deleteEntity = (CustomerEntity)retrievedResult.Result;

            // Create the Delete TableOperation.
            if (deleteEntity != null)
            {
                TableOperation deleteOperation = TableOperation.Delete(deleteEntity);

                // Execute the operation.
                table.ExecuteBatchAsync(deleteOperation);
            }

        }
    }

TableOperation retrieveOperation = TableOperation.Retrieve<CustomerEntity>("myCustomer", "C001");

TableOperation deleteOperation = TableOperation.Delete(deleteEntity);