DapperSpFlow 1.0.1

SQL server In your stored procedure called, sch.usp_getClient @ClientId int you are making this call.

SELECT
	*
FROM
	Clients
    WHERE ClientId = @ClientId
FOR JSON PATH, ROOT ('Client')

    SELECT
	*
FROM
	Data1
FOR JSON PATH, ROOT ('Data1')

    SELECT
	*
FROM
FOR JSON PATH, ROOT ('Catalog1')

Then, after install this package. Create a class that represents your sp

    public partial class GetClient : StoredRequest
    {
    	public int ClientId { get; set; }

    	public override bool PreValidate()
    	{
        		return true;
    	}

    	public override bool Validate(IDbConnection db)
    	{
     	   return true;
    	}

    	public override void PostOperate(IDbConnection db)
    	{
    	}

    	public override string GetStoredName()
    	{
        return "sch.usp_getClient";
    	}
    }

In your next layer ( In this case simplified to API)

[HttpGet]
public async Task<IActionResult> GetClient([FromQuery] GetClient request)
{
        List<string> response;
        using (IDbConnection cnx = new SqlConnection("yourconnectionstring"))
        {
            response = await request.ExecAsync(cnx);
        }
        return Ok(response);
}

In your client code

function Call(){
	let request = { ClientId: 1};
	let response = await this.getTransaction("Client/GetClient", request);
	var client = JSON.parse(response[0]).Client[0];
	var dataList = JSON.parse(response[1]).Data1;
	var dataCatalog = JSON.parse(response[2]).Catalog1;
}