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

MS-SQL

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