Как управлять правами пользователей на основе ролей с помощью ASP.NET & MSSQL?

---

i have multiple asp.net web form and sql express database. in web form there are 3 types of action that i wan to control Menu, ADD, DELETE , EDIT.

I wan to create custom User role to specify user rights to manage access control of asp.net c# Application (Menu, ADD,DELETE and EDIT visibility).

What I have tried:

Currently i am try to manage using simple sql reader query on every page for every button and link.

string yes = "1";

if (rdr["access"].ToString() == yes.ToString())

Button1.Visible = true;

---