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

Popular posts from this blog

Java sticky instances of class com.mysql.jdbc.Field aggregating -