public async Task InsertAndQuery() { IMobileServiceTable<Dates> table = GetClient().GetTable<Dates>(); DateTime date = new DateTime(2009, 10, 21, 14, 22, 59, 860, DateTimeKind.Local); Log("Start: {0}", date); Log("Inserting instance"); Dates instance = new Dates { Date = date }; await table.InsertAsync(instance); Assert.AreEqual(date, instance.Date); Log("Querying for instance"); List<Dates> 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 ChangeCulture() { IMobileServiceTable <Dates> table = GetClient().GetTable <Dates>(); CultureInfo threadCulture = CultureInfo.DefaultThreadCurrentCulture; CultureInfo threadUICulture = CultureInfo.DefaultThreadCurrentUICulture; DateTime original = new DateTime(2009, 10, 21, 14, 22, 59, 860, DateTimeKind.Local); Dates instance = new Dates { Date = original }; await table.InsertAsync(instance); Log("Change culture to ar-EG"); CultureInfo arabic = new CultureInfo("ar-EG"); CultureInfo.DefaultThreadCurrentCulture = arabic; CultureInfo.DefaultThreadCurrentUICulture = arabic; Dates arInstance = await table.LookupAsync(instance.Id); Assert.AreEqual(original, arInstance.Date); Log("Change culture to zh-CN"); CultureInfo chinese = new CultureInfo("zh-CN"); CultureInfo.DefaultThreadCurrentCulture = chinese; CultureInfo.DefaultThreadCurrentUICulture = chinese; Dates zhInstance = await table.LookupAsync(instance.Id); Assert.AreEqual(original, zhInstance.Date); Log("Change culture to ru-RU"); CultureInfo russian = new CultureInfo("ru-RU"); CultureInfo.DefaultThreadCurrentCulture = russian; CultureInfo.DefaultThreadCurrentUICulture = russian; Dates ruInstance = await table.LookupAsync(instance.Id); Assert.AreEqual(original, ruInstance.Date); CultureInfo.DefaultThreadCurrentCulture = threadCulture; CultureInfo.DefaultThreadCurrentUICulture = threadUICulture; }
public async Task DateKinds() { IMobileServiceTable<Dates> table = GetClient().GetTable<Dates>(); DateTime original = new DateTime(2009, 10, 21, 14, 22, 59, 860, DateTimeKind.Local); Dates instance = new Dates { Date = original }; Log("Start Kind: {0}", instance.Date.Kind); await table.InsertAsync(instance); Assert.AreEqual(DateTimeKind.Local, instance.Date.Kind); Assert.AreEqual(original, instance.Date); Log("Change to UTC"); instance.Date = new DateTime(2010, 5, 21, 0, 0, 0, 0, DateTimeKind.Utc); await table.UpdateAsync(instance); Assert.AreEqual(DateTimeKind.Local, instance.Date.Kind); Log("Change to Local"); instance.Date = new DateTime(2010, 5, 21, 0, 0, 0, 0, DateTimeKind.Local); await table.UpdateAsync(instance); Assert.AreEqual(DateTimeKind.Local, instance.Date.Kind); }
public async Task InsertAndQuery() { IMobileServiceTable <Dates> table = GetClient().GetTable <Dates>(); DateTime date = new DateTime(2009, 10, 21, 14, 22, 59, 860, DateTimeKind.Local); Log("Start: {0}", date); Log("Inserting instance"); Dates instance = new Dates { Date = date }; await table.InsertAsync(instance); Assert.AreEqual(date, instance.Date); Log("Querying for instance"); List <Dates> 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 ChangeCulture() { IMobileServiceTable<Dates> table = GetClient().GetTable<Dates>(); CultureInfo threadCulture = CultureInfo.DefaultThreadCurrentCulture; CultureInfo threadUICulture = CultureInfo.DefaultThreadCurrentUICulture; DateTime original = new DateTime(2009, 10, 21, 14, 22, 59, 860, DateTimeKind.Local); Dates instance = new Dates { Date = original }; await table.InsertAsync(instance); Log("Change culture to ar-EG"); CultureInfo arabic = new CultureInfo("ar-EG"); CultureInfo.DefaultThreadCurrentCulture = arabic; CultureInfo.DefaultThreadCurrentUICulture = arabic; Dates arInstance = await table.LookupAsync(instance.Id); Assert.AreEqual(original, arInstance.Date); Log("Change culture to zh-CN"); CultureInfo chinese = new CultureInfo("zh-CN"); CultureInfo.DefaultThreadCurrentCulture = chinese; CultureInfo.DefaultThreadCurrentUICulture = chinese; Dates zhInstance = await table.LookupAsync(instance.Id); Assert.AreEqual(original, zhInstance.Date); Log("Change culture to ru-RU"); CultureInfo russian = new CultureInfo("ru-RU"); CultureInfo.DefaultThreadCurrentCulture = russian; CultureInfo.DefaultThreadCurrentUICulture = russian; Dates ruInstance = await table.LookupAsync(instance.Id); Assert.AreEqual(original, ruInstance.Date); CultureInfo.DefaultThreadCurrentCulture = threadCulture; CultureInfo.DefaultThreadCurrentUICulture = threadUICulture; }