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 Dreamfactor…

Check here: https://github.com/dreamfactorysoftware/.net-sdk and here: https://blog.dreamfactory.com/.net-sdk-for-dreamfactory-is-now-available and here: Make a Stored Procedure Call using .NET SDK

Thanks crystal for the references…

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 } ] }

set NOCOUNT ON in your procedure. The DBLIB library does not like seeing the count returned in the first line of the response.

REST API Architecture (.net service wrapper)

Code Examples

Topic		Replies	Views
Make a Stored Procedure Call using .NET SDK Client SDKs	2	2571	September 17, 2015
Error 404: Procedure 'procedure_name' does not exist in the database REST API	2	1717	March 21, 2019
Rest api > mysql proc (two params) > json post data REST API	2	2491	January 20, 2018
.Net Example of connecting and consuming the API Code Examples	1	3596	October 6, 2014
Consuming dreamfactory webservice in c# asp.net	5	2201	August 11, 2016

REST API Architecture (.net service wrapper)

Related topics