Archives for 2017 - Page 2
Working with Default Parameters in SQL Server Functions
As in any programming language, we can even set the default parameters for the Functions and Procedures on SQL Server. But calling these functions or procedures will differ with how we…
Calling REST API Service From SQL Server Using C# SQL CLR
Problem Statement A requirement where we need to get a data from other sources (REST-based Web Service) and sync with on-premises (local) database. This should be done using a SQL…
When does Application_Start() and Application_End() Used?
These two methods will declare in file as shown below public class WebApiApplication : { protected void Application_Start() { //Any Initializations of resources before calling any functionality } protected void…
Unable to launch the IIS Express Web server [Solved]
Recently, I got some source code for one of the projects and when I try to open this application using Visual Studio 2015 and run the application. I got the…
log4net.Config.XmlConfigurator.Configure() taking too much time
Hi All, Recently, I came across a strange issue with my log4net configuration. When I run my application it's taking almost 15 to 30 seconds at following statement and it…
Working with New Out Variables & Discard Feature in C# 7.0
Out parameters are the most common feature we use in our regular development in C#. Out parameters are the parameters which will be sent by the calling method and expects…
How to Improve Application’s Execution Performance
For every application could be small or medium or a big enterprises application the major non-functional requirement will be a good code performance. In some cases, companies will hire a…
Different ways to rendering a Partial View in ASP.NET MVC
A partial view is like as user control in Web forms that is used for code re-usability. Partial views helps us to reduce code duplication. Below are four methods for rendering a…
Part 3: Understanding with different ways of Injecting Dependencies
I will cover most of the topics about Dependency Injection in this Series. This series contains four parts as follows Part 1: Understanding why we need to use Dependency Injection?…
Part 2: Understanding how to implement Dependency Injection using Unity
I will cover most of the topics about Dependency Injection in this Series. This series contains four parts as follows Part 1: Understanding why we need to use Dependency Injection?…