public async Task <IReadOnlyList <User> > ListAsync(IQueryableSpecification <User> specification = null)
{
using (var ctx = new EntityFrameworkContext(_options)) {
var query = ctx.Users as IQueryable <User>;
if (specification != null)
{
query = query.Where(specification.Predicate);
}
return(await query.ToListAsync().ConfigureAwait(false));
}
}
public EntityFrameworkRepository()
{
_connection = new SqlConnection("Server=(localdb)\\mssqllocaldb;Integrated Security=true;");
_connection.Open();
_options = new DbContextOptionsBuilder <EntityFrameworkContext>()
.UseSqlServer(_connection)
.Options;
using (var context = new EntityFrameworkContext(_options)) {
context.Database.EnsureCreated();
}
}