A nearshore team from Uruguay, South America (GMT-3) January 2011 - Posts - UruIT Blog

UruIT Blog

A nearshore team working with Microsoft technologies.

Sponsors

News

UruIT at WEBLOGS asp.net

January 2011 - Posts

Which markets and languages is dynamics crm 2011 online available right now and at which price for customers and partners?

Hi,

It has just announced officially the release of the final version of Dynamics CRM 2011 Online (RTW = Released To Web). Actually, the one and only Steve Ballmer (Microsoft CEO) will be introducing it next Thursday, January 20th, 2011, at 9 A.M. Pacific Time at a FREE global virtual launch. If you haven’t registered yet, you can do so by clicking here.

This edition is available right now for the promotion price of $34 per user/per month. (currently this promotion is valid until June 30, 2011). FREE 30-day trial is currently available.

Besides, if you are a Microsoft Partner, you can take special promotions where the price reduces to $19 per user/per month. If you are a MS Partner we strongly suggest you take a look at this page for Gold, Silver and Microsoft Cloud Essentials Pack or Microsoft Cloud Accelerate or this other one for Certified, Gold Certified, BizSpark and Small Business Specialist Microsoft Partners, and any partners who have a CSA agreement.

Here comes the question: which markets and languages is this cloud version available right now?

Next picture pretends to answer this frequently asked question:

image 

Within Q1, 2011 it will be also released the on-premise version (the version that you can install and set up on your office/datacenter). Currently it’s still in RC1 edition, available to download here.

We strongly suggest you try this cloud version and if any help needed to set up or customize your organization, just let us know.

 

Pablo Peralta

Microsoft MVP | Dynamics CRM

Twitter: @pabloperalta



Creating tables and managing CRUD operations in Windows Azure…

Windows Azure Table Service provides structured storage, but tables are not relational database tables as they are in SQL Server for instance. Windows Azure Table Service instead follows a simple and flexible model of entities and properties.

The table service was specially designed for massive scalability and availability, supporting billions of entities. In this post I am going to share the steps to create and manage table operations in Windows Azure.

The following diagram shows the Table service architecture:

image

  • Storage Account: Encompasses the blob, queue and table services. Defines the URI scheme for accessing the services. For example the URI for accessing the table service is http|https://<account name>.table.core.windows.net
  • Tables: are the containers for storing data. Data is stored as a collection of entities. There can be any number of tables in an account in the table service.
  • Entities: stored in tables, they are pretty similar to rows in a relational database.
  • Properties: entities consist of a set of name-value pairs called properties (analogous to columns).
    • Properties available data types
      • Binary -> byte[]
      • Boolean -> bool
      • DateTime -> DateTime
      • Double ->Double
      • Guid -> Guid
      • Int32 -> int or Int32
      • Int64 -> long or Int64
      • Stirng –> string

 

Where to start?

The following are the three steps required to create a table:

1. Define the schema for the table (Entity)

2. Define the context, the actions that we will do with the table

3. Create the table

 

1. Defining an Entity

Before we can store an entity we must define it. In order to do this we have to create a class, which inherits from TableServiceEntity. The TableServiceEntity defines a PartitionKey, RowKey and Timestamp properties, which we will inherit. The first two attributes should be initialized in the creation time, while the timestamp is assigned automatically.

clip_image002

2. Creating a Context

Once we have created the entity then we should create the Context to manage the table [CRUD operations], creating a class that inherits from TableServiceContext, which is included in the Microsoft.WindowsAzure.StorageClient assembly.  Here we create properties to expose collections of each entity. (Our table(s))
The following could be an example:

clip_image004

 
3. Creating the table

The last step is creating the table itself; we can create it locally or in the cloud. Additionally, we can do it from any application. In the example, I am doing it directly within a WebRole.cs class that is generated when a WebRole project is created.

clip_image006

Now, we can use the context to manage the table. The following are examples of how to use the context:

· Initialize the context:
CloudStorageAccount _account = CloudStorageAccount.DevelopmentStorageAccount;
PersonTableServiceContext _personServiceContext =
new PersonTableServiceContext(_account.TableEndpoint.ToString(), _account.Credentials);

· Get all:
_personServiceContext.People

· Add a record:
Person person = new Person();

_personServiceContext.AddPerson(person);

· Remove a record:
_personServiceContext.RemovePerson(rowKey);

· Update record data

_personServiceContext.UpdatePerson(personUpdated);

 

Hope you find this post useful as well as try Windows Azure Table Service in your cloud apps.

Diego Acosta

Twitter: @acostami



More Posts