clsData holds the declaration of all variables involved in stored procedure calling and some more. Most of them are arrays of clsColumn. We can review the code to see the purpose of each variable. Classes that inherite from clsData initialices all those variables with the correct values, need to invoke a SP. An inherited class usually belongs to a one table.

    public class clsData
    {
        /// <summary>
        /// Prefix used in stored procedures parameters, 
        /// used to differentiate them from variables deffined inside SP.
        /// </summary>
        public string Prefix = "p";

        /// <summary>
        /// GET SP parameters, are the same of GETTOP.
        /// </summary>
        public clsColumn[] ParamsGET; 

        /// <summary>
        /// INS SP parameters
        /// </summary>
        public clsColumn[] ParamsINS;

        /// <summary>
        /// UPD SP parameters
        /// </summary>
        public clsColumn[] ParamsUPD;

        /// <summary>
        /// DEL SP parameters
        /// </summary>
        public clsColumn[] ParamsDEL;

        /// <summary>
        /// QUERY SP parameters
        /// </summary>
        public clsColumn[] ParamsQUERY;

        /// <summary>
        /// Columns returned by GET SP as a result of the SELECT
        /// </summary>
        public clsColumn[] ResultColumns;

        /// <summary>
        /// Connection string
        /// </summary>
        public string CadConnBBDD;

        /// <summary>
        /// GET SP full name, p. ex: CLIENTS_GET
        /// </summary>
        public string spGET;

        /// <summary>
        /// INS SP full name, p. ex: CLIENTS_INS
        /// </summary>
        public string spINS;

        /// <summary>
        /// UPD SP full name, p. ex: CLIENTS_UPD
        /// </summary>
        public string spUPD;

        /// <summary>
        /// DEL SP full name, p. ex: CLIENTS_DEL
        /// </summary>
        public string spDEL;

        /// <summary>
        /// QUERY SP full name, p. ex: CLIENTS_QUERY
        /// </summary>
        public string spQUERY;

        /// <summary>
        /// COUNT SP full name, p. ex: CLIENTS_COUNT
        /// </summary>
        public string spCOUNT;

        /// <summary>
        /// SqlConnection object. this is used if the programmer wants
        /// to use the same connection all time, without closing and opening it every time.
        /// </summary>
        public SqlConnection SQLConn = null;

        /// <summary>
        /// Transaction object. Optional, if null is not used.
        /// </summary>
        public SqlTransaction SQLTrans = null;

        /// <summary>
        /// Boolean that indicates if the table has an identity column
        /// </summary>
        public bool HasIdentity = false;

        /// <summary>
        /// Boolean that indicates if the table uses a the cache system.
        /// </summary>
        public bool UseCache = false;

        /// <summary>
        /// Boolean that indicates if the cache is automanaged.
        /// </summary>
        public bool AutoManageCache = true;

        /// <summary>
        /// Table name
        /// </summary>
        public string TableName = "";

        /// <summary>
        /// Name of the identity column
        /// </summary>
        public string Identity = "";

        /// <summary>
        /// List of columns that are serialized and send to the browser
        /// </summary>
        public clsColumn[] Serialitzar = null;

        /// <summary>
        /// List of columns that are deserialized when values arrive from the browser
        /// </summary>
        public clsColumn[] Deserialitzar = null;

        //SP Cache name, usually changes from project to project.
        //It must have the following parameters: Tablename varchar(50) and URL varchar(500)
        private string SP_Cache = "DI_EXP_CACHE_DEL";
}