public virtual async Task ExecuteAsync() { AssignParameterValues(); if (Conn.State == ConnectionState.Open) { await Cmd.ExecuteNonQueryAsync(); } else { await Conn.OpenAsync(); try { await Cmd.ExecuteNonQueryAsync(); } catch { throw; } finally { Conn.Close(); } } AssignValuesParameters(); try { LastMsg = Parameters.OfType <DbParameter>().ToList().First(x => x.ParameterName == "@msg").Value.ToString(); } catch { LastMsg = ""; } }
public virtual Dictionary <string, object> ReturnValues() { return(Parameters.OfType <DbParameter>() .Where(p => p.Direction == ParameterDirection.InputOutput || p.Direction == ParameterDirection.Output) .ToDictionary(i => i.ParameterName, i => i.Value)); //Dictionary<string, object> Result = new Dictionary<string, object>(); //foreach (SqlParameter Param in Parameters) //{ // if (Param.Direction == ParameterDirection.InputOutput || Param.Direction == ParameterDirection.Output) // { // Result.Add(Param.ParameterName, Param.Value); // } //} //return Result; }