Ado.net and dapper for Multiple list

 Here how to retrieve mutiple list using dapper as well as dapper

Using Dapper

        async Task<vmWorkFlowManagement> IWorkFlowAdminRepository.GetWorkflowDetails(int WorkflowID)

        {

            using (var con = _dapperDbConnection.CreateConnection())

            {

                var result=new vmWorkFlowManagement();

                DynamicParameters param = new DynamicParameters();

                param.Add("Workflow_ID", WorkflowID);

                var reader = await con.QueryMultipleAsync(DBSPs.getworkflowdetails, param, commandType: CommandType.StoredProcedure);

                result.WorkFlows= reader.Read<WorkFlows>().FirstOrDefault();

                result.ListWorkFlowMembers=reader.Read<WorkFlowMembers>().ToList();

            }

        }

 

using ADO.net

public vmWorkFlowManagement GetWorkflowDetails(string WorkflowID)

{

var result = new vmWorkFlowManagement();

DataSet ds = SqlHelper.ExecuteDataset(Harsco_AFIWeb_ConnectionString, "[dbo].[USP_GetWorkflowDetails]", WorkflowID);

if (ds.Tables.Count > 0)

{

result.WorkFlows = (ds.Tables[0].Rows.Count > 0) ? DataTableHelper.ConvertDataTable<WorkFlows>(ds.Tables[0]).FirstOrDefault() : new WorkFlows();

result.ListWorkFlowMembers = (ds.Tables[0].Rows.Count > 0) ? DataTableHelper.ConvertDataTable<WorkFlowMembers>(ds.Tables[1]) : new List<WorkFlowMembers>();

}

return result;

}