.NET 7 SQLite Database CRUD Operations in Web API using Entity Framework Core
Table of Contents:
00:00 | Introduction to SQLite CRUD Operation in EFCore.
01:52 | Creating Web API project.
04:44 | Installing EFCore, EFCore.Tools NuGet packages.
06:00 | Setting up database connection string in appsettings.json.
06:36 | Registering database connection in program.cs file.
07:48 | Installing EFcore.SQLite NuGet package.
09:05 | Creating Application Db Context class.
10:19 | Creating User model.
11:37 | Adding Database-Migration.
13:54 | Adding User API Controller.
14:50 | Creating Constructor to inject database connection.
15:05 | Adding CREATE action method / operation.
18:27 | Adding READ action method / operation.
20:47 | Adding UPDATE action method / operation.
23:38 | Adding DELETE action method / operation.
25:25 | Using DB Browser for SQLite to access the SQLite db.
Download source code | https://github.com/CodeAcademyCA/.NET...
Related Videos
• .NET 7 SQLite Database CRUD Operations in ... | SQLite Database CRUD Operations in Web API using Entity Framework Core.
• Video | SQL Server CRUD Operations in Web API using Entity Framework Core.
• .NET 7 EFCore All Relationships (One-to-On... | EFCore Relationships (One-to-One, One-to-Many, Many-to-Many) in Web API with SQL Server.
• Video | AutoMapper Data Transfer Objects DTOs explained
• Video | Navigation Component in Blazor Web Assembly using NavigationLock
• Video | Object Relational Mapper ORM Explained for Everyone
• .NET EFCore | Scaffold SQL Database with D... | Scaffold SQL Database with DB First migration in Web API using EntityFrameworkCore.
• .NET EFCore | Web API Entity Framework Cor... | Web API EntityFrameworkCore (EF7) Pagination using Skip() and Take() methods.
• .NET EFCore | Send Email in Web API using ... | Send Email in Web API using Mailkit SMTP.
• .NET EFCore | AutoMapper Data Transfer Obj... | AutoMapper Data Transfer Objects DTO with Web API Explained.
• Video | Blazor WebAssembly Chat with SignalR using WebSockets.
• .NET EFCore | Create JSON Web Token (JWT) ... | Create JSON Web Token (JWT) for User Registration and Login using Password Hash and Salt.
• .NET EFCore | EFCore All Relationships (11... | EFCore All Relationships (11, 1n, nn ) with Entity Framework Core SQL Server.
• .NET EFCore | Read JWT Authorization Claim... | Web API Role - Based Authorization with JSON Web Token (JWT).
What is SQLite?
SQLite is a database engine written in the C programming language. It is not a standalone app; rather, it is a library that software developers embed in their apps. As such, it belongs to the family of embedded databases.
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 is CRUD in API?
CRUD stands for Create, Read, Update, and Delete, which make up these four fundamental operations. Because REST API calls invoke CRUD operations, understanding their relationship with one another is important for API developers and data engineers.
Nesta página do site você pode assistir ao vídeo on-line .NET 7 SQLite Database CRUD Operations in Web API using Entity Framework Core duração hora minuto segundo em boa qualidade , que foi baixado pelo usuário Dot Blazor 18 Fevereiro 2023, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 3,827 vezes e gostou 58 espectadores. Boa visualização!
