*Devart ODBC Drivers* : https://www.devart.com/odbc/ *Devart ODBC Driver for SQL Server* : https://www.devart.com/odbc/sqlserver/ *Devart ODBC Driver for PostgreSQL* : https://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* : https://www.patreon.com/posts/crud-operations-84466398 *ASP.NET Web API Course on Udemy* : https://www.udemy.com/course/build-aspnet-web-api/?couponCode=201005559FCD3B485A0F *ASP.NET Web App Course on Udemy* : https://www.udemy.com/course/aspnet-core-web-application-using-razor-pages/?couponCode=1020144B06D6D641661C ############## 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* : *ASP.NET MVC Course* : https://www.udemy.com/course/aspnet-core-mvc-guide/?referralCode=746FF5A10C03CD19FF7B *ASP.NET Course* : https://www.udemy.com/course/aspnet-core-web-application-using-razor-pages/?referralCode=4D062636505BAC4BCB7E *ASP.NET Core Web API* : https://www.udemy.com/course/build-aspnet-web-api/?referralCode=A15F66DA56B122822E9F *React JS* : https://www.udemy.com/course/build-complete-react-application/?referralCode=095C4A5B99A8BB1B5DF7 ⬇️ *Free Document Proofreading* ⬇️ ► *Grammarly* : https://grammarly.go2cloud.org/SH3YB