System.Data.Common.DbDataAdapter.GetFillParameters C# (CSharp) Method

GetFillParameters() private method

private GetFillParameters ( ) : IDataParameter[]
return IDataParameter[]
        public override IDataParameter[] GetFillParameters()
        {
            IDataParameter[] value = null;
            IDbCommand select = _IDbDataAdapter.SelectCommand;
            if (null != select)
            {
                IDataParameterCollection parameters = select.Parameters;
                if (null != parameters)
                {
                    value = new IDataParameter[parameters.Count];
                    parameters.CopyTo(value, 0);
                }
            }
            if (null == value)
            {
                value = Array.Empty<IDataParameter>();
            }
            return value;
        }

Usage Example

Ejemplo n.º 1
0
    public void GetFillParametersTest()
    {
      string query = "select id, type_bit from numeric_family where id > ?";
      m_cmd = m_conn.CreateCommand();
      m_cmd.CommandText = query;
      m_adapter = GetDataAdapter();
      m_adapter.SelectCommand = m_cmd;
      IDataParameter[] param = m_adapter.GetFillParameters();
      Assert.AreEqual(0, param.Length, "#1 size shud be 0");

      DbParameter param1 = m_cmd.CreateParameter();
      param1.ParameterName = "@param1";
      param1.Value = 2;
      m_adapter.SelectCommand.Parameters.Add(param1);

      param = m_adapter.GetFillParameters();
      Assert.AreEqual(1, param.Length, "#2 count shud be 1");
      Assert.AreEqual(param1, param[0], "#3 Params shud be equal");
    }