Last post Apr 28, 2016 03:47 PM by mgebhard
Apr 28, 2016 10:21 AM|irfanraza|LINK
I came across a weird situation in WCF Service. I don't know what exactly the reason behind this.
The screen shots are self explanatory.
Below screen shots shows - 1. Project structure, 2. DB Structure, 3. Table relations etc.
Now closely observe the result i got -
This is weird. I don't understand why WCF generating error here.
Later on I have done some R&D and removed the relation between tables.
Now see the result -
Surprisingly, the WCF is functioning. This is really weird. Can anybody explain me why this behavior, and what changes should i make to make my service working with relational tables.
Thank you for sharing your time and wisdom.
Same question is posted on StackOverflow http://stackoverflow.com/questions/36867458/failed-to-invoke-the-service-possible-causes-the-service-is-offline-or-inacces
Apr 28, 2016 10:32 AM|mgebhard|LINK
Edit: do not return entity directly in web services. The serialization process causes the entity properties to invoke the relationships and essentially try to download the large chunks of data. Use projections to capture the required data and pass to the
Apr 28, 2016 03:01 PM|irfanraza|LINK
Thanks for your quick reply.
I did tried to implement in that way but still getting the same error.
You can download source code from here http://qa-link1.softwaregenius.net/snaps/samplecode.zip
Apr 28, 2016 03:47 PM|mgebhard|LINK
So, Currency is not an entity?