How should I store this information?
Posted
by 5YrsLaterDBA
on Stack Overflow
See other posts from Stack Overflow
or by 5YrsLaterDBA
Published on 2010-05-07T19:33:30Z
Indexed on
2010/05/07
19:48 UTC
Read the original article
Hit count: 147
c#
I have a PrivilegeGroup
table, a Privileges
table and a link
table because the PrivilegeGroup
table and the Privileges
table is a many to many relationship. I am thinking about load all contents of PrivilegeGroup
table and Privilege
table into memory from database at beginning when application started.
I want to save them in a form easily to look up. Usually we will look up the PrivilegeCode
via GroupId
.
Which structure is good for this purpose? array of list? dictionary?
© Stack Overflow or respective owner