Learn your way! Get started

Xamarin Cross Platform, Part 2 of 2: Data Access

with expert Wallace McClure


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


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.

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)