Difference between varchar and varchar(max) in SQL Server Hello Readers, The purpose of this post is to make it clear what to use and when with respect to varchar data type in SQL Server. Varchar(max) was introduced in SQL Server 2005 version. A few years back, I wasn’t clear about the Difference between varchar and varchar max. […]

Getting started with ASP.NET Web API
ASP.NET Web API is a framework that makes it easy to build HTTP services that reach a broad range of clients, including browsers and mobile devices. ASP.NET Web API is an ideal platform for building RESTful applications on the .NET Framework. In this post, we would have an introduction to one of the most popular […]

What are Visual Studio 2017 new features?
Visual Studio 2017 RC is already out. As with every new release, Microsoft has completely filled in a host of new features, which they hope will make the lives of us developers better and boost our productivity more than what it is now. Here, I am trying to give you all an overview regarding the features […]

What is Connection Pooling in ASP.NET?
In previous articles, we have learned to encrypt and decrypt the connection string in web.config file. In this article, we will learn what is connection pooling? Why connection pooling useful? and what is the maximum limit & minimum limit of connection pooling? Connection Pooling in ASP.NET When we use ADO.NET in a c# application, the first […]

Exception Handling in WCF | FaultException
Exception Handling in WCF When an exception occurs in a WCF service, the service serializes the exception into a SOAP fault and then sends the SOAP fault to the client. By default, unhandled exception details are not included int SOAP faults that are propagated to the client applications doe security reasons. Instead, a generic SOAP fault […]