Login form application using C# and Entity Framework

Question

I wrote an application in C# using Entity Framework 5.0, now I have username and password in database, I want to login with that data to my application but I can't.

This is where I'm stuck:

private void login_Click(object sender, EventArgs e)
{          
    Database1Entities connect = new Database1Entities();
    Users users = new Users();

    if (users.username == usernameTextBox.Text && users.password == passwordTextBox.Text)
    {
        Form3 f3 = new Form3();
        f3.Show();
        this.Hide();
    }
}

You have to first find one record by username, then you compare if the password is correct. And you would usually do this with hashed passwords, but i'd worry about that later. — Charles
– Charles, Commented Dec 29, 2021 at 22:37
But PLEASE don't store your password in clear text in your database table !!!! This is a HUGE security NO-GO ! — marc_s
– marc_s, Commented Dec 30, 2021 at 6:45
Also: Entity Framework is NOT a database - it's a data access library. The database might be SQL Server, Oracle, MySQL, PostgreSQL - whatever - but EF is not a database — marc_s
– marc_s, Commented Dec 30, 2021 at 6:46

David Browne - Microsoft · Accepted Answer · 2021-12-29 22:51:36Z

1

Try something like

    using var db = new Database1Entities();
    var user = db.Users.Where(u => u.UserName == usernameTextBox.Text).FirstOrDefault();

    if (user != null && user.password == passwordTextBox.Text)
    {
        Form3 f3 = new Form3();
        f3.Show();
        this.Hide();
    }

answered Dec 29, 2021 at 22:51

David Browne - Microsoft

90.8k7 gold badges53 silver badges87 bronze badges

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

Collectives™ on Stack Overflow

Login form application using C# and Entity Framework

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related