Features of WCF

WCF includes the following set of features:

Service Orientation 

One consequence of using WS standards is that WCF enables you to create service oriented applications. Service-oriented architecture (SOA) is the reliance on Web services to send and receive data. The services have the general advantage of being loosely-coupled instead of hard-coded from one application to another. A loosely-coupled relationship implies that any client created on any platform can connect to any service as long as the essential contracts are met.

Windows Communication Foundation

Important Sql Queries

Introduction: In this article i am going to give some of very useful SQL Queries that are required to us in our day to day programming life.

1. Get current Database Name:  Select DB_NAME()

2. Get Details Of All Databases Present In SQL Server: Select * from sys.databases

3. Rename A Database: Exec sp_renamedb ‘oldDatabaseName’ , ‘newDatabaseName’

Dataset Vs DataReader

Introduction: Following are some of the differences between DataSet and DataReader objects in .NET.

Dataset	DataReader
It is used in disconnected architecture	It is connection oriented.
Works with multiple tables	Works with single tables
Forward and backward scanning of data.	Only forward scanning is possible
We can make several edits on the dataset.	It is read only record set.
Occupy more memory	Occupy less memory.
Relationship can be maintained	Relationship can’t be maintained.
Relatively slower data access	Faster than data set.
Works with multiple records at a time.	Works with only 1 record at a time.
Transactions can be handled	No transaction can be handled as its read only.
Can be bind to multiple controls	Can be bind to a single control only
More overhead in memory as it is heavyweight	Lightweight object hence very less overhead
Supported by VS.Net tools	Must be manually coded.

Filter GridView Using tablesorter_filter plugin in ASP.NET

Introduction: Hey guys in the previous article i have explained how we can sort gridview and paginate gridview in asp.net at client side without making any postback to server using very small jQuery plugins for table sorting paging, filter. In this article i am going to explain how we can implement the filtering of records based on any column or group of columns either in a table or girdView. You can download each of these plugins by clicking here.

• 
  

  For Sorting a table or gridView.

  
  


• For Paging  a table or gridView.


• For filtering a table or gridView.