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

SQL To JDEdwards Date Conversion

Once Linked JDEdwards database in our MS-SQL database under the Linked server and when we going to see the data it should be encrypted. Here I am show to how to see data like as MS-SQL. Actual JDEdwards data My linked server name is “TESTDTA” (JDEdwards database). Open new query window type the below query […]

MS-SQL Convert String To Table List

In this blog, I will demonstrate how to convert string into table list the dynamically using MS-SQL user define function. Create a function:    When we start programming in any language, mostly we use loop & every time to hit server side code for list data. This function helpful to reduce our server side code […]

About

Hi Everyone, My name is Thiruppathi Rengasamy. I ‘m a .Net Developer, Author & Blogger. And also I’m working as senior software engineer in Microsoft Technologies for  5 Years. I would like to spend my precious time in writing articles, research in .Net technologies and to learn new technologies. I have been awarded as C# Corner […]

Learn MVC Using Angular Dynamic Control In DataTables

Introduction In this article, we will learn MVC using Angular data binding for dynamic control in DataTables from a server side Web API using Visual Studio 2017. In this article, we are going to: Create a Database. Create a Store procedure. Create an MVC Application. Use Angular DataTables Dynamic Control. Create Database Open SQL Server […]

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

Convert Table Data To List Using Reflection

In this blog, learn how to convert table data into list data using Reflection and LINQ. You can use the data passing from the server side to the client side. Reflection You can use Reflection to dynamically create an instance of a type, bind the type to an existing object, or get the type from […]

Learn MVC Using Angular Wizard

Introduction In this article, we will learn MVC using Angular Wizard and Datatable from the server side, and work with the stored procedure using Visual Studio 2015. Why Use Wizard? Wizard means the process is moved step-by-step. It allows you to logically divide the groups of data. That way, the user can enter valuable data. […]