using System.Data;
using System.Data.Odbc;
using System.Configuration;

public class _baseDataAccess
{

    private string _connectionString;
    private OdbcConnection _objConn;

    /// <summary>
    /// ottiene la connectionstring
    /// </summary>
    public string ConnectionString
    {
        get { return this._connectionString; }
    }

    /// <summary>
    /// costruttore
    /// </summary>
    public _baseDataAccess()
    {
        // leggo il valore dal web.config
        this._connectionString = ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString;
        this._objConn = new OdbcConnection(this._connectionString);
    }

    /// <summary>
    /// apre e ritorna una connessione aperta
    /// </summary>
    public OdbcConnection OpenConnection()
    {

        // apro la connessione coi parametri di connectionstring da web.config
        this._objConn.Open();
        return this._objConn;

    }

    /// <summary>
    /// ritorna un commanda dalla connessione
    /// </summary>
    public OdbcCommand GetCommand()
    {

        return this._objConn.CreateCommand();

    }

    /// <summary>
    /// chiude la connessione e disalloca la memoria
    /// </summary>
    /// <remarks></remarks>
    public void CloseConnection()
    {

        if (this._objConn.State == ConnectionState.Open)
        {
            this._objConn.Close();
            this._objConn.Dispose();
        }

    }
}