Cross Platform Data Access with Xamarin & C# For iPhone, iPad, and Android - Local, Web Services, & Sql Server
- by Wallym
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.