private static int FindRoleId(MySqlMembershipContext db, string roleName)
        {
            var role = db.Roles.SingleOrDefault(x => x.RoleName == roleName);

            if (role != null)
            {
                return(role.RoleId);
            }

            return(-1);
        }
        private List <int> GetUserIdsFromNames(MySqlMembershipContext db, string[] usernames)
        {
            var userIds = new List <int>(usernames.Length);

            foreach (var username in usernames)
            {
                var id = MySqlSimpleMembershipProvider.GetUserId(db, username);
                if (id == -1)
                {
                    throw new InvalidOperationException(String.Format(CultureInfo.CurrentCulture, Resources.Security.Security_NoUserFound, username));
                }
                userIds.Add(id);
            }
            return(userIds);
        }
        private static List <int> GetRoleIdsFromNames(MySqlMembershipContext db, string[] roleNames)
        {
            var roleIds = new List <int>(roleNames.Length);

            foreach (string role in roleNames)
            {
                var id = FindRoleId(db, role);

                if (id == -1)
                {
                    throw new InvalidOperationException(String.Format(CultureInfo.CurrentCulture, Resources.Security.SimpleRoleProvider_NoRoleFound, role));
                }
                roleIds.Add(id);
            }
            return(roleIds);
        }