public ActionResult FillWithDataDifferentPartitionKeys(int numberOfRows)
        {
            var sw = new Stopwatch();
            sw.Start();
            var account = GetAccountInfo();
            var context = new TestContext(account.TableEndpoint.AbsoluteUri, account.Credentials);

            if (numberOfRows == 0) numberOfRows = 1000000;

            var entityList = new List<TestEntity>();

            const int MAX_OBJECTS_IN_BATCH = 100;
            int objectsInBatch = 0;
            string partitionKey = "C";
            for (int i = 0; i < numberOfRows; i++)
            {
                var id = Convert.ToBase64String(Guid.NewGuid().ToByteArray()).Replace("/", "-").Replace("+", "_").Replace("=", "");
                var rowKey = (DateTime.MaxValue - DateTime.Now).Ticks.ToString("d19") + id;
                var entity = new TestEntity()
                {
                    PartitionKey = partitionKey,
                    RowKey = rowKey,
                    FirstName = "John" + i.ToString(),
                    LastName = "Doe" + i.ToString(),
                    SomeId = id
                };

                context.AddObject(TABLE_NAME, entity);

                if (++objectsInBatch == MAX_OBJECTS_IN_BATCH)
                {
                    entityList.Add(entity);
                    partitionKey += i.ToString();
                    objectsInBatch = 0;
                    context.SaveChangesWithRetries(SaveChangesOptions.Batch);
                }
            }

            context.SaveChangesWithRetries(SaveChangesOptions.Batch);
            ViewData["Data"] = entityList;
            ViewData["Elapsed"] = sw.ElapsedMilliseconds;
            return View("Index");
        }
        public ActionResult QueryByRowKey(string rowKey)
        {
            var sw = new Stopwatch();
            sw.Start();

            var account = GetAccountInfo();
            var context = new TestContext(account.TableEndpoint.AbsoluteUri, account.Credentials);
            var query = context.CreateQuery<TestEntity>(TABLE_NAME);

            var entity = query.Where(e => e.RowKey== rowKey).ToList();

            //var entity = (from e in context.CreateQuery<TestEntity>(TABLE_NAME) where e.RowKey==rowKey select e);

            ViewData["Data"] = entity;
            ViewData["Elapsed"] = sw.ElapsedMilliseconds;
            return View("Index");
        }
        public ActionResult QueryByRowkeyAndPartitionKey(string partitionKey, string rowKey)
        {
            var sw = new Stopwatch();
            sw.Start();

            var account = GetAccountInfo();
            var context = new TestContext(account.TableEndpoint.AbsoluteUri, account.Credentials);
            var query = context.CreateQuery<TestEntity>(TABLE_NAME);

            var entity = query.Where(e => e.PartitionKey.Equals(partitionKey) && e.RowKey.Equals(rowKey)).ToList();

            ViewData["Data"] = entity;
            ViewData["Elapsed"] = sw.ElapsedMilliseconds;
            return View("Index");
        }
        public ActionResult QueryByLastNameColumn(string lastName)
        {
            var sw = new Stopwatch();
            sw.Start();

            var account = GetAccountInfo();
            var context = new TestContext(account.TableEndpoint.AbsoluteUri, account.Credentials);
            var query = context.CreateQuery<TestEntity>(TABLE_NAME);

            var entity = query.Where(e => e.LastName == lastName).ToList();

            ViewData["Data"] = entity;
            ViewData["Elapsed"] = sw.ElapsedMilliseconds;
            return View("Index");
        }