c# - Login control using fluent nhibernate -
i'm new fluent nhibernate , i'm stuck problem created login control in asp.net using tradition methods , want use fluent nhibernate upgrade code , i'm stuck current code given below
protected void button1_click(object sender, eventargs e) { sqlconnection con = new sqlconnection(configurationmanager.connectionstrings["con1"].connectionstring); con.open(); sqlcommand cmdr = new sqlcommand("select name,password registration", con); sqldatareader dr = cmdr.executereader(); while (dr.read()) { if (txt_name.text == dr[0].tostring() && txt_pass.text == dr[1].tostring()) { session["new"] = txt_name.text; response.redirect("logout.aspx"); } else { label4.text ="invalid username/password"; } } } and question how same function using fluent nhibernate
using nhibernate.linq; public isession dbsession { get; set; } // set on each beginrequest isessionfactory.opensession(); protected void button1_click(object sender, eventargs e) { var registrations = dbsession.query<registration>() .where(registration => registration.name == txt_name.text) .tolist(); if (registrations.count == 0 || registrations[0].password != txt_pass.text) { label4.text ="invalid username/password"; } else { session["new"] = txt_name.text; response.redirect("logout.aspx"); } }
Comments
Post a Comment