I am trying to write a SQL Query to get all users but that are from a specific role that is passed as an Input parameter, but I don't find any possibility to get a research of all RolesIs there any possibility or not ?Should I create a table where are cloned all the roles present ?
Hello Omar,
If your input parameter is Role name so you will need to join user entity with User_Role entity with Role entity and you condition that Role.Name = @role
If your parameter is Id of role you will need to join with User_Role entity only and you condition will be User_Role.RoleId= @Role