# REST API Architecture (.net service wrapper) **URL:** \ **Category:** Code Examples\ **Created:** [September 23, 2015, 12:56pm UTC](https://community.dreamfactory.com/t/rest-api-architecture-net-service-wrapper/1516 "2015-09-23T12:56:40Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Abhishek\_Tiwari](https://avatars.discourse-cdn.com/v4/letter/a/7ea924/32.png) [@Abhishek\_Tiwari](https://community.dreamfactory.com/u/Abhishek_Tiwari)\ **Post date:** [September 23, 2015, 12:56pm UTC](https://community.dreamfactory.com/t/rest-api-architecture-net-service-wrapper/1516/1 "2015-09-23T12:56:40Z")
Client wants us to do the following points Basically the architecture is that: 1 DreamFactory as the data access layer to the database 2. We’ll have a .net service wrapper that handles authentication, token assignment and connects to dreamfactory for the stored procedure call. 3. The Dreamfactory service will sit behind the firewall and convert the results automatically to JSON. pls suggest what will we do from the scratch ? ---
**Author:** ![crystaltaggart57](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/crystaltaggart57/32/465_2.png) [@crystaltaggart57](https://community.dreamfactory.com/u/crystaltaggart57)\ **Post date:** [September 24, 2015, 9:21pm UTC](https://community.dreamfactory.com/t/rest-api-architecture-net-service-wrapper/1516/2 "2015-09-24T21:21:15Z")
Check here: [https://github.com/dreamfactorysoftware/.net-sdk](https://github.com/dreamfactorysoftware/.net-sdk) and here: [https://blog.dreamfactory.com/.net-sdk-for-dreamfactory-is-now-available](https://blog.dreamfactory.com/.net-sdk-for-dreamfactory-is-now-available) and here: [Make a Stored Procedure Call using .NET SDK](https://community.dreamfactory.com/t/make-a-stored-procedure-call-using-net-sdk/1473) ---
**Author:** ![Abhishek\_Tiwari](https://avatars.discourse-cdn.com/v4/letter/a/7ea924/32.png) [@Abhishek\_Tiwari](https://community.dreamfactory.com/u/Abhishek_Tiwari)\ **Post date:** [September 25, 2015, 4:13am UTC](https://community.dreamfactory.com/t/rest-api-architecture-net-service-wrapper/1516/3 "2015-09-25T04:13:56Z")
Thanks crystal for the references… ---
**Author:** ![Abhishek\_Tiwari](https://avatars.discourse-cdn.com/v4/letter/a/7ea924/32.png) [@Abhishek\_Tiwari](https://community.dreamfactory.com/u/Abhishek_Tiwari)\ **Post date:** [September 29, 2015, 6:41am UTC](https://community.dreamfactory.com/t/rest-api-architecture-net-service-wrapper/1516/4 "2015-09-29T06:41:00Z")
Getting the following error while calling stored procedure with one input and one output parameter:- { “error”: [ { “context”: null, “message”: “Failed to call database stored procedure.\nSQLSTATE[IMSSP]: The active result for the query contains no fields.”, “code”: 500 } ] } ---
**Author:** ![formerstaff](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/formerstaff/32/1133_2.png) [@formerstaff](https://community.dreamfactory.com/u/formerstaff)\ **Post date:** [September 30, 2015, 5:07pm UTC](https://community.dreamfactory.com/t/rest-api-architecture-net-service-wrapper/1516/5 "2015-09-30T17:07:51Z")
set NOCOUNT ON in your procedure. The DBLIB library does not like seeing the count returned in the first line of the response. ---
**Author:** ![Abhishek\_Tiwari](https://avatars.discourse-cdn.com/v4/letter/a/7ea924/32.png) [@Abhishek\_Tiwari](https://community.dreamfactory.com/u/Abhishek_Tiwari)\ **Post date:** [October 1, 2015, 4:18am UTC](https://community.dreamfactory.com/t/rest-api-architecture-net-service-wrapper/1516/6 "2015-10-01T04:18:08Z")
Thanks Drew…its DONE 😄 ---
**Author:** ![jeffreystables](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/jeffreystables/32/173_2.png) [@jeffreystables](https://community.dreamfactory.com/u/jeffreystables)\ **Post date:** [October 28, 2015, 2:47pm UTC](https://community.dreamfactory.com/t/rest-api-architecture-net-service-wrapper/1516/7 "2015-10-28T14:47:32Z")
A post was split to a new topic: [There is no valid session](https://community.dreamfactory.com/t/there-is-no-valid-session/1676)