using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Tango.PPC.Shared.SQL;

namespace Tango.FSE.Common.SQL
{
    /// <summary>
    /// Represents a remote SQL provider.
    /// Can be used to execute commands against the remote machine's database and the global twine's database.
    /// </summary>
    /// <example>
    /// <para>
    /// <i>
    /// The following example demonstrates how to set the connected machine's demo state and query for the connected machine's jobs.
    /// </i>
    /// </para>
    /// <code lang="C#" source="../Tango.FSE.Procedures/Examples/Sql/Program.cs" title="Remote SQL" region="Example" />
    /// </example>
    public interface IRemoteSqlProvider
    {
        /// <summary>
        /// Executes the SQL command asynchronously.
        /// </summary>
        /// <param name="command">The command.</param>
        /// <returns>Remote command result.</returns>
        Task<RemoteSqlCommandResult> ExecuteSqlCommandAsync(RemoteSqlCommand command);

        /// <summary>
        /// Executes the SQL command.
        /// </summary>
        /// <param name="command">The command.</param>
        /// <returns>Remote command result.</returns>
        RemoteSqlCommandResult ExecuteSqlCommand(RemoteSqlCommand command);
    }
}