/// <summary> /// Used Internally to merge parameters returned by the provider back into the original collection. /// </summary> /// <param name="parms"></param> internal void Merge(esParameters parms) { foreach (esParameter esParam in parms) { esParameter esOriginalParam = this.hash[esParam.Name]; esOriginalParam.Value = esParam.Value; } }
/// <summary> /// Use this method to fetch a given esParameter by name. There should be no prefix such as @, ? or : in the name. /// </summary> /// <param name="name">The name of the parameter without a prefix, for example, "EmployeeID" not "@EmployeeID".</param> /// <returns>The desired parameter or null/Nothing if not found</returns> public esParameter this[string name] { get { esParameter param = null; if (this.hash.ContainsKey(name)) { param = this.hash[name]; } return(param); } }
/// <summary> /// /// </summary> /// <param name="parameter">An already created esParameter. This is mostly used internally.</param> /// <returns>The same parameter passed in</returns> public esParameter Add(esParameter parameter) { this.parameters.Add(parameter); this.hash[parameter.Name] = parameter; return parameter; }
/// <summary> /// /// </summary> /// <param name="parameter">An already created esParameter. This is mostly used internally.</param> /// <returns>The same parameter passed in</returns> public esParameter Add(esParameter parameter) { this.parameters.Add(parameter); this.hash[parameter.Name] = parameter; return(parameter); }
//public int TestAssignPrimaryKeys() //{ // this.AssignPrimaryKeys(); // return this.Table.PrimaryKey.Length; //} //public int TestRemovePrimaryKeys() //{ // this.RemovePrimaryKeys(); // return this.Table.PrimaryKey.Length; //} public void TestParamsWithScale() { esParameter myParam = new esParameter("Salary", 12.34); myParam.DbType = DbType.Decimal; myParam.Precision = 18; myParam.Scale = 2; myParam.Direction = esParameterDirection.InputOutput; esParameters parms = new esParameters(); parms.Add(myParam); parms.Add("DepartmentID", 1); //parms.Add("DepartmentID", null); parms.Add("FirstName", "Entity"); parms.Add("LastName", "Spaces"); parms.Add("Age", 100); parms.Add("HireDate", "2000-12-31 00:00:00"); parms.Add("IsActive", false); this.ExecuteNonQuery(esQueryType.StoredProcedure, "proc_esTestInsert", parms); }