RoleToPermission and Permission entity in EF data model

[mehdihadeli]

Hi @kgrzybek,
I can't find implementation for RoleToPermission and Permission in the domain model of your code base, but their tables exists in your sql migration scripts!!
How could we map RoleToPermission configurations for EF core?

[AndreiGanichev]

Hi, @mehdihadeli.
There is v_UserPermissions view which contains data about users and their permissions. This view is used in Read model to get the user's permissions and check is the user authorized for some action. Read model doesn't use EF(Write model does).

btw, @kgrzybek wrote about using database views here:

I try not to refer to tables directly and instead refer to database views. This is a nice way to create abstraction and decouple our application from database schema because I want to hide database internals as much as possible.

[mehdihadeli]

@AndreiGanichev Thanks for your explanation.