Difference between WCF and Web service

use cmsdev

select Id ,FName from tinfo order by FName desc,Id desc

select * from tinfo where FName=(Select * from tinfo where FName='sumit' )

select  Sum(Id) ,count(Id) as SumId from tinfo group by Fname

Select FName,Sum(Id)  from tinfo group by FName having sum(Id)<35
select top 3 Fname from tinfo

select * from tinfo where Id=(select max(Id) from tinfo) <(select max(Id)from tinfo))


select max(ID) from tinfo where id not in (select top 2 (id) from tinfo order by Id desc)

select max(ID) from tinfo where id not in (select top 1 (Id) from tinfo order by Id desc)

select * from tinfo where id=(select Max(id) from tinfo)

select distinct(CellNo) from tinfo order by CellNo asc


select * from tinfo t1 where (2)=(select count (distinct(id)) from tinfo t2 where t1.Id>t2.Id )

Difference between WCF and Web service

Web service is a part of WCF. WCF offers much more flexibility and portability to develop a service when comparing to web service. Still we are having more advantages over Web service, following table provides detailed difference between them.

Features	Web Service	WCF
Hosting	It can be hosted in IIS	It can be hosted in IIS, windows activation service, Self-hosting, Windows service
Programming	[WebService] attribute has to be added to the class	[ServiceContraact] attribute has to be added to the class
Model	[WebMethod] attribute represents the method exposed to client	[OperationContract] attribute represents the method exposed to client
Operation	One-way, Request- Response are the different operations supported in web service	One-Way, Request-Response, Duplex are different type of operations supported in WCF
XML	System.Xml.serialization name space is used for serialization	System.Runtime.Serialization namespace is used for serialization
Encoding	XML 1.0, MTOM(Message Transmission Optimization Mechanism), DIME, Custom	XML 1.0, MTOM, Binary, Custom
Transports	Can be accessed through HTTP, TCP, Custom	Can be accessed through HTTP, TCP, Named pipes, MSMQ,P2P, Custom
Protocols	Security	Security, Reliable messaging, Transactions