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:

Usually, you can create a class model with the same name as […]


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 […]


Learn MVC Using Angular UI Select

Introduction This article demonstrates how to create MVC applications using Angular UI-Select with Bootstrap. This article is useful for implementing auto-complete text in your application. Angular UI Select Angular UI-Select is used for customizing the select box or text, with the support for searching the user’s character or words in the bundle of data. Features […]


Learn AWS With MS-SQL(DB) Using SQL Client

Introduction In this article, we will learn about Amazon web service with MS-SQL database using local ms-sql management studio. Requirements Register AWS console SQL Server Management Server Let’s start Create SQL Database in AWS You want to login to the AWS console here. If you have no login register new users here. After registering amazon will provide […]


DZone – Most Valuable Blogger

This is my first Achievements, I have selected top contributor. And top pageviews for june 2017 in DZone  So finally today (21-July-2017), I have recognized as Most Valuable Blogger from DZone. This is my happiest moment & proud to say ” I am the DZone MVB“. This is my precious achievement. Thank You DZone…. My Swag Pack..

Show Buttons
Hide Buttons