public override DataTable Execute() { ParameterInfo para = (ParameterInfo)this._hs["Name"]; using (SessionFactory sf = new SessionFactory()) { sf.BeginTransaction(); DataTable dt = sf.CreateQuery("SELECT * FROM TEST WHERE NAME = '" + para.Value + "'"); List <Test> lst = sf.CreateQuery <Test>("SELECT * FROM TEST"); ParameterInfo[] pi = { new ParameterInfo("Name", "W01", typeof(string), Direction.Input) }; sf.CreateStoredProcedure("testfunc", true, pi); sf.Commit(); return(dt); } }