Connection Persistency

This feature controls the persistence of the database connection object within the repository classes (BaseRepository and DbRepository).

Please see the ConnectionPersistency enumeration for more information.

Types of Persistence

The following persistence modes are supported:

Repository

When working with BaseRepository, pass the persistency mode in the constructor of the derived repository.

// Repository
public class PersonRepository : BaseRepository<Person, SqlConnection>, IPersonRepository
{
    public PersonRepository(string connectionString,
        ConnectionPersistency persistency)
        : base(connectionString, persistency)
    { }

    ...
}

// Instantiation
using (var repository = new PersonRepository(connectionString, ConnectionPersistency.Instance))
{
    ...
}

The same applies to DbRepository.

// Repository
public class NorthwindRepository : DbRepository<SqlConnection>, INorthwinRepository
{
    public NorthwindRepository(string connectionString,
        ConnectionPersistency persistency)
        : base(connectionString, persistency)
    { }

    ...
}

// Instantiation
using (var repository = new NorthwindRepository(connectionString, ConnectionPersistency.Instance))
{
    ...
}

Or pass it directly during instantiation:

using (var repository = new DbRepository<SqlConnection>(settings.Value.ConnectionString, ConnectionPersistency.Instance))
{
    var people = repository.QueryAll<Person>();
}

Create Connection Method

This method creates a connection object for use within the repository. Its behavior depends on the selected persistency mode. With PerCall, it always returns a new connection instance. With Instance, it returns the existing connection instance. This behavior is overridden if the force argument is set to true, which always creates a new connection instance.

Dispose Process

With PerCall, the connection object is disposed immediately after each operation. With Instance, the connection is only disposed when the parent repository is disposed. Always call Dispose() on the repository when using Instance persistency to avoid orphaned open database connections.

Be mindful of when the repository Dispose() method is called, as improper disposal may lead to unexpected behavior.