using System.Data;
using System.Data.Common;

namespace CSFramework.DB
{
    /// <summary>
    /// ADO(ActiveX Data Object)ADO.NET活动数据对象工厂
    /// </summary>
    public interface IAdoFactory
    {
        /// <summary>
        /// DbCommand的参数符号，@,?,:
        /// </summary>
        string ParamSymboName { get; set; }

        string BuildConnectionString(string server, int port, string dbName,
            string uid, string pwd, int timeout = 15);

        CommandHelper CreateSqlProc(string spName);

        CommandHelper CreateCommand(string commandText);

        DbParameter CreateTimestampParameter(string parameterName,
            string fieldName);

        DbConnection CreateConnection();

        DbConnection CreateConnection(string connectionString);

        DbCommand CreateCommand(string commandText, CommandType commandType);

        DbParameter CreateParameter(string parameterName,
            object parameterValue);

        DbParameter CreateParameter(string parameterName, DbType parameterType,
            int size, string sourceColumn, object parameterValue);

        DbCommandBuilder CreateCommandBuilder();

        DbDataAdapter CreateDataAdapter();

        DbDataAdapter CreateDataAdapter(AdapterRowUpdatingEvent eventHandler);
    }
}