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

C#

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

Angular ASP.NET MVC C# Crystal Report MS-SQL Product Visual Studio

Learn MVC Using AngularJS And Crystal Report

Introduction In this article, we will learn MVC, using AngularJS and Crystal Report to help us handle server side data, using Visual Studio 2015. What Is Crystal Report? Crystal Report is a business intelligence application. Crystal Report is powered by SAP. It is used to design and generate reports from a wide range of data sources. […]

C# MS-SQL SQL

Convert Table Column Into C# Model Class

In this blog, I will demonstrate how to convert a table column into a C# model class, using stored procedure. This is a very useful phenomenon for most of the C# programmers. SQL Code Create table and column as you need, like given below. CREATE TABLE [dbo].[EmployeeMaster](     [RowId] [bigint] NULL,     [EmpFirstName] [varchar](50) NULL,     [EmpLastName] [varchar](50) NULL,     [PhoneNo] [bigint] NULL,     [City] [bigint] NULL,     [Address] [varchar](500) NULL,     [DateOfBirth] [datetime] NULL,     [Gender] [int] NULL,     [MaritalStatus] [bit] NULL,     [EmpStatus] [bit] NULL […]