List of users that not yet in any role, (MVC4 with SimpleMembership and entity framework 5)
vicky
I am using mvc 4 with entity framework. I need a list of all users that have not yet been assigned any role. I cannot find any predefined function in Role.
Output will be.
My current code is as following.
var users = db.UserProfileEFMs
.ToList()
.Where(o => !Roles.GetRolesForUser(o.UserName).ToList<string>().Any())
.ToList();
but it is not working properly or is too slow. Is there any another way to get that kind of list.
I am looking for an Extentions method for Roles like.
public static class Extentions
{
public static List<string>/*UserName*/ UsersNotInAnyRole(this Roles /*System.Web.Security*/ roles)
{
/*----code----*/
}
}
currently i am using the following code
var users = db.Database.SqlQuery<UserProfile>("select * from dbo.UserProfile where UserId not in(select UserId from dbo.webpages_UsersInRoles)").ToList();
vicky
I don't get better solution. I think following is the best one.
var users = db.Database.SqlQuery<UserProfile>("select * from dbo.UserProfile where UserId not in(select UserId from dbo.webpages_UsersInRoles)").ToList();
Collected from the Internet
Please contact [email protected] to delete if infringement.
edited at
- Prev: PHP/XML routing working for one route, not for the other
- Next: Why the file/memory size of picture doesn't depend on the number of pixels?
Related
Related Related
- 1
Log4net with Entity Framework 5 and MVC4
- 2
MVC 5 Entity Framework 6 Getting all user in a role
- 3
How to list users with role names in ASP.NET MVC 5
- 4
PieChart in mvc4 from Entity Framework
- 5
Dropdownlist and MVC4 Entity Framework
- 6
Send a list of users by email in MVC4
- 7
Asp MVC Entity Framework Check if Permission Is In Role
- 8
How can i create a Partial View for MVC4 or MVC 5 using Entity Framework (.edmx Model) with Razor Views?
- 9
SimpleMembership MVC4 (existing database)
- 10
How to mock method with ViewModel in MVC4 with Entity Framework 4.0
- 11
Will Orchard CMS support MVC4 with Entity Framework
- 12
MVC4 Entity Framework Controller Database Issue
- 13
MVC4 app - how to remove Entity Framework and implement SimpleMembershipProvider?
- 14
How to mock method with ViewModel in MVC4 with Entity Framework 4.0
- 15
MVC4 Entity Framework 6 Model State Validation Issues
- 16
RESTRICT ACCESS TO Controller ACTIONS For a list of users in MVC4
- 17
List of Users with their single Role in MVC 6 left joined
- 18
Entity Framework Add User to Role
- 19
Entity Framework - good SQL, yet slow
- 20
Comparing performance of generated queries for Any() vs Count() in Entity Framework 5
- 21
Issue with MVC5 entity framework
- 22
jQuery Datatable with MVC 5 and Entity Framework
- 23
Add Entity Framework 7 to an MVC 5 project
- 24
Concurrency in ASP .NET MVC 5 with Entity Framework
- 25
Entity Framework 6.0 in MVC 5 project not working
- 26
Struggling using MVC 5 and Entity Framework 6
- 27
Entity framework error in MVC5 project
- 28
Add Entity Framework 7 to an MVC 5 project
- 29
Create default roles and users using SimpleMembership MVC 4 - Code first approach
Comments