Object Oriented Buzz Words ...

A small list to recap. Object Orientation concept chart for interview...

Quality of Software !!!

Most debatable issue in software development industry is Quality. But the thing which is very clear is: every stakeholder has their own factors. This post tries to make a summary of how that can be understood at each level by each stakeholder.  Understand your role

Managing SQL Server “out” Parameter in 3 layer architecture using ASP.NET and C#

Few days back I got a question and started binging. I didn’t find any, finally started writing this tutorial.

What is the query? To understand the query, you need to consider a scenario. Let me describe that first.

 It is a very common requirement to use “out” parameter in SQL Server. The characteristic of this parameter is to return values to calling functions or more specifically, to front end.

Where to use? Consider a scenario, where your table has got an Auto generated ID field; And you want the generated ID to be returned back in user interface.  Also consider that your organization strictly follows 3 layer architecture.