Generic Repository with SQLite and SQL Compact Databases
- by Andrew Petersen
I am creating a project that has a mobile app (Xamarin.Android) using a SQLite database and a WPF application (Code First Entity Framework 5) using a SQL Compact database. This project will even eventually have a SQL Server database as well. Because of this I am trying to create a generic repository, so that I can pass in the correct context depending on which application is making the request.
The issue I ran into is my DataContext for the SQL Compact database inherits from DbContext and the SQLite database inherits from SQLiteConnection. What is the best way to make this generic, so that it doesn't matter what kind of database is on the back end?
This is what I have tried so far on the SQL Compact side:
public interface IRepository<TEntity>
{
TEntity Add(TEntity entity);
}
public class Repository<TEntity, TContext> : IRepository<TEntity>, IDisposable
where TEntity : class
where TContext : DbContext
{
private readonly TContext _context;
public Repository(DbContext dbContext)
{
_context = dbContext as TContext;
}
public virtual TEntity Add(TEntity entity)
{
return _context.Set<TEntity>().Add(entity);
}
}
And on the SQLite side:
public class ElverDatabase : SQLiteConnection
{
static readonly object Locker = new object();
public ElverDatabase(string path) : base(path)
{
CreateTable<Ticket>();
}
public int Add<T>(T item) where T : IBusinessEntity
{
lock (Locker)
{
return Insert(item);
}
}
}
