Watch trailer
Course at a glance
Included in these subscriptions:
- Dev & IT Pro Video
- Dev & IT Pro Power Pack
| Release date | 5/12/2014 | |
| Level | Intermediate | |
| Runtime | 1h 12m | |
| Closed captioning | Included | |
| Transcript | Included | |
| eBooks / courseware | Included | |
| Hands-on labs | N/A | |
| Sample code | Included | |
| Exams | Included |
Course description
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.
Prerequisites
This course assumes that students have some programming background and experience using Visual Studio 2013. In addition, the course assumes knowledge of Visual C#, Xamarin.iOS, and Xamarin.Android in the Windows and MAC environment. An understanding of XML is also required. It would be helpful to have viewed these other LearnNowOnline courses; Xamarin Tool with Various Mobile Platforms, Xamarin Mobile and Web Services, Xamarin Cross Platform and File Linking, and Xamarin Cross Platform: PCL and Razor before viewing this course.
Learning Paths
This course is part of the following LearnNowOnline SuccessPaths™:
Mobile Development Using Xamarin
Meet the expert
Wallace McClure specializes in building applications that have large numbers of users and large amounts of data as well as user interface specific technologies such as AJAX, iPhone, and Android. He is a Microsoft MVP, ASPInsider, and a partner in Scalable Development, Inc. Wally has authored books on iPhone Programming with Mono/MonoTouch, Android Programming with Mono for Android, application architecture, ADO.NET and SQL Server, and finally AJAX.
Course outline
Cross platform data access
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)