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 ...

Get C# 7 and .NET Core: Modern Cross-Platform Development - Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.