.NET EFCore | Entity Framework Core (EF 7) CRUD Operations using SQLite Database
Table of Contents:
00:00:00 | Introduction to CRUD operations.
00:02:01 | Creating Web API project.
00:03:10 | Installing Sqlite, EFCore, EFCore.Tools Nuget packages.
00:04:32 | Setting up the Sqlite database connection string.
00:05:30 | Registering Sqlite database connection.
00:07:00 | Creating Application Db Context class.
00:08:00 | Creating models.
00:09:20 | Adding Database Migration.
00:12:11 | Installing Db Browser for Sqlite database.
00:16:16 | Creating Api Controller to perform CRUD operations.
00:16:49 | Creating Constructor to initiate database connection.
00:17:20 | Read operation.
00:20:14 | Create operation.
00:20:03 | Delete operation.
00:26:40 | Update operation.
00:30:42 | Running and fixing errors.
00:30:11 | Testing the API with CRUD methods.
Download Source code | https://github.com/Netcode-Hub/EFCore-CRUD-Operation-using-SQLite-Database
Related Videos
https://youtu.be/2do-4kix83E | Entity FrameworkCore (EF7) CRUD Operations using SQLite Database.
https://youtu.be/Xzi3ifxFmn8 | Customize Blazor Loading Screen Animation.
https://youtu.be/e7Rg6ppE1y4 | File Download with Web API in Blazor Web Assembly
https://youtu.be/IOAmf75te9A | Entity FrameworkCore CRUD Operations using SQL Server Database
https://youtu.be/YEfzc55KjEs | Multiple FileUploads with Web API in Blazor Web Assembly
https://youtu.be/qi7pSnujBrs | Scaffold SQL Database with DB First migration in Web API using EntityFrameworkCore.
https://youtu.be/qTLFYF13nMc | LocalStorage in Blazor WebAssembly.
https://youtu.be/G2QHZPdxN0M | Web API EntityFrameworkCore (EF7) Pagination using Skip() and Take() methods.
https://youtu.be/GWfuDPFxVNk | Send Email in Web API using Mailkit SMTP.
https://youtu.be/7mBTh0tlC-w | AutoMapper Data Transfer Objects DTO with Web API Explained.
https://youtu.be/saPnZhPFqCI | Blazor WebAssembly Chat with SignalR using WebSockets.
https://youtu.be/x2EJ4C_E3w0 | Create JSON Web Token (JWT) for User Registration and Login using Password Hash and Salt.
https://youtu.be/VwI7SMYiLH8 | EFCore All Relationships (11, 1n, nn ) with Entity Framework Core SQL Server.
https://youtu.be/REHetc6M0Lo | Web API Role – Based Authorization with JSON Web Token (JWT).
What is SQLite
SQLite is a software library that provides a relational database management system. The lite in SQLite means lightweight in terms of setup, database administration, and required resources.
What is SQLite used for?
SQLite is used to develop embedded software for devices like televisions, cell phones, cameras, etc. It can manage low to medium-traffic HTTP requests. SQLite can change files into smaller size archives with lesser metadata. SQLite is used as a temporary dataset to get processed with some data within an application.
What does CRUD stand for?
CREATE, READ, UPDATE and DELETE
CRUD is the acronym for CREATE, READ, UPDATE and DELETE. These terms describe the four essential operations for creating and managing persistent data elements, mainly in relational and NoSQL databases.