AccessStorage.cs :  » Persistence-Frameworks » FileHelpers-Library » FileHelpers » DataLink » C# / CSharp Open Source

#region "   Copyright 2005-07 to Marcos Meli - http://www.marcosmeli.com.ar" 

// Errors, suggestions, contributions, send a mail to: marcos@filehelpers.com.

#endregion

#if ! MINI

using System;
using System.Data;
using System.Data.OleDb;

namespace FileHelpers.DataLink{

  /// <summary>This is a base class that implements the <see cref="DataStorage"/> for Microsoft Access Files.</summary>
  public sealed class AccessStorage : DatabaseStorage
  {

    #region "  Constructors  "
    
    /// <summary>Creates a new AccessStorage.</summary>
    /// <param name="recordType">The Type of the Records</param>
    public AccessStorage(Type recordType)
            :this(recordType, string.Empty)
    {}

    /// <summary>Creates a new AccessStorage using the indicated file.</summary>
    /// <param name="recordType">The Type of the Records</param>
    /// <param name="accessFile">The MS Access file.</param>
    public AccessStorage(Type recordType, string accessFile)
            :base(recordType)
    {
      AccessFileName = accessFile;
            ConnectionString = DataBaseHelper.GetAccessConnection(AccessFileName, AccessFilePassword);
    }

    #endregion

    #region "  Create Connection and Command  "

    /// <summary>Must create an abstract connection object.</summary>
    /// <returns>An Abstract Connection Object.</returns>
    protected sealed override IDbConnection CreateConnection()
    {
      if (mAccessFile == null || mAccessFile == string.Empty)
        throw new BadUsageException("The AccessFileName cant be null or empty.");

      return new OleDbConnection(ConnectionString);
    }


    #endregion

    #region "  AccessFileName  "

    private string mAccessFile = string.Empty;
    /// <summary>The file full path of the Microsoft Access File.</summary>
    public string AccessFileName
    {
      get { return mAccessFile; }
            set
            {
                mAccessFile = value;
                ConnectionString = DataBaseHelper.GetAccessConnection(AccessFileName, AccessFilePassword); ConnectionString = DataBaseHelper.GetAccessConnection(AccessFileName, AccessFilePassword);
            }
    }

    #endregion

    #region "  AccessFilePassword  "

    private string mAccessPassword = string.Empty;
    /// <summary>The password to the access database.</summary>
    public string AccessFilePassword
    {
      get{ return mAccessPassword; }
            set
            {
                mAccessPassword = value;
                ConnectionString = DataBaseHelper.GetAccessConnection(AccessFileName, AccessFilePassword); ConnectionString = DataBaseHelper.GetAccessConnection(AccessFileName, AccessFilePassword);
            }
    }

    #endregion
  }

}

#endif