using System.Collections.Generic;
using System.Data;
using System.Linq;

namespace Simple.Data.Sql
{
    public class DbCommandBuilder
    {

        public IDbCommand BuildCommand(IDbConnection connection, string sql, IEnumerable<KeyValuePair<string, object>> parameters)
        {
            return BuildCommand(connection, sql,
                                parameters.ToDictionary(kv => kv.Key, kv => kv.Value));
        }

        public IDbCommand BuildCommand(IDbConnection connection, string sql, IDictionary<string, object> parameters)
        {
            var cmd = connection.CreateCommand();
            cmd.Connection = connection;
            cmd.CommandText = sql;

            parameters.ToList()
                .ForEach(cmd.AddParameter);

            return cmd;
        }

    }
}