Learn your way! Get started

Xamarin Cross Platform, Part 2: Data Access

with expert Wallace McClure

Watch trailer

Xamarin Cross Platform, Part 2: Data Access Trailer

Course at a glance

Included in these subscriptions:

  • Dev & IT Pro Video
  • Dev & IT Pro Power Pack
  • Power Pack Plus

Release date Release date 5/12/2014
Level Level Intermediate
Runtime Runtime 1h 12m
Platform Platform Major browsers on Windows Major browsers on Windows Major browsers on Mac OSX Major browsers on Mac OSX Mobile Devices Mobile Devices
Closed captioning Closed captioning Included
Transcript Transcript Included
eBooks / courseware eBooks / courseware Included
Hands-on labs Hands-on labs N/A
Sample code Sample code Included
Exams Exams Included

Enterprise Solutions
Enterprise Solutions

Need reporting, custom learning tracks, or SCORM? Learn More

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.


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.

Meet the expert

Wallace McClure 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 & 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)