Asp.Net Core Web API CRUD operations using SQL Server | Rest API

Asp.Net Core Web API CRUD operations using SQL Server | Rest API

📱 WhatsApp - [phone]
🌐 Instagram - @openprogrammer

In this tutorial, we will learn how to make a REST API using ASP.NET Core and SQL Server. We will write CRUD operations (Create, Read, Update, and Delete). We will use GET, POST, DELETE, and PATCH HTTP Operations in a RESTful .NET Core 3.1 Web API. We will also integrate our application with Entity Framework Core and store our data in SQL Server database.
GET, POST, PUT, DELETE and Upload File APIs method in ASP .NET Core Web API. In this video, we will learn how to create an ASP.NET CORE WEB API CRUD using .NET CORE 6 and also Create A CRUD Website using
and connect postman to .NET Core Web API. This will be a detailed tutorial in which we will first create an ASP.NET CORE WEB API using .NET version 6.
We will then create a new controller and create CRUD operations (HTTP GET, POST, DELETE, PUT) to Read, write and fetch data from our SQL server database using postman. Proper example of creating ASP.Net Core Web API and Calling it from POSTMAN for beginner.

Asp.Net Core Web API CRUD operations in REST API Tutorial using Entity Framework Core
ASP.NET CORE WEB API CRUD With Angular 13 - .NET 6 WEB API With Angular 13 CRUD Website
ASP.NET Core Web API CRUD With Entity Framework - Full Course
ASP .NET Core Web API + Microsoft SQL CRUD APIs
Fully basic CRUD Operation using ASP.NET Core Web API Example

Tools Used: Visual Studio 2019, Microsoft SQL Server and Postman

Points discussed :

- How to setup new ASP.NET core Web API project 00:00:21
- Announcement 00:01:09
- Create a new table to maintain the data 00:02:47
- Create Model classes 00:05:02
- How to add new ASP.Net Core Web API controller 00:06:32
- How to Create Get All API to get all records 00:08:36
- How to add Response Model class 00:09:11
- How to Create Get By ID API to get a particular record 00:19:01
- How to Create Post API to add a new record 00:22:05
- How to Create Put API to modify an existing record 00:27:02
- How to create Delete API to delete an existing record 00:29:13
- How to setup Post,Get,Put,Delete call in Postman 00:33:00

☕ Buy me a Coffee (Channel Support through Donation)

📻 Recommended Courses

Subscribe to this channel

Must buy Programming Laptops :

Share, Support, Subscribe Now :

⭐️Tags : ⭐️

#crud
#crudoperation
#crudoperations
#dotnetcorecrud
#dotnetcorewithsqlserver
#postman

⭐️ Your Queries : ⭐️

ASP.NET core web api
rest api .net core
rest api Asp.Net Core
rest api demo
rest api crud operations
Entity framework core crud
entity framework
Rest api C#
Rest api tutorial
asp net core web api
aspnet core web api
dotnet core web api
dotnet core web api tutorial
entity framework
entity framework c#
rest api c#
Asp.Net Core Web API CRUD Operations
How to build Web API with Asp.Net Core
Asp.Net Core Web API CRUD using Angular 11
Angular 11 CRUD with Asp.Net Core 5
Asp.Net Core Web API CRUD with Entity Framework Core and SQL Server
.Net Core 5 EF Core CRUD using Code First
Asp.Net Core Web API tutorial with Angular
Angular 11 with .Net Core Web API
Enable CORS in Asp.Net Core Web App
Insert Update and Delete in .Net Core Web API
Asp.Net CRUD with latest Angular

[ADARSHKH-queq]

I've gone through 30+ videos to create An WebAPI ..but all of them wasn't Really functionall at all...finally i saw your Video and Creating Many WebAPI using the Same technique..thank You Sir..Grate Work :)

[_blueline]

Sahi ho yaar Manoj Bhai. Lot of Thanks. Tumhare bajah se hi connection strings vagera setup kar paaya. Basically main Application Developer Hoon, tumhara yeh sab tutorials se madad ho raha hain API creation mein.

[asrarkhanpathan]

Nice Manoj.. I understood this Web API concept with this example and we can learn from there...

[suhaskamble]

Your confidence level just reflects in ur teaching skills.
Amazing brother.👍👍
Thank you for videos.

[rishikumar]

15:29 for my given project I need to do get function alone from the SQL server and i have three rows column which cheq_no and the data type is varchar...cheq_date and it's datatyoe is date and the cheq_recv_amt data type is money how to modify the content for my query

[mdrahman-juqv]

Good Job Manoj for your excellent work.

[CS_HimanshuVishwakarma]

Kya isko qur short karna tha na store procedure bana ke

[devisetti]

Hi sir,
Can you please us how to implement cascading drop-down for country state city in asp.nt mvc

[vinitaadawade]

Awesome tutorial. Can you please create video on database first approach ??

[IKhanImran]

Brother you not mentioned connection string in appsetting.json file pls add this part otherwise explain here

[toxicgamer]

Nice tutorial, Can you create a video on Token Based Authentication

[brayanyesidcanonrodriguez]

hello brother your videos are very good, I would appreciate if you can add the repositories

[shahlaps]

Good. I cant see data connection here. Where we write this

[AbdulRahman-tzdw]

solution for Connection string.
"ConnectionStrings": {
"ImportConnection": "Data Source=SQLSERVER;Initial Catalog={master};User
}