Esempio n. 1
0
    /// <summary>
    ///   Initializes a new instance of the <see cref="CUBRIDCommand" /> class.
    /// </summary>
    public CUBRIDCommand()
    {
      paramCollection = new CUBRIDParameterCollection();
      isPrepared = false;

      cmdType = CommandType.Text;
      cmdText = String.Empty;
      stmtType = StmtType.NORMAL;
    }
Esempio n. 2
0
        /// <summary>
        ///   Initializes a new instance of the <see cref="CUBRIDCommand" /> class.
        /// </summary>
        public CUBRIDCommand()
        {
            paramCollection = new CUBRIDParameterCollection();
            isPrepared      = false;

            cmdType  = CommandType.Text;
            cmdText  = String.Empty;
            stmtType = StmtType.NORMAL;
        }
Esempio n. 3
0
    /// <summary>
    /// Test CUBRIDParameterCollection class
    /// </summary>
    private static void Test_Parameters_Collection()
    {
      string errMsg;

      using (CUBRIDConnection conn = new CUBRIDConnection())
      {
        conn.ConnectionString = TestCases.connString;
        conn.Open();

        CUBRIDParameterCollection pcoll = new CUBRIDParameterCollection();

        CUBRIDParameter p1 = new CUBRIDParameter("?p1", CUBRIDDataType.CCI_U_TYPE_INT);
        p1.Value = 1;
        pcoll.Add(p1);

        CUBRIDParameter p2 = new CUBRIDParameter("?p2", CUBRIDDataType.CCI_U_TYPE_CHAR);
        p2.Value = 'A';
        pcoll.Add(p2);

        CUBRIDParameter p3 = new CUBRIDParameter("?p3", CUBRIDDataType.CCI_U_TYPE_NULL);
        p3.Value = null;
        pcoll.Add(p3);

        //Try to add again p1
        errMsg = "";
        try
        {
          pcoll.Add(p1);
          throw new Exception();
        }
        catch (Exception ex)
        {
          errMsg = ex.Message;
        }
        Debug.Assert(errMsg == "Parameter already added to the collection!");

        Debug.Assert(pcoll.Count == 3);

        Debug.Assert(pcoll["?p1"].ParameterName == "?p1");
        Debug.Assert(pcoll[1].ParameterName == "?p2");

        Debug.Assert(pcoll["?p1"].DbType == DbType.Int32);
        Debug.Assert(pcoll[1].DbType == DbType.StringFixedLength);
        Debug.Assert(pcoll[2].DbType == DbType.Object);

        Debug.Assert((int)pcoll[0].Value == 1);
        Debug.Assert((char)pcoll[1].Value == 'A');
        Debug.Assert(pcoll[2].Value == null);

        //Try get non-existing parameter
        errMsg = "";
        try
        {
          string str = pcoll["?p11"].ParameterName;
        }
        catch (Exception ex)
        {
          errMsg = ex.Message;
        }
        Debug.Assert(errMsg == "?p11: Parameter not found in the collection!");

        //Try get non-existing parameter
        errMsg = "";
        try
        {
          string str = pcoll[99].ParameterName;
        }
        catch (Exception ex)
        {
          errMsg = ex.Message;
        }
        Debug.Assert(errMsg == "Index was outside the bounds of the array.");

        pcoll.RemoveAt(1);
        pcoll.Remove(p1);

        Debug.Assert(pcoll.Count == 1);

        pcoll.Clear();

        Debug.Assert(pcoll.Count == 0);
      }
    }