aspnetdb中的SQL查询 [英] SQL Query in aspnetdb

问题描述

大家好，

我正在使用aspnetdb数据库.
我创建了Users，Roles并将角色分配给Users.
现在，我需要查询以显示特定RoleId的UserId，Username.
例如，
我有一个具有一些uniquekey1的用户ABC和一个角色RoleName为"Admin"的角色，该角色已分配给具有一些uniquekey2的用户ABC和RoleId.
现在，我想查询以获取特定角色的UserID，用户名.

我想我很清楚.
请任何人帮助我.

谢谢您，

Hi All,

I am using aspnetdb database.
I created the Users,Roles and assigned Roles to the Users.
Now I need a query to display UserId,Username for a particular RoleId.
For example,
I have a user ABC with some uniquekey1 and a Role with RoleName ''Admin'' which assigned to user ABC and RoleId with some uniquekey2.
Now I want a query to fetch UserID,userName for a particular Role.

I think I am clear.
Please anyone help me.

Thank you,

推荐答案

尝试一下:

Try this:

SELECT        aspnet_Users.UserName, aspnet_Users.UserId
FROM          aspnet_Users INNER JOIN
              aspnet_UsersInRoles ON aspnet_Users.UserId = aspnet_UsersInRoles.UserId INNER JOIN
              aspnet_Roles ON aspnet_UsersInRoles.RoleId = aspnet_Roles.RoleId
WHERE        (aspnet_Roles.RoleName = 'admin')

希望对您有帮助

Hope it help

这篇关于aspnetdb中的SQL查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！