public async Task InsertAndQueryOffset()
        {
            IMobileServiceTable <DateOffsetExample> table = GetClient().GetTable <DateOffsetExample>();

            DateTimeOffset date = new DateTimeOffset(
                new DateTime(2009, 10, 21, 14, 22, 59, 860, DateTimeKind.Utc).ToLocalTime());

            Log("Start: {0}", date);

            Log("Inserting instance");
            DateOffsetExample instance = new DateOffsetExample {
                Date = date
            };
            await table.InsertAsync(instance);

            Assert.AreEqual(date, instance.Date);

            Log("Querying for instance");
            List <DateOffsetExample> items = await table.Where(i => i.Date == date).Where(i => i.Id >= instance.Id).ToListAsync();

            Assert.AreEqual(1, items.Count);
            Assert.AreEqual(date, items[0].Date);

            Log("Finish: {0}", items[0].Date);
        }
        public async Task InsertAndQueryOffset()
        {
            IMobileServiceTable<DateOffsetExample> table = GetClient().GetTable<DateOffsetExample>();

            DateTimeOffset date = new DateTimeOffset(
                new DateTime(2009, 10, 21, 14, 22, 59, 860, DateTimeKind.Utc).ToLocalTime());
            Log("Start: {0}", date);

            Log("Inserting instance");
            DateOffsetExample instance = new DateOffsetExample { Date = date };
            await table.InsertAsync(instance);
            Assert.AreEqual(date, instance.Date);

            Log("Querying for instance");
            List<DateOffsetExample> items = await table.Where(i => i.Date == date).Where(i => i.Id >= instance.Id).ToListAsync();
            Assert.AreEqual(1, items.Count);
            Assert.AreEqual(date, items[0].Date);

            Log("Finish: {0}", items[0].Date);
        }