0

We needed to implement "who sees what" access in our application which is developed using Entity Framework 6.2.

A simple problem statement is, we have three tables - User, Department and UserDepartments. In this one user can have access to multiple departments.

Can you please give us a hint or reference for this?

We came across multitenant approach in entity framework but in this case it is only one to one access ex. department table row would have user id so only one department access can be managed.

PS. Not shared any code as this is what we are looking for any reference.

Henry Ecker
  • 34,399
  • 18
  • 41
  • 57
Oxygen
  • 831
  • 4
  • 17
  • 42
  • You need to use a JOIN query to combine tables using ID. – jdweng Jan 22 '18 at 12:29
  • Correct but this is oldest way, is there any smart way available to manage this using SQL 2016 row level security or EF multi tenant/filter approach? – Oxygen Jan 22 '18 at 12:31
  • "Questions asking us to recommend or find a book, tool, software library, tutorial or other off-site resource are off-topic for Stack Overflow as they tend to attract opinionated answers and spam. Instead, describe the problem and what has been done so far to solve it." – Gert Arnold Jan 22 '18 at 12:37
  • @Gert. Any other platform you suggest? – Oxygen Jan 22 '18 at 12:42

0 Answers0