DotNetCrunch

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. It was always confusing for me which one to use.

[bctt…

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 frameworks developed for RESTful services. We would be looking at WEB API, What is…

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 of Visual Studio 2017.

Boosted productivity

Enhancements to code navigation, IntelliSense,…

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 thing we do is create a connection object and open the…

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 is returned to the client.

For debugging purpose, if you…

What is the purpose of ?? operator in C#?

The ?? operator is called the null-coalescing operator. It returns the left-hand operand if the operand is not null; otherwise, it returns the right-hand operand.

You might already know that C# 2.0 provides us Nullable Types which can be used to store null values for value type variables such as int, float, decimal etc.

For example, let’s consider the following code snippet.

[csharp] int? x = null;

Difference between Convert.ToString() and ToString()

In this post, we will explain the difference between .ToString() and Convert.ToString() methods in C#.

The basic difference between them is “Convert.ToString()” handles NULL values while “.ToString()” doesn’t. Which means if the variable being passed to Convert.ToString() is NULL, it won’t throw an exception.

Whereas, “.ToString()” does not handle NULL values and it will throw a NULL reference…

Encrypt and Decrypt Connection String in Web.config

Encrypt and Decrypt Connection String in Web.config

With the help of this article, we are trying to explain encryption and decryption process of a connectionStrings section of Web.config file using the aspnet_regiis.exe tool.

This post provides a basic reference on how basic protection can be achieved using the aspnet_regiis.exe tool, by default installed with .Net Framework.

It is always…

Interface Method Implementation C# 8.0

In our previous post, we have tried to provide an overview of first four features of C# 8.0 which has been announced by Microsoft recently.

In this post, we will explain one of those four features in detail which is Default Interface.

This feature will allow interfaces to fully define methods just like abstract classes. However, interfaces will still not be able to declare constructors or fields.

Expected New Features In C# 8.0

Recently in channel 9, Mads Torgersen demonstrated the first four features of C# 8. Below is the brief description of those new features in C# 8.0. This is going to be the next major release after C# 7.0

Expected New Features In C# 8.0

C# 8.0 Previewed: below are the 4 features which Mads discussed in his recent talk on channel 9.

1. Nullable Reference Types

With C# 8.0, references type would not…

Generic collections in c# with example

In this post, we will be discussing various types of generic collections in C# with the help of examples.

Generic collections in c#

A collection is a similar type of objects grouped together. Every collection class implements the IEnumerable interface, so values from the collection can be accessed using a foreach loop.

[bctt tweet=”Generic Collections in C# #dotnet #csharp #collections”…

How To Get Update Of Dynamic 365 CRM?

With the upcoming trends in technology, new features are becoming available continuously. If you install, configure as well as administer Microsoft Dynamics 365 services and products, then you must be looking for the latest updates and news online. Dynamic 365 allow its previous version functionality to be included as an essential part of a suite of the smart business app. The common applications…

Microsoft Dynamics AX – The New Age Business Enhancement Software

Microsoft Dynamics AX

Formally known as Axapta, is an adaptive, indicative business management solution that streamlines customer relationship, supply chain processes, and venture financials. Originally developed by IBM in conjunction with Danish based software developer Damgaard Data, Microsoft Dynamics AXtoday, is a classic solution to enterprise resource planning for medium and large…

Microsoft Social Engagement 2017 Update 1.4 – A New Set of interesting Rollouts!

Microsoft Social Engagement 2017

Over the years, it has become a ritual for us, techies to eagerly wait for an update from Microsoft and unveil what new the technology giant has brought to plate this time. In the years of 2016 alone, Microsoft had rolled out approximately twelve major updates to its Social Engagement Platform, presenting new enhanced features, better functionality and touching…

Using Triggers In SQL

Often times you want some event to be triggered automatically when a certain action is performed on a SQL database.

For instance, you might want to create logs for every INSERT operation performed on a database table or you might want to add a tax percentage to an amount entered by a user before storing it in the database.

In such scenarios you have two options:

1) You can first insert data…

Upgrading or Re-Implementation of Dynamics 365 for Operations

Do you know about the Microsoft Dynamics 365 for operations? It is an ERP business application re-branded by Microsoft officials. It is a next-gen, cloud-based business management system that combines CRM and ERP capabilities within one integrated platform.

While many Microsoft Dynamics AX technical users and developers are trying their hands on the latest update of Dynamics 365for operations,…

Angular 2 – Architecture – Part One

In this article, we shall see the building blocks in an Angular Application

Module

Angular Application is modular in nature. Therefore, an Application is just a collection of the individual modules.

Modules are just blocks of code, which are created for a specific purpose.

Because of this, each module exports something like a value or a function or a class, which the other module can import and…