C# MS-SQL

How to Convert a Table Column Into a C# Model Class

In this blog, I will demonstrate how to convert a table column into a C# model class using stored procedures. This is a very useful tip for any C# programmer. SQL Code Create tables and columns as you need, like given below: CREATE TABLE [dbo].[EmployeeMaster]( [RowId] [bigint] NULL, [EmpFirstName] [varchar](50) NULL, [EmpLastName] [varchar](50) NULL, [PhoneNo] […]

Angular ASP.NET MVC Web API

How to Use the SQL Helper Class to Create Web APIs

The SQL Helper class is used in the Data Access Layer, which interacts with a database with the help of connection strings provided. It contains several methods, as shown below. And it improves the performance for the Business Layer and Data Access Layer.  ExecuteNonQuery   ExecuteDataset  ExecuteDataTable   ExecuteReader   ExcuteScalar  ASP.NET Web API The ASP.NET Web API […]