動画検索
関連広告
検索結果
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
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
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?