I want to implement a role based login system for my application. I want to restrict the user to only authorized actions. I want to use [Authorize] tag for my controller actions and i want to create login table in my database using database first approach.
It is very easy to create and Manage membership based Authentication in C#.net.
You can use .net In-built Asp.net Membership Provider
or if you want to build a custom membership provider, it's good idea to derive it from ExtendedMembershipProvider
.
For inbuilt .net Membership provider please refer below links:-
http://www.asp.net/web-forms/overview/older-versions-security/roles/creating-and-managing-roles-cs
Or
http://www.codeproject.com/Articles/281573/ASP-NET-Membership-and-Role-Provider
If you are using MVC framwork
then I will suggest you below links :-
http://weblogs.asp.net/jongalloway/simplemembership-membership-providers-universal-providers-and-the-new-asp-net-4-5-web-forms-and-asp-net-mvc-4-templates
also
http://www.asp.net/web-pages/overview/security/16-adding-security-and-membership