Xamarin Cross Platform, Part 2 of 2: Data Access

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.

Each LearnNowOnline training course is made up of Modules (typically an hour in length). Within each module there are Topics (typically 15-30 minutes each) and Subtopics (typically 2-5 minutes each). There is a Post Exam for each Module that must be passed with a score of 70% or higher to successfully and fully complete the course.

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.

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 and SQL Server, and finally AJAX.

Video Runtime

72 Minutes

Time to complete

200 Minutes

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)