C#•2y ago

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!

Punica•6/28/24, 4:27 PM

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!