Welcome

Today's Topics

SQLite 101

Four different use scenarios for SQLite databases using C

Demo Entity Framework Core

Demo SQLite -.NET

Demo Dapper

Demo ADO.NET

Summary

Connect and Contribute

Maui Project in Visual Studio

Localdb Service

Methods Required

Test

Add a New Customer

Deleting a Customer

Encrypt SQLite Database with .NET MAUI

STOP! Do This First...

SQLite CRUD App Sample

Implement SQLite Encryption

A Note About Compatibility

What Should I Know More?!

Want To Learn More?

What is LINQ?

LINQ Statements

String & array operators

Intro

What You'll Need

Create the Project

Create.NET Core Program

Build Connection

Open Connection

Create Table Command

Inserting Data

Iterating Through the Results

Conclusion

NET 6 🚀 EF Core & SQLite with Code First Migrations

Create a new Web API Project

Install Entity Framework Core Tools & NuGet Packages

Add the Connection String for SQLite

Create a New Entity

Implement the DataContext

Register the DataContext

Utilize Code First Migrations

Fixing the Connection String

Use the DB Browser for SQLite

Add a Controller with GET & POST Methods

Test Everything

What is SQLite?

Create a new Xamarin.Forms project

Sample App Outline

Install SQLite.NET PCL

Create Model Class

Create Sample Data Class

Insert Data to Database Table

Override OnAppearing Method

Conclusion

Database Context Class

Product Model

Wrapper around Sqlite

Sqlite Flags

Create a Table

Updating an Item

Simple Template Design Pattern

Add the Database Context as a Dependency

Clone Method

Build the App

Intro

Demo app overview (win form app)

What is SQLite

How to create and build SQLite Database: DB Browser for SQLite

Database Structure

Adding the Database to the project

Adding the Connection string

SQLite and Dapper NUGet packages

Data access setup

Retrieving data form DB: LoadPeople()

Sending data to DB: SavePerson()

Wiring up the Demo app

Workings with the Database

Summary and concluding remarks

Create a Data Model class

What is SQLite?

Add Data Annotations to the Model

Create a class that will handle the communication with the database

Add a record to the table

Dependency Injection

Fetch the Data

Create a Collection View

Create the Delete Functionality

Add Styling

Intro

Inspect End Result

Outline Sample App

Install sqlite-net-pcl NuGet

Add Database Model

Primary Keys and Auto Increment

Implement Database Connection

Use Database Connection in Your App

Implement UI

Run Sample App

Outro

Use Existing SQLite Database

What We'll Learn in This Video

Also Works on .NET MAUI!

Add Database File to Embedded Resources

Install SQLite NuGet Package

Inspect Existing Database Schema

Copy Existing Database File to Filesystem

Create Database Models

Setup Database Connection

Implement UI to Show Database Data

Retrieve Data from Database

Running the Sample App

Learn More About SQLite or Databinding?

Connecting to a Database

Entity Framework

Add Key Data Annotation

Connect to the Database

Scaffolding

Introduction

Learning objectives

Compare storage options

The file system

Access the app sandbox

Guidelines for saving data in iOS apps

Knowledge check

Store data locally with SQLite

When to use a database

What is SQLite-net?

How to connect to a SQLite database

Model a SQLite table

How to do basic read and write operations

Execute a SQLite query by using LINQ

Exercise - Store data locally with SQLite

Exercise - Use SQLite asynchronously

Summary and conclusion