At TechEd New Zealand, I presented a session on Microsoft’s next generation data sync technology from Azure Mobile Services that uses SQLite to support the operations of occasionally-connected apps on #mobile devices.
Most mobile apps require the ability to store data locally to deal with the realities of a disconnected world where ubiquitous wireless networks are non-existent. While many consumer apps get by with saving light amounts of information as small files like XML or JSON, the data requirements of mobile line-of-business apps for the enterprise is significantly greater. With Microsoft Open Technologies Portable Class Library for SQLite, .NET developers can build structured data storage into their Universal Windows Apps. In this video I guide you through creating local databases and tables and show you how to work with offline data via CRUD operations on both Windows and Windows Phone. I also demonstrate the new data sync capability in Microsoft Azure Mobile Services which supports conflict resolution and uses SQLite for local data storage and change tracking. There’s no faster way to build robust mobile apps to meet your most demanding enterprise needs.