Example #1
0
        /// <summary>
        /// Executes the sentence SQL fixing the parameters needed.
        /// </summary>
        /// <param name="onSql">Sentence SQL to be executed</param>
        public object Execute(ONSql onSql)
        {
            ArrayList lSqlParameters;
            string lSql = onSql.GenerateSQL(out lSqlParameters);

            if (onSql is ONSqlScalar)
                return ExecuteScalar(lSql, lSqlParameters);
            else if (onSql is ONSqlSelect)
                return ExecuteReader(lSql, lSqlParameters);
            else if (onSql is ONSqlInsertAutoInc)
                return ExecuteInsertAutoIncScalar(lSql, lSqlParameters);
            else
                ExecuteNonQuery(lSql, lSqlParameters);

            return null;
        }