How to create user login and forget password using Ado enttity frame work

http://stackoverflow.com/questions/54991/generating-random-passwords

http://stackoverflow.com/questions/13212938/forgot-password-email-confirmation-in-asp-net-mvc-webmatrix

int id = Convert.ToInt32(txtusername.Text);
db2Entities db = db2Entities();
string query = (from c in db.AdminTables
where c.AdminID == id && c.AdminPassword == txtpassword.Text
select c.AdminFirstName).FirstOrDefault();
if (query != null)
{
Response.Redirect("/Admin/Dasboard.aspx");
}
else
Response.Write("Invalid User");
 
//**************************** For PasswordChange**************************************
try
{
db2Entities db = new db2Entities();
var query = (from c in db.AdminTables
where c.AdminPassword == txtoldpassword.Text
select c).FirstOrDefault();
query.AdminPassword = txtreenteredpassword.Text;
db.SaveChanges();
Label1.Visible = true;
Label1.Text = " Password Changed Sucessfully";
Response.Write("Password Changed Sucessfully");
 
}
catch (Exception ex )
{
Label1.Visible = true;
Label1.Text = " Error occured in Pasword changing";
//Response.Write(ex);
}

Int id = Convert.ToInt32(txtusername.Text);
db2Entities db = db2Entities();
string query = (from exa in db.AdminTables
where exa.AdminID == id && exa.AdminPassword == txtpassword.Text
select c.AdminFirstName).FirstOrDefault();
if (query != null)
{
Response.Redirect("/Admin/Example.aspx");
}
else
Response.Write("Invalid User");