CRUD Operations using ASP NET Web API and SQL Server | Database Connection Using ODBC

Devart ODBC Drivers : www.devart.com/odbc/
Devart ODBC Driver for SQL Server : www.devart.com/odbc/sqlserver/
Devart ODBC Driver for PostgreSQL : www.devart.com/odbc/postgresql/
##############
Perform CRUD Operations using ASP.NET Web API, SQLClient package and SQL Server Database. Connect ASP.NET to SQL Server and PostgreSQL using ODBC drivers. Connect ASP.NET to Database Systems using Devart ODBC drivers.
##############
Source Code on Patreon : / crud-operations-84466398
ASP.NET Web API Course on Udemy : www.udemy.com/course/build-as...
ASP.NET Web App Course on Udemy : www.udemy.com/course/aspnet-c...
##############
Topic
(00:00) Introduction
(01:15) PART 1- CRUD using SQL Server and SQLClient
(01:18) Create new Project and Database Table
(04:55) Create new API Controller
(07:00) Create Models
(08:48) Create Products
(13:07) Read Products
(17:04) Read Product by ID
(20:33) Update Products
(23:30) Delete Products
(26:12) PART 2- CRUD using ODBC
(26:15) Devart ODBC Drivers
(27:59) CRUD using ODBC
(30:58) Get Connection String - ODBC Driver for SQL Server
(35:36) Get Connection String - ODBC Driver for PostgreSQL .
***********************************
🔥 Complete Udemy Courses :
Build E-commerce Web Application using ASP.NET Core : www.udemy.com/course/aspnet-c...
Build E-commerce Web API using ASP.NET Core : www.udemy.com/course/build-as...
Build E-commerce Web Application using React JS : www.udemy.com/course/build-co...
⬇️ Free Document Proofreading ⬇️
► Grammarly : grammarly.go2cloud.org/SH3YB

[@pedrovinicius6808]

I can just using these queries and any methods in service layer, using one interface as well, that’s not a problem. That’s a good video, congrats!

[@visithanr9271]

It worked perfectly. Thanks💗

[@laxan9671]

cacca wela hitiye ned

[@chamodmullegama3619]

Nice

[@ahmedmetwaly8550]

مبدع 🌺🌺🌺 شكرا جزيلا

[@chamodmullegama3619]

Ado thanks bm ummmmma . It 's works thank you bro ❤

[@visithanr9271]

Gmmc Cuddah....❤

[@laxan9671]

menn video

[@chamodmullegama3619]

Mu nm mge ekek bm

[@webstaregyptsoftware5090]

Thank you for the clear explanation. I have some questions here please.
1. How can we upload this API to an existing project written in ASP.Net not ASP.Net Core, and in VB.Net not C# ?
2. How can we pass required parameters from my web page with data entry form to the API for CRUD operations instead of passing them manually from the browser as you explained in this video?

[@backedarea]

❤❤ Hero

[@laxan9671]

gg

[@ariesandhi]

in MVC Framework the controller should not perform any direct query to the Database

[@brawlboy1382]

I am new to this and am curious - why do some people use the "async Task" keyword to declare endpoints and some use the way you do it?

[@wesleykamau8144]

I am not able to connect to the database, such that what I post does not reflect onto the database while the program is running ... what should i do?

[@thecreater3060]

Check the query that you have given

[@peroperic6691]

What is different between this and your other similar video?

[@BoostMyTool]

this is SqlClient without Dapper, the other uses Dapper

[@RelaxingSounds-ec7un]

It didn't work ? It cant even enter to the Browser ? You didn't show the program.cs I don't know what should be there

[@elizabethlizzy_zw]

I'm getting a 400 error

[@paulmanoharsatyala9181]

did you solve the error. If so please let me know