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

Filed under:

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

Related posts about c#