Introduction to Service Oriented Architecture

A service-oriented architecture (SOA) is a flexible set of design principles used during the phases of systems development and integration. A deployed SOA-based architecture will provide a loosely-integrated suite of services that can be used within multiple business domains. To be more specific:, A service-oriented architecture is essentially a collection of services. These services communicate with each other. The communication… Continue reading

Extensions Methods in C#

Extensions Methods in C# ——————————- Extension method is new to C# 3.0 (.NET 3.5).Its allow you to add new method to the existing class. a. Extension method allows you to add new method to the existing class without modifying the code, recompiling or modifying the original code. b. Extension method are special kind of static… Continue reading

Stored Procedures and Return Statement

In a recent interview i was been asked whether stored procedures can have “return” keyword and what type of values it can return. I thought i will note this point here. Stored Procedures can return value. Only a single numeric value can be returned. Consider the following snippet. [code lang=”sql”] CREATE PROCEDURE dbo.GetCustomerMaxID () AS… Continue reading