Question about SQL server and VPF visual studio
Hi, I'm writing a program for tourist transport and I'm facing a user and role problem. The thing is that when adding a user to the database via W PF, I need to indicate which role he belongs to, but the problem is that if I create a role: 1. It is not tied to the user and 2. When creating a user, I cannot indicate which role he belongs to it is treated without specifying a foreign key. P.s I don't speak English well, so I use a translator
https://paste.mod.gg/czhufdribaha/0
BlazeBin - czhufdribaha
A tool for sharing your source code with the world!
1 Reply
do somthing like that:
https://paste.mod.gg/scbniurpbyrk/0
so in the Database is set a foreignkey for the column. now you can get a list of user´s have the ID´s from the Usergroup. You can get the Usergroup to put it in as a list for a ModelView when making a User.
I Used EF Core to generating the tables and all
BlazeBin - scbniurpbyrk
A tool for sharing your source code with the world!