Cross Platform Data Access with Xamarin & C# For iPhone, iPad, and Android - Local, Web Services, & Sql Server
Posted
by Wallym
on ASP.net Weblogs
See other posts from ASP.net Weblogs
or by Wallym
Published on Wed, 14 May 2014 15:54:00 GMT
Indexed on
2014/05/26
21:28 UTC
Read the original article
Hit count: 542
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.
© ASP.net Weblogs or respective owner