HYTOS

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Text;

using System.Data;

using System.Data.Common;

namespace ID2PSN

{

    public interface IAbstractDatabase : IDisposable

    {

        DbConnection Connection { get; }

        DbCommand GetSqlStringCommand(string sqlString);

        DbCommand GetSqlStringCommand(string sqlStringFormat, params object[] args);

        DbCommand GetStoredProcedureCommand(string storedProcName);

        DbParameter AddInParameter(DbCommand cmd, string paramName, DbType paramType, object value);

        DbParameter AddInParameter(DbCommand cmd, string paramName, DbType paramType, int size, object value);

        DbParameter AddOutParameter(DbCommand cmd, string paramName, DbType paramType, object value);

        DbParameter AddParameter(DbCommand cmd, string paramName,

                                            DbType paramType,

                                            ParameterDirection direction,

                                            object value);

        DbParameter AddParameter(DbCommand cmd, string paramName,

                                            DbType paramType,

                                            ParameterDirection direction,

                                            int size,

                                            object value);

        int ExecuteNonQuery(DbCommand cmd);

        int ExecuteNonQuery(string sSql);

        int ExecuteNonQuery(DbCommand cmd, DbTransaction txn);

        DbDataReader ExecuteReader(DbCommand cmd);

        DbDataReader ExecuteReader(DbCommand cmd, CommandBehavior behavior);

        DataSet ExecuteDataSet(DbCommand cmd, DbTransaction txn = null);

        DbTransaction BeginTransaction();

        List<string> GetTableNames();

        List<string> GetCommonTableNames();

        List<string> GetColumnNames(string TableName);

    }

}