I am using SignalR to the chatting application along with XAF framework. as in most of the applications we need to show the online users and then an user can start a chat with another so to get the list I have to write a complex query using 4-5 tables so my question is what is the best way to query the tables/XPO from the Hub class.
In the Below class i have another method where I want to get all the online users and display in a list in the page.
C#[HubName("ChatHub")]
public class ChatHub : Hub<IChatHub>
{
public void ClientWelcomeMessage(string message)
{
Clients.All.ClientWelcomeMessage(message);
}
}