public async Task <ApiResponseWrapper> GetEntityList(UserInfo entityObject) { InjectCommonParameters(true, entityObject); customCommand.CommandText = UserInfo.const_Proc_UserInfo_SelectSearch; customCommand.CommandType = CommandType.StoredProcedure; DatabaseEngine objDatabaseEngine = new DatabaseEngine(connectionString); ApiResponseWrapper objApiResponseWrapper = await objDatabaseEngine.ExecuteObjectAsync(customCommand, true); DataSet ds = objApiResponseWrapper.apiResponseData; List <UserInfo> lstEntityToReturn = new List <UserInfo>(); if (ds.Tables.Count > 0) { if (ds.Tables[0].Rows.Count > 0) { lstEntityToReturn = AutoMapper.ConvertDataTable <UserInfo>(ds.Tables[0]); objApiResponseWrapper.apiResponseStatus = true; objApiResponseWrapper.apiResponseData = lstEntityToReturn; } } objApiResponseWrapper.apiResponseData = lstEntityToReturn; return(objApiResponseWrapper); }