1) Simple Query
var CustQuery= from cust in customers
select cust;
2) Where Clause

var DelhiCustomerQuery = from cust in customers
where cust.City == “Delhi”
select cust;
Logical Operator
where cust.City==”delhi” && cust.Name == “mumbai”
3) Order by
var DelhiCustomerQuery = from cust in customers where cust.City == “Delhi” orderby cust.Name ascending
select cust;
4) Group by
var QueryGroupByCity = from cust in customers group cust by cust.City
Now [...]

In .net 4.0 dynamic keyword has been introduced. This allows you to define the object without specifying its type. So let say we have following string :-

string s = “sachin”;

We can define another variable without specifying the type

dynamic d = s;

Now this can also be done through var keyword so whats the difference?
The difference is [...]

Custom application error tracking through global.asax file. Here you can track querystrings, post data and whole exception message with url

Following is the diagram for WCF architecture

1. Contracts – It contains information about what service does and type  of information it will make available.
a) Data – A data contract includes the data that will be exchanged by the service. The service and the client do not need to agree on the types, but they [...]

1) Permanent redirect – for HTTP 301 Moved Permanently you can now use RedirectPermanent(“yourpage.aspx”);

2) Meta Properties- Now you can use page.MetaKeywords and page.metaDescription for setting up meta tags.

For creating web service in SQL server you need to understand http end points. So what is http end points ? It provide an interface using TCP or http for SOAP.

WCF is based on SOA architecture. Its main objective is to achieve features of SOA and coming as close as possible to it. It is basically a framework for creating and distributing the connected applications. WCF provides the set if classes which provides developer a facility to create a SOA applications.