Example #1
0
        public async Task <ScriptMultipleResult> ExecuteScriptMultiple(string script, object param = null)
        {
            var result = new ScriptMultipleResult();
            var data   = new List <IEnumerable <dynamic> >();

            try {
                using (var connection = BuildConnection()) {
                    var reader = await connection.QueryMultipleAsync(script, param);

                    while (!reader.IsConsumed)
                    {
                        data.Add(reader.Read());
                    }

                    result.Data = data;
                }
            }
            catch (SqlException e) {
                result.SetException(e);
            }

            return(result);
        }