Posts

Showing posts from April, 2015

Kaise Tumhare Dar Hum Aaye

We have been engrossed so much in the material world that without His grace there is no way of pulling ourselves up. A song dedicated to this feeling …. Kaise tumhare dar hum aaye Kis vidhi tere darshan paye Kai janmo se aas lagaye Aan milo hari daras dikahye Kaise tumhare dar hum aaye Kis vidhi tere darshan paye Prabhu Pankaj tum Keechad jaise milenge tumko bolo kaise Duniye aise prashn uthaye laj rakho prabhu ab ur aaye Kaise tumhare dar hum aaye Kis vidhi tere darshan paye janam janam se daag lagaye aham dambh hum tyaag na paye nirmal karo hume apnaye tere bina nahi koi sahaye Kaise tumhare dar hum aaye

Exposing a SQL DB through a WCF Service using Entity Framework

Image
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