public UnitOfWork() { _context = new MessengerClient_DBEntities(); messagesRepo = new MessagesRepository(_context); usersRolesRepo = new UsersRepository(_context); rolesMappingRepo = new RolesRepository(_context); }
public override string[] GetRolesForUser(string username) { using (MessengerClient_DBEntities _context = new MessengerClient_DBEntities()) { var userRoles = (from user in _context.Users join roleMapping in _context.UserRolesMapping on user.ID equals roleMapping.UserID join role in _context.RoleMaster on roleMapping.RoleID equals role.ID where user.Username.ToLower() == username.ToLower() orderby role.RoleName select role.RoleName).ToArray(); return(userRoles); } }
public MessagesRepository(MessengerClient_DBEntities context) : base(context) { }