Click here to Skip to main content
15,847,903 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:

I am working on a winform program with also a webinterface.
I have 3 types off users: Employee's, Customers and Office users.

I want to have a stable and performant solution u work with user and role management.

So what's best:

- 1 big table with all the user information
- 1 table with common fields and a table/type with type specific information

... and how do i manage the user role's

In the first option there will be many blank fields, what about performance


1 solution

- 1 big table with all the user information

Well, that breaks DB normalisation rules so it should be well and truly avoided.

Why don't you take a look at the role and membership providers[^] as provided by Microsoft? Initially they were designed to be used with websites, but you can use them with desktop applications. They take care of users and their roles.
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900