public Query(string CmdText, string Name, string ConnectionString) { //if (CmdText.Length == 0) { throw new Exceptions.InvalidParameterException("Command Text cannot be zero length"); } sqlCon = new MySqlConnection(ConnectionString); sqlCmd = new MySqlCommand(CmdText, sqlCon); parameters = new ParameterCollection(); }
public void AddParamter(string queryName, string propertyName, ParameterCollection.FieldType type) { MappedParameter parameter = new MappedParameter(); parameter.QueryName = queryName; parameter.PropertName = propertyName; parameter.Type = type; _parameters.Add(parameter); }
public Query(string CmdText, Transaction transaction) { if (CmdText.Length == 0) { throw new Exceptions.ErrorException("Command Text cannot be zero length"); } sqlCon = transaction.Connection; sqlTran = transaction.SqlTransaction; sqlCmd = new MySqlCommand(CmdText, sqlCon); sqlCmd.Transaction = sqlTran; parameters = new ParameterCollection(); }
/// <summary> /// Constructor fot the parameter /// </summary> /// <param name="name">The name of the parameter</param> /// <param name="Val">The value of the parameter</param> /// <param name="Type">The type of parameter</param> /// <param name="Output">Determines if the parameter is of type output</param> public Parameter(string name, object Val, ParameterCollection.FieldType Type, bool Output) { if (name.Length == 0) { throw new Exceptions.ErrorException("Name can not be zero length"); } _Type = Type; _Name = name; _Value = Val; _Output = Output; SetValue(); }