コード例 #1
0
        public static async Task <object> ExecuteCommandAsync(DbConnection conn, string commandText
                                                              , CommandResultTypeEnum commandResultType = CommandResultTypeEnum.Table, CommandType commandType = CommandType.Text
                                                              , IEnumerable <DbParameter> parameters    = null, Action <DbCommand> onCreateCommand = null)
        {
            if (conn == null)
            {
                throw new ArgumentNullException("conn");
            }
            if (string.IsNullOrEmpty(commandText))
            {
                throw new ArgumentNullException("commandText");
            }

            if (conn.State != System.Data.ConnectionState.Open)
            {
                await conn.OpenAsync();
            }

            using (var cmd = GetCommand(conn, commandText, commandType, (parameters != null ? parameters.ToArray() : null)))
            {
                if (onCreateCommand != null)
                {
                    onCreateCommand(cmd);
                }

                object result = null;

                switch (commandResultType)
                {
                case CommandResultTypeEnum.Table:
                {
                    DataTable table = null;

                    using (var reader = await cmd.ExecuteReaderAsync())
                    {
                        while (await reader.ReadAsync())
                        {
                            // Inicializar DataTable

                            if (table == null)
                            {
                                table = new DataTable();

                                for (int i = 0; i < reader.FieldCount; i++)
                                {
                                    table.Columns.Add(reader.GetName(i), typeof(object));
                                }
                            }

                            // Criar linha na datatable

                            var row = table.NewRow();

                            for (int i = 0; i < reader.FieldCount; i++)
                            {
                                var obj = await reader.GetFieldValueAsync <object>(i);

                                row[i] = obj;
                            }

                            table.Rows.Add(row);
                        }
                    }

                    result = table;
                }
                break;

                case CommandResultTypeEnum.NonQuery:
                {
                    result = await cmd.ExecuteNonQueryAsync();
                }
                break;

                case CommandResultTypeEnum.Reader:
                {
                    result = await cmd.ExecuteReaderAsync();
                }
                break;

                default:
                    throw new ApplicationException(string.Format("Invalid ExecuteCommand result type: '{0}'", commandResultType));
                }

                if (cmd.Parameters != null)
                {
                    cmd.Parameters.Clear();
                }

                return(result);
            }
        }
コード例 #2
0
 public CommandResult(T result, CommandResultTypeEnum type)
 {
     Result = result;
     Type   = type;
 }
コード例 #3
0
        public static async Task <object> ExecuteCommandAsync(string connectionString, string command, CommandResultTypeEnum commandResultType = CommandResultTypeEnum.Table, CommandType commandType = CommandType.Text, IEnumerable <DbParameter> parameters = null, string providerName = "System.Data.SqlClient", Action <DbCommand> onCreateCommand = null)
        {
            if (string.IsNullOrEmpty(connectionString))
            {
                throw new ArgumentNullException("connectionString");
            }

            using (var conn = GetConnection(connectionString, providerName))
            {
                return(await ExecuteCommandAsync(conn, command, commandResultType, commandType, parameters, onCreateCommand));
            }
        }