I need a C# WCF web service that connects to a SQL Server database, retrieves all rows from a single table or view based on a list of fields passed in as parameters and returns the output as JSON. This should be a generic SOAP service that can be called by any application that can read the WSDL.
An example web service call to the database would be RetrieveData(TABLE_OR_VIEW_NAME, FIELD_NAMES[]) where TABLE_OR_VIEW_NAME represents a single table or view in the database and FIELD_NAMES[] is an array of string that contains all the fields to be included in the query. There should also be an option to include all the fields without specifying every one of them.
So for the standard microsoft Northwind DB RetrieveData("Products",["ProductID","SupplierID","UnitPrice","Discountinued"]) or RetrieveData("Orders",["ALL"]) (where all represents all the fields).
The returned output needs to be JSON.
Minimum requirements are Visual Studio 2012 or 2013 with C# - Framework 4.0 or higher
Hello,
I am very much interested to do this project as i am experienced a lot in C# as well as ms sql server. I am experienced in developing WCF web service. So i think i am the right person for this task. Looking forward to have a positive response from you.
Thanks
$190 USD in 4 days
5.0 (16 reviews)
4.4
4.4
5 freelancers are bidding on average $190 USD for this job
Greetings,
I have completed many projects that have implemented WCF Web services that connect to SQL Server and return JSON data.
I'd encourage you to engage in a discussion to refine your requirements and get started!
Regards,
John.
My understanding : You will pass 4 parameters list. (a) table Name or View Name. (b) Column Name(s). WCF response result will give u JSON data. Can you please confirm my understanding ? Sample database will be given to me ?
Hello,
I have read through your project and I am incredibly interested in taking on your project. I am an experienced developer with a diploma in the field of web development. I have been working in the field of web development for roughly 7 years. I take great pride in my work and deliver only the best quality.
My skill-set includes...
-Photoshop
-PHP
-Illustrator
-HTML5
-CSS
-Responsive Design
-Wordpress
-Joomla
I look forward to hearing from you and hopefully we will have the opportunity to work together.
Thank you,
Meagan S.