mvc entity framework : login using a database

Question

I have created a database in Microsoft sql server express. I need to be able to login on Mvc 2 app, using my database ( not the one existing on AcountController meaning MembershipService )

I just need to replace MemeberAhipService with my database. How can I do that ( i'm using entity framework code first ) . I don't need to create a model in visual studio. I have the usermodel, userContext: Db . I think i need repository also. Can anyone show me an example, of tell me the steps ?

jaekie · Accepted Answer · 2011-09-09 13:15:10Z

1

You can create your own MembershipService.

Example:

New MembershipService.cs (or whatever you want)

public class MembershipService
{
    public bool IsUserValid(string username, string password)
    {
         var db = new DatabaseContext();
         var user = db.GetUser(username, password);
         // Or however you want to get your data, via Context or Repository
         return (user != null); 
    }
}

New FormsClass.cs

public class FormService
{
     public void SignIn(string username, List<string> roles)
     {

            FormsAuthenticationTicket authTicket = new
                            FormsAuthenticationTicket(1,            // Version
                            username,                               // Username
                            DateTime.Now,                           // Creation
                            DateTime.Now.AddMinutes(30),            // Expiration
                            false,                                  // Persistent
                            string.Join(",", roles.ToArray()));     // Roles

            string encTicket = FormsAuthentication.Encrypt(authTicket);
            HttpContext.Current.Response.Cookies.Add(new HttpCookie(FormsAuthentication.FormsCookieName, encTicket));

            GenericIdentity id = new GenericIdentity(username);
            HttpContext.Current.User = new GenericPrincipal(id, roles.ToArray());
     }
}

In Global.asax:

        protected void Application_PostAuthenticateRequest(object sender, EventArgs e)
        {
            HttpCookie authCookie = HttpContext.Current.Request.Cookies[FormsAuthentication.FormsCookieName];
            if (authCookie != null)
            {
                string encTicket = authCookie.Value;
                if (!String.IsNullOrEmpty(encTicket))
                {
                    FormsAuthenticationTicket ticket = FormsAuthentication.Decrypt(encTicket);
                    FormsIdentity id = (FormsIdentity)Context.User.Identity;
                    var roles = ticket.UserData.Split(",".ToCharArray(), StringSplitOptions.RemoveEmptyEntries);

                    GenericPrincipal prin = new GenericPrincipal(id, roles);
                    HttpContext.Current.User = prin;

                }
            }

        }

answered Sep 9, 2011 at 13:15

jaekie

2,3214 gold badges31 silver badges55 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

studentsss Over a year ago

thx a lot. I will try doing that. I am new in mvc also entity framework. Do u have some links where i can read more about repository or doing something like login from database?

studentsss Over a year ago

Then public IMembershipService MembershipService { get; set; } will become just: public MembershipService { get; set; }

studentsss Over a year ago

Then public IMembershipService MembershipService { get; set; } will become just: public MembershipService { get; set; } . In this class we will have the properties ** username** , ** password**?

jaekie Over a year ago

You can just create an interface for MembershipService to inherit from, you can have a property called Username, I'd advise against using a Password as a property

studentsss Over a year ago

Sorry for keep asking. Just one more question, please. The DatabaseContext from yout example should look like this: public DbSet<User> LogonUser { get; set; } where in Class User I have the 2 properties : **username, password . The property GetUser with what should be populated? I would be really gratefull if u may help

|

Collectives™ on Stack Overflow

mvc entity framework : login using a database

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related