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.

No Comments