Exposing a SQL DB through a WCF Service using Entity Framework
Its been a long time since I have written a blog. I had to implement a SQL database for an application and we needed to have exposed as a WCF endpoint. While there are several tutorial on how to do this, i thought it will be a good idea to show the simple and the quick way that we followed Things needed SQL Server Microsoft Visual Studio 2012 This are two parts, creating the service and then the Client DLL. Part 1 : Creating the WCF Service Step 1: Create the Database Create a SQL database, its tables, its relationships as you normally would.If there are any tables with binary columns, then please be informed that it should be excluded from the WCF service. Step 2: Creating the EDMX file Create a new ASP.NET Empty Web Application in a new solution, call it what you like, I am it the TestDataModel Once this is done, its time to add the EDMX file. In order to do so Right click and add new item. Choose ADO.NET Entity Data model and give it the name TestDataModel.edmx Sel...