namespace Common.Logic.Extensions.SQL.Interfaces
{
    using System;
    using System.Collections.Generic;

    public interface ISQLCommand
    {
        Int32 ExecuteNonQuery();

        IEnumerable<T> ExecuteReader<T>(Func<ISQLReader, T> expression);

        void ExecuteReader(Action<ISQLReader> expression);

        T ExecuteScalar<T>(Func<ISQLReader, T> expression);

        T FirstOrDefault<T>(Func<ISQLReader, T> expression);

        ISQLCommand SetParameter(String name, Object value);

        ISQLCommand SetParameter(String name, DateTime value);
    }
}