public int Delete(UserRolesTable userRole) { if (_database.Entry(userRole).State == System.Data.Entity.EntityState.Detached) { dbSet.Attach(userRole); } dbSet.Remove(userRole); return this.Save(); }
/// <summary> /// Constructor that takes a MySQLDatabase as argument /// </summary> /// <param name="database"></param> public UserStore(MySQLDatabase database) { Database = database; userTable = new UserTable <TUser>(database); roleTable = new RoleTable(database); userRolesTable = new UserRolesTable(database); userClaimsTable = new UserClaimsTable(database); userLoginsTable = new UserLoginsTable(database); }
/// <summary> /// Inserts a new role for a user in the UserRoles table /// </summary> /// <param name="user">The User</param> /// <param name="roleId">The Role's id</param> /// <returns></returns> /*public int Insert(IdentityUser user, string roleId) { string commandText = "Insert into UserRoles (UserId, RoleId) values (@userId, @roleId)"; Dictionary<string, object> parameters = new Dictionary<string, object>(); parameters.Add("userId", user.Id); parameters.Add("roleId", roleId); return _database.Execute(commandText, parameters); }*/ public int Insert(IdentityUser user, string roleId) { var userRole = new UserRolesTable { UserId = user.Id, RoleId = roleId }; dbSet.Add(userRole); return this.Save(); }