Modern C# and .NET Tutorial: Cross-Platform Basics/

...

Building an Entity Model Using SQLite

Learn about creating entity data models for our practical applications using SQLite, generating entity models, and setting up the SQLite database.

We'll cover the following...

Database files
Creating a class library for entity models using SQLite
- Try it yourself

Practical applications usually need to work with data in a relational database or another data store. We will define an entity data model for the Northwind database stored in SQL Server or SQLite. It will be used in most apps we create in subsequent chapters.

Database files

The Northwind4SQLServer.sql and Northwind4SQLite.sql script files are different. The script for SQL Server creates $13$ tables as well as related views and stored procedures. The script for SQLite is a simplified version that only creates $10$ ...

Introduction

Hello, C#! Welcome, .NET!

Speaking C#

Controlling Flow, Converting Types, and Handling Exception

Writing, Debugging, and Testing Functions

Building Your Own Types with Object-Oriented Programming

Implementing Interfaces and Inheriting Classes

Packaging and Distributing .NET Types

Working with Common .NET Types

Working with Files, Streams, and Serialization

Working with Data Using Entity Framework Core

Querying and Manipulating Data Using LINQ

Introducing Web Development Using ASP.NET Core

Building Websites Using ASP.NET Core Razor Pages

Building Websites Using the Model-View-Controller Pattern

Building and Consuming Web Services

Building User Interfaces Using Blazor

Conclusion

Building an Entity Model Using SQLite

Database files