This article will guide you through, to create a WCF service, host it in your local IIS and consume the service using a client console application. The data are going to be retrieved from an SQL Server 2012 using the Entity Framework. The database used in this tutorial is the AdventureWorks, a sample database which Microsoft provides for free. You can download it but have in mind that you need to convert it to a database compatible to the SQL Server 2012. If you have earlier versions like SQL Server 2008 R2 I am pretty sure you won't have any problem. Before starting, I assume you have already installed the above database in your SQL Server. So let's start:


I guess you came to this post by searching similar kind of issues in any of the search engine and hope that this resolved your problem. If you find this tips useful, just drop a line below and share the link to others and who knows they might find it useful too.

Stay tuned to my blog, twitter or facebook to read more articles, tutorials, news, tips & tricks on various technology fields. Also Subscribe to our Newsletter with your Email ID to keep you updated on latest posts. We will send newsletter to your registered email address. We will not share your email address to anybody as we respect privacy.

This article is related to

</ span>C#,.NET,Architect,Intermediate,VS2010,.Net,Articles,Computer Tutorials, WCF,WCF Service Using the Entity Framework