Tutorial Introduction
EasySQLite is a seven-day .NET 8 operating SQLite introductory to hands-on detailed tutorial (including selection, development, release, deployment)!
What is SQLite?
SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine.SQLite is the most widely deployed SQL database engine in the world.SQLite source code is not copyrighted.
SQLite is a lightweight embedded relational database in the form of a small C language library. It is a self-contained, server-less, zero-configuration database engine. Unlike traditional database systems, SQLite reads and writes directly to ordinary disk files and does not require a separate database server. It supports the standard SQL query language and provides transaction support and ACID properties (Atomicity, Consistency, Isolation and Durability).
- SQLite source code:/sqlite/sqlite
What is a relational database?
-
The difference between non-relational and relational databases in detail
A relational database (SQL) library refers to a database that uses a relational model (a two-dimensional table model) to organize data, and is a type of database that uses Structured Query Language (SQL) for data management and manipulation. It uses the form of tables to organize and store data, and establishes connections between data by defining relationships between tables.
SQLite has the following features
- Embedded: SQLite's libraries can be easily embedded into applications without the need for a separate database server process.
- Serverless: Unlike most database systems, SQLite does not require a separate database server; all data is stored in a single disk file.
- Zero Configuration: There are no complex configuration or administrative tasks when using SQLite. Simply bring in the SQLite library and get started.
- Lightweight: SQLite is a lightweight database engine with small library file sizes and is very efficient in terms of memory usage.
- Transaction support: SQLite supports transaction operation, which can ensure the consistency and integrity of data.
- Cross-platform: SQLite can run on multiple operating systems, including Windows, Mac, Linux, and more.
- Public Domain Code: SQLite's source code is in the public domain and is free for commercial or private use.
Use of technology stacks and development environments
The main technology stack used in our .NET 8 Getting Started with SQLite to Hands-On Tutorial is shown below:
- Database: SQLite.
- Front-end: Blazor WebAssembly, BootstrapBlazor.
- Backend: Core 8.0 Web API, SQLite-net ORM, AutoMapper, Swagger.
- Development Tools: Visual Studio 2022 needs to be upgraded to v17.8 or later to support .NET 8 (long term LTS support).
Front-end and back-end framework preview
Detailed tutorials for selection and development
- Day 1 Introduction to SQLite
- Day 2 Configuring the SQLite Environment on Windows
- Day 3 SQLite Quick Start
- Day 4 EasySQLite front-end and back-end project framework construction
- Day 5 introduces SQLite-net ORM and encapsulates common methods.
- Day 6 back-end class management related interface refinement and Swagger customization configuration
- Day 7 BootstrapBlazor UI component library introduction (1)
- Day 7 Blazor class management page writing and interface interfacing (2)
- Day 7 Blazor student management page writing and interface interfacing (3)
Release Deployment Detailed Tutorial
- Windows 10 IIS Web Server Installation and Configuration
- Deploying Core Web API and Blazor Wasm on IIS
Project Source Code Launch
Configure multiple startup projects to run:
Project Effect Demonstration
Backend WebApi
front end page
Project source code address
More useful features and characteristics of the project welcome to the project open source address to view 👀, do not forget to give the project a Star support 💖.
- Open source address:/YSGStudyHards/EasySQLite
A selection of great projects and frameworks
This project has been included in the C#/.NET/.NET Core Excellent Projects and Frameworks Selection, focusing on the excellent projects and frameworks selection can let you keep abreast of the latest developments and best practices in the field of C#, .NET and .NET Core, and improve the efficiency and quality of development work. The pit has been dug, you are welcome to submit PR recommendations or self-recommendation (so that excellent projects and frameworks are not buried 🤞).
- /YSGStudyHards/DotNetGuide/blob/main/docs/DotNet/
DotNetGuide technical community exchange group
- DotNetGuide Technical Community is an open source technical community for .NET developers, aiming to provide developers with comprehensive C#/.NET/.NET Core related learning materials, technical sharing and consulting, project framework recommendations, job search and recruitment information, and problem solving platform.
- In the DotNetGuide technical community, developers can share their technical articles, project experience, learning experience, encountered difficult technical problems and solutions, and also have the opportunity to meet like-minded developers.
- We are committed to building a positive, harmonious and friendly . Whether you are a beginner or an experienced developer, we hope to provide you with more value and growth opportunities.
Welcome to join DotNetGuide Technical Community WeChat 👪!