c# - NHibernate SQL Query Could Not Execute -
i'm trying execute sql query codes below i'm getting "could not execute" error.
i thought might me.
var sqlquery = new stringbuilder(); sqlquery.append("select t.* vposterminal t, vposauthentication a.merchantno = t.vposmerchant.merchantno , a.terminalno = t.terminalno , t.status = 1"); sqlquery.sqlappende("a", "ipaddress", ipaddress); sqlquery.sqlappende("t", "terminalno", terminalno); sqlquery.sqlappende("t", "vposmerchant.merchantno", merchantno); sqlquery.sqlappende("t", "guid", posnetid); sqlquery.sqlappende("t", "vposmerchant.merchantname", merchantname); var query = session.createsqlquery(sqlquery.tostring()); query.setparameter("ipaddress", ipaddress); query.setparameter("terminalno", terminalno); query.setparameter("vposmerchant.merchantno", merchantno); query.setparameter("guid", posnetid); query.setparameter("vposmerchant.merchantname", merchantname); error:
"could not execute query\r\n[ select t.* vposterminal t, vposauthentication a.merchantno = t.vposmerchant.merchantno , a.terminalno = t.terminalno , t.status = 1 , a.ipaddress = :p0 , t.terminalno = :p1 , t.vposmerchant.merchantno = :p2 , t.guid = :p3 , t.vposmerchant.merchantname = :p4 ]\r\n name:ipaddress - value:185.28.3.23 name:terminalno - value:67011071 name:vposmerchant.merchantno - value:6706598320 name:guid - value:12730 name:vposmerchant.merchantname - value:ykb test\r\n[sql: select t.* vposterminal t, vposauthentication a.merchantno = t.vposmerchant.merchantno , a.terminalno = t.terminalno , t.status = 1 , a.ipaddress = :p0 , t.terminalno = :p1 , t.vposmerchant.merchantno = :p2 , t.guid = :p3 , t.vposmerchant.merchantname = :p4]" sqlappende:
public static stringbuilder sqlappende(this stringbuilder sb, string alias, string parametername, object parametervalue) { if (!validation.isnullorempty(parametervalue)) { sb.append(" , ").append(alias).append(".").append(parametername).append(" = :").append(parametername); } return sb; }
Comments
Post a Comment