Page History

class 

MidlevelItemCRUD
    {
        

AmazonDynamoDBConfig 

clientConfig 

= 

new AmazonDynamoDBConfig();
		// Set the endpoint URL
		clientConfig.ServiceURL = "http://localhost:8000";
		AmazonDynamoDBClient client = new AmazonDynamoDBClient(clientConfig);

        private static 

string 

tableName = "ProductCatalog";
        

// 

The 

sample 

uses 

the following id PK value to add book item.
    

private static 

int sampleBookId = 555;

        static void 

Main(string[] args)
        

{
            try
       

{
                

Table productCatalog = 

Table.LoadTable(client, tableName);
                CreateBookItem(productCatalog);
      

        RetrieveBook(productCatalog);
            

    // Couple of sample updates.
            

   UpdateMultipleAttributes(productCatalog);
                UpdateBookPriceConditionally(productCatalog);

                // Delete.
      

        DeleteBook(productCatalog);
                

Console.WriteLine("To continue, press Enter");
                

Console.ReadLine();
            

}

            catch (AmazonDynamoDBException e) 

{ Console.WriteLine(e.Message); }
            catch (AmazonServiceException e) { Console.WriteLine(e.Message); }
            catch (Exception e) { Console.WriteLine(e.Message); }

       }
             

{

            Console.WriteLine("\n*** Executing 

CreateBookItem() ***");
            var 

book = new Document();
            book["Id"] = sampleBookId;
     

book["Title"

] = "Book " + sampleBookId;
            

book["Price"] = 19.99;
            

book["ISBN"] = "111-1111111111";
     

private 

static 

void 

RetrieveBook(Table productCatalog)
        {
  

       Console.WriteLine("\n*** Executing 

RetrieveBook() ***");
            // Optional configuration.
    

      GetItemOperationConfig config = new GetItemOperationConfig
      

    {
    

private static void UpdateBookPriceConditionally(Table productCatalog)
        {
        

    Console.WriteLine("\n*** Executing UpdateBookPriceConditionally() ***");

   

        int partitionKey = sampleBookId;

     

       var book = new Document();
      

      book["Id"] = partitionKey;
            

book["Price"] = 29.99;

            // For conditional price update, creating a condition expression.
  

Expression expr = new 

Expression();
            expr.ExpressionStatement = "Price = :val";
           

 expr.ExpressionAttributeValues[":val"] = 19.00;

            // Optional parameters.
            UpdateItemOperationConfig 

config 

= new UpdateItemOperationConfig
            {
                ConditionalExpression = expr,
                

ReturnValues = ReturnValues.AllNewAttributes
            };
            Document updatedBook 

= productCatalog.UpdateItem(book, config);
            Console.WriteLine("UpdateBookPriceConditionally: Printing item whose price was conditionally updated");
           

PrintDocument(updatedBook);
        }

  Console.WriteLine("\n*** Executing DeleteBook() ***");
            // Optional configuration.
            DeleteItemOperationConfig config 

= new 

DeleteItemOperationConfig

       {
                // Return the deleted item.
    

            ReturnValues = 

ReturnValues.AllOldAttributes
            

};
            Document document = productCatalog.DeleteItem(sampleBookId, config);
       

     Console.WriteLine("DeleteBook: Printing deleted just deleted...");
           

 PrintDocument(document);
       

 }