Generic Method to Create and Execute Parameterized SQL Query in .NET 4.0

Now days, developers think and talk in terms of best practice and performance. When it comes to a debate of inline v/s parametrized SQL queries, Parametrized queries were preferred over inline queries, in terms of performance as they do avoid parsing, compile etc., by caching query plans each time the query is executed. It also

What is REST (Representational State Transfer)

REST (Representational State Transfer) defines a set of architectural principles by which you can design Web services that focus on a system’s resources. REST, which was first introduced by Roy Fielding (Univ. of California, Irvine) in the year 2000, is a simpler alternative to SOAP/WSDL based web services. A web service is said to be ‘RESTful’ when it is implemented using the principles of REST. Over the past couple of years web technology giants have started adopting REST and RESTful services heavily underscoring their significance.

Best Practices: Database Operations

Few things that you could consider as part of better coding practice and for better application performance.

How to use Namespace Alias Qualifier – (global)

As you know a code file can declare multiple namespaces – stand-alone ones or nested ones. The types under the namespaces with the same name are treated as one single logical group. Types that are not declared in any namespace are considered to be in the “global” namespace, which is the outer-most, default one.

How to get details of a file extension including icon

How to retrieve the descriptive name of a file extension and icon. If you have some sort of file ‘browse’ Window that you want to show the file name, and the ‘File Type’ field where it says something like ‘File Folder’, ‘WinZip File’ or ‘FLG File’ – here is some simple code that does that for you.

How to create a reusable method to check null or an empty string

We always need some utility methods handy to speed up our development activity. The method in this article shows how to check if a string is null or empty.

Windows Presentation Foundation (WPF) Part 1

This article explains the need for a new platform to exploit the graphics power of today’s computer systems. This provides background information on the evolution of WPF and covers why user experience is an important consideration in application design. WPF is an integrated client platform and next generation of development tools for building Windows client applications.

About .NET Framework Versions

There has been a lot of confusion around .NET Framework version numbers and it’s implications to applications as well as the development environment. This article will attempt to explain and clear any outstanding confusions.

How to write a simple SQL Server Data Access Layer – Part-2

This article gives walk through on how to use my Data Access Layer with your application for with insert stored procedures accepting multiple parameters.

How to write a simple SQL Server Data Access Layer – Part-1

his article gives walk through on how to create a simple Data Access Layer and how to use it in your application.