Search for a command to run...
Articles tagged with #sql-server
Introduction Dapper is a lightweight and efficient Object-Relational Mapping (ORM) library for C#. Unlike other ORMs that can be complex and require significant configuration, Dapper is designed to be simple and straightforward. It provides a conveni...
ADO.NET (Active Data Objects for .NET) is a powerful data access technology that provides a set of classes for connecting to databases, executing SQL queries, and manipulating data. This guide will walk you through the essentials of ADO.NET with mult...
Below are the basic concepts in SQL Server: 1. Stored Procedure A stored procedure is a group of SQL statements that can be executed together as a single unit. CREATE PROCEDURE GetEmployeeByID @EmployeeID INT AS BEGIN SELECT FirstName, LastNa...
Hi there! Let us see how to create a Web API in .NET 6.0 with JWT Authentication and ASP.NET Core Identity. Implementing authentication in any app is rarely an easy task, but don't worry , we will get there, slow and steady :) If you are in a bit of ...
