//Assuming @p0, @p1 is the paremeters public static SqlQuery SimpleQueryHelper(String aQuery, params object[] aValues) { NativeQuery query = new NativeQuery(); query.Query = aQuery; for (int i = 0; i < aValues.Length; i++) { ParemetersHelper helper = ParemetersHelperFactory.GetParemeterHelper(); query.Parameters.Add(helper.GetSqlParemeter(query.Parameters.Count, aValues[i])); } return(query); }
public static SqlQuery GetSQLQuery(String aStoreProcedurName, Dictionary <String, Object> aParamaters) { ParemetersHelper helper = ParemetersHelperFactory.GetParemeterHelper(); NativeStoredProcedureQuery query = new NativeStoredProcedureQuery(); query.ProcedureName = aStoreProcedurName; foreach (KeyValuePair <string, object> entry in aParamaters) { var sqlparam = helper.GetSqlParemeter(entry.Key, entry.Value); query.Parameters.Add(sqlparam); } return(query); }
public override string ToString() { ParemetersHelper helper = ParemetersHelperFactory.GetParemeterHelper(); StringBuilder result = new StringBuilder(); result.Append("["); result.Append(Query); result.Append("]"); result.AppendLine(); result.Append("["); foreach (System.Data.SqlClient.SqlParameter paremeter in this.Parameters) { result.Append(SqlSyntax.AT); result.Append(paremeter.ParameterName); result.Append(SqlSyntax.EQ); result.Append(paremeter.SqlValue); result.Append(SqlSyntax.SPACE); } result.Append("]"); return(result.ToString()); }
public ParemeterStatement() { FieldValue = new Dictionary <String, Object>(); ParemeterHelper = ParemetersHelperFactory.GetParemeterHelper(); }