Can have more than 100 Operation Contract in WCF Rest Service

Question

4.00/5 (1 vote)

See more:

I'm developing a WCF Rest service with Json and Xml response. I have more than 100 stored procedure in my database.

My aim to avoid multiple operation contarct and get all the data from database so I have declared object as return type as below.

C#

[OperationContract]
        [WebInvoke(Method = "GET", UriTemplate = "GetDetails?type={type}")]
        object GetInfo();

        [OperationContract]
        [WebInvoke(Method = "POST", UriTemplate = "PostDetails?type={type}")]
        object PostInfo(object Entities);

        [OperationContract]
        [WebInvoke(Method = "PUT", UriTemplate = "EditDetails?type={type}")]
        object EditInfo(object Entities);

        [OperationContract]
        [WebInvoke(Method = "DELETE", UriTemplate = "DeleteDetails?type={type}")]
        object DeleteInfo(object Entities);

But i'm facing serialization problem because WCF should return response based on DataContract so operation contract should have respective DataContract

C#

[OperationContract]
        [WebInvoke(Method = "GET", UriTemplate = "GetUserDetails?type={type}")]
        List<UserModel> GetInfo();

[OperationContract]
        [WebInvoke(Method = "GET", UriTemplate = "GetXenDetails?type={type}")]
        List<XenModel> GetInfo();

[OperationContract]
        [WebInvoke(Method = "POST", UriTemplate = "PostGroupDetails?type={type}")]
        List<GroupModel> PostInfo(GroupEntities Entities);

Please any one suggest me which is better option:
1. Should I create more opertion contract with respective DataContract
2. Explicitly convert DB data to Json or Xml and return as object or String
3. Shall i return as Stream

Posted 9-Jan-16 21:33pm

mn.sathish

Updated 12-Jan-16 3:49am

v7

Add a Solution

Comments

Kornfeld Eliyahu Peter 10-Jan-16 9:52am

WCF contracts are there to enforce typed conversation...
So if you are removing it - by returning JSON/XML string - why to use WCF at the first place?

mn.sathish 10-Jan-16 21:25pm

Thanks for your valuable suggestion. Shall We create 100 Operation Contracts in WCF? If so, Whether it is wrong approach or correct approach?

Kornfeld Eliyahu Peter 11-Jan-16 1:47am

There is no actual limit of how many contracts you may create...However it is hard to really advise you without knowing what do you want to achieve...

mn.sathish 11-Jan-16 2:19am

From MVC I am calling WCF Rest service to get DB data which contains more than 150 stored procedure. My aim to create common operation contract to call appropriate SP and bring back result set to MVC.
Tell me how to achieve

Kornfeld Eliyahu Peter 11-Jan-16 2:54am

I think that there should not be a problem to create a single contract for that...The question is what those SPs are returning? A table? A single value? If it is a table, should you separate different tables as different types, or every table is a table...
I would also ask myself, what I'm doing with the result from those SPs? Some processing? Going to display? Pass on?

mn.sathish 11-Jan-16 3:20am

SPs are for CRUD operation. Retrieve type SPs returning table format result set and most of the SP having single table result set. Each SPs having different types of column. Results are needs to be display in MVC

Kornfeld Eliyahu Peter 11-Jan-16 3:22am

In this case you should have no problem to build a single contract that can handle it...

mn.sathish 11-Jan-16 3:24am

Could you please guide me Operation Contract Return type, how to design them. How do I Should avoid to create multiple Operation Contract?

Kornfeld Eliyahu Peter 11-Jan-16 3:35am

You will have to create a class that can hold an array of tables (to support multi-result sets) and some supporting fields to describe those tables (like names/descriptions, count, biding instructions, metadata)...

mn.sathish 11-Jan-16 3:50am

Could you please post some example

Kornfeld Eliyahu Peter 11-Jan-16 3:56am

For that I should have some of your (those are represents the majority) SP's signature...But I would like you to come up with the first version and ask advice after the first effort...

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

johannesnestler · Answer 1 · 2016-01-14T04:56:00

What I did in a similar Situation was using a XMLDocument as return/Parameter type which I serialized and deserialized - was a stupid solution. Others mentioned it - when I do this why use WCF in the first place?
If you don't have an object-model (classes) corresponding to your datamodel (tables) why not generate one? - T4 or use an OR-Mapper (just for generating Model-classes), put some attributes on the properties to make it a datacontract and have separate implementations (Service-Methtods) for each tables CRUD-Operation (they will then execute the operations through your SPs, and on the implementation side (not the contract) you can come up with some generic methods and not duplicate the code accessing data xxx times).
Just my 2 c...

mn.sathish · Answer 2 · 2016-01-13T04:57:00

Solution 1

I switch over to ASP .Net Web API.
WCF does not support anonymous return type whereas WEB API support anonymous return type.

Posted 13-Jan-16 4:57am