Book Image

C# 7 and .NET Core: Modern Cross-Platform Development - Second Edition

Book Image

C# 7 and .NET Core: Modern Cross-Platform Development - Second Edition

Overview of this book

If you want to build powerful cross-platform applications with C# 7 and .NET Core, then this book is for you. First, we’ll run you through the basics of C#, as well as object-oriented programming, before taking a quick tour through the latest features of C# 7 such as tuples, pattern matching, out variables, and so on. After quickly taking you through C# and how .NET works, we’ll dive into the .NET Standard 1.6 class libraries, covering topics such as performance, monitoring, debugging, serialization and encryption. The final section will demonstrate the major types of application that you can build and deploy cross-device and cross-platform. In this section, we’ll cover Universal Windows Platform (UWP) apps, web applications, mobile apps, and web services. Lastly, we’ll look at how you can package and deploy your applications so that they can be hosted on all of today’s most popular platforms, including Linux and Docker. By the end of the book, you’ll be armed with all the knowledge you need to build modern, cross-platform applications using C# and .NET Core.
Table of Contents (24 chapters)
C# 7 and .NET Core: Modern Cross-Platform Development - Second Edition
Credits
About the Author
About the Reviewer
www.PacktPub.com
Customer Feedback
Preface

Using SQLite on macOS and mobile platforms


SQLite is a small, cross-platform, self-contained RDBMS that is available in the public domain. It is the most common RDBMS for mobile platforms such as iOS (iPhone and iPad) and Android.

SQLite is included in macOS in the /usr/bin/ directory as a command-line application named sqlite3.

You can download a graphical database manager named SQLiteStudio for SQLite here:

http://sqlitestudio.pl

You can read about the SQL statements supported by SQLite here:

https://sqlite.org/lang.html

Running a script for SQLite

Create a folder named Chapter08 with a subfolder named Ch08_EFCore.

Download the NorthwindSQLite.sql file into the Chapter08 folder.

Start Terminal. Enter commands to change to the Code folder, change to the directory named Chapter08, and run the SQLite script to create the Northwind.db database:

cd Code
cd Chapter08
sqlite3 Northwind.db < NorthwindSQLite.sql

Quit Terminal and launch SQLiteStudio.

Note

If you see a warning about not being able to...