public EmployeeListViewModel()
{
using (var datacontext = new ShopDbEntities())
{
_employeeRepository = new SqlRepository <Employee>(datacontext);
var query = from employee in _employeeRepository.GetAll().AsEnumerable() select employee;
EmployeeList = query.ToList();
}
}
private void CheckDb()
{
using (var context = new ShopDbEntities())
{
if (!context.Database.Exists())
{
MessageBox.Show("Unable to connect to database.");
Application.Current.Shutdown();
}
}
}
public void TestMethod1()
{
using (var dataContext = new ShopDbEntities())
{
var publishers = new SqlRepository <Publisher>(dataContext);
Publisher publisher = publishers.GetById(1);
Assert.AreEqual("DC Comics", publisher.Name);
}
}
internal RoleFilter(Dictionary <string, bool> roles, ShopDbEntities context)
{
Roles = roles;
using var userStore = new UserStore <User>(context);
foreach (var key in roles.Keys)
{
if (!UsersInRole.ContainsKey(key))
{
UsersInRole.Add(key, Task.Run((() => userStore.GetUsersInRoleAsync(key))).Result);
}
}
}
public EfAsyncSeriesRepository(ShopDbEntities context)
{
_context = context;
}
public DbRoleFilterFactory(ShopDbEntities context)
{
_context = context;
}
public EFUnitOfWork(ShopDbEntities entities)
{
this._entities = entities;
}
public EfOrderRepositoryAsync(ShopDbEntities context)
{
_context = context;
}
public EfAsyncArtistRepository(ShopDbEntities context)
{
_context = context;
}
public EfAsyncPublisherRepository(ShopDbEntities context)
{
_context = context;
}
public EfComicBookRepositoryAsync(ShopDbEntities context)
{
_context = context;
}
