Cross Platform Data Access with Xamarin & C# For iPhone, iPad, and Android - Local, Web Services, & Sql Server

The following is a link to cross platform data access training with Xamarin & C#.   It is intended for use on iPhone, iPad, and Android devices.  The course covers local data in Sqlite, calling Web Services via REST and JSON, and calling Sql Server.

Url: http://www.learnnowonline.com/course/cpx2/xamarin-cross-platform-data-access/ 

Course Data 

Applications live on data. These applications can vary from an online social network service, to a company’s internal database, to simple data, and all points in between. This Course will focus on how to easily access data on the device, communicate back and forth with a web service, and then finally to a SQL server database. 

Outline

• Local Data (27:36)
• Introduction (00:36)
• Problem (01:57)
• Solution (02:01)
• LINQ (02:03)
• LINQ Status (00:48)
• SQLite (02:18)
• SQLite - .Net Developers (00:50)
• SQLite-net (01:07)
• SQLite-net Attributes (02:10)
• Getting Started (01:09)
• CRUD (01:05)
• SQLite Platforms (01:17)
• Demo: SQLite – Android (04:53)
• Demo: SQLite – iOS (04:56)
• Summary (00:20)

• Web Services Data (32:43)
• Introduction (00:19)
• Async Commands (03:15)
• HttpClient (01:26)
• HTTP Verbs (01:29)
• Notes (00:58)
• GET Operation (01:37)
• JSON.NET (01:50)
• Images (01:16)
• Other Http Verbs (01:27)
• Post (03:18)
• Demo: Http – iOS prt1 (05:26)
• Demo: Http – iOS prt2 (05:28)
• Demo: Http – Android (04:20)
• Summary (00:27)
• Direct Data (12:33)
• Introduction (00:23)
• Remote Data - Direct (02:47)
• Sql Server (01:15)
• Demo: Sql Server – iOS (04:15)
• Demo: Sql Server – Android (01:49)
• "codepage 1252 not supported" (01:03)
• Other Resources (00:43)
• Summary (00:15)

Note: Thanks to Frank Kreuger for his data access library Sqlite-Net.  It is very helpful and I have used it in some other projects beyond just this training session.