using System;
using System.Data.OleDb;
using SyncEngine.Configuration;

namespace SyncEngine.Access
{
    public sealed class AccessConnectionFactory
    {
        private readonly SyncOptions _options;

        public AccessConnectionFactory(SyncOptions options)
        {
            _options = options;
        }

        public OleDbConnection Create()
        {
            // Do not set Jet OLEDB:User Name unless a workgroup .mdw is configured — it breaks password-only .mdb files.
            var cs = string.Format(
                "Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Jet OLEDB:Database Password={1}",
                _options.AccessDbPath,
                _options.AccessDbPassword);
            return new OleDbConnection(cs);
        }
    }
}