Example #1
0
 /// <summary>
 /// Creates and runs a command to retrieve a DataTable using a stored procedure
 /// </summary>
 /// <param name="commandText">Stored procedure name</param>
 /// <param name="connection">Database connection (null for a new connection)</param>
 /// <param name="connectionStringName">Connection string name (must not be null if connection is null)</param>
 /// <param name="parameters">Bind parameters</param>
 /// <returns>DataTable with the query results</returns>
 public static DataTable RetrieveDataTableSP(string commandText, DBOracleConnection connection = null, string connectionStringName = null, params DBOracleParameter[] parameters)
 {
     using (var dbOracleMedatadataDAL = DBOracleMetadataDAL.Create(connection: connection, connectionStringName: connectionStringName))
     {
         return(dbOracleMedatadataDAL.RetrieveDataTableSP(commandText: commandText, parameters: parameters));
     }
 }
Example #2
0
        /// <summary>
        /// Get the length of a database column
        /// </summary>
        /// <param name="owner">Database owner</param>
        /// <param name="tableName">Table name</param>
        /// <param name="columnName">Column name</param>
        /// <param name="useCache">Use column length cache (default is true, use false only to detect changes in the database structure)</param>
        /// <param name="connection">Database connection (null for a new connection)</param>
        /// <param name="connectionStringName">Connection string name (must not be null if connection is null)</param>
        /// <returns>The length of the database column; null if the owner, the table or the column does not exist</returns>
        public static int?GetColumnLength(string owner, string tableName, string columnName, bool useCache = true, DBOracleConnection connection = null, string connectionStringName = null)
        {
            if (!useCache)
            {
                using (var dbOracleMedatadataDAL = DBOracleMetadataDAL.Create(connection: connection, connectionStringName: connectionStringName))
                {
                    return(dbOracleMedatadataDAL.GetColumnLength(owner: owner, tableName: tableName, columnName: columnName));
                }
            }

            owner = owner.ToUpper();

            if (!GetColumnLength_Cache.TryGetValue(owner, out var ownerCache))
            {
                using (var dbOracleMedatadataDAL = DBOracleMetadataDAL.Create(connection: connection, connectionStringName: connectionStringName))
                {
                    ownerCache = dbOracleMedatadataDAL.GetColumnLengthTable(owner);
                }

                lock (GetColumnLength_Lock)
                {
                    if (!GetColumnLength_Cache.TryGetValue(owner, out var ownerCacheAux))
                    {
                        var newCache = new Dictionary <string, Dictionary <string, Dictionary <string, int> > >(GetColumnLength_Cache);

                        newCache[owner] = ownerCache;

                        GetColumnLength_Cache = newCache;
                    }
                }
            }

            return(ownerCache.GetOrDefault(tableName.ToUpper())
                   ?.GetOrDefault(columnName.ToUpper()));
        }
Example #3
0
 /// <summary>
 /// Get next value from a database sequence
 /// </summary>
 /// <param name="owner">Database owner</param>
 /// <param name="sequenceName">Sequence name</param>
 /// <param name="connection">Database connection (null for a new connection)</param>
 /// <param name="connectionStringName">Connection string name (must not be null if connection is null)</param>
 /// <returns>The next value from a database sequence</returns>
 public static decimal GetSequenceNextValue(string owner, string sequenceName, DBOracleConnection connection = null, string connectionStringName = null)
 {
     using (var dbOracleMedatadataDAL = DBOracleMetadataDAL.Create(connection: connection, connectionStringName: connectionStringName))
     {
         return(dbOracleMedatadataDAL.GetSequenceNextValue(owner: owner, sequenceName: sequenceName));
     }
 }
Example #4
0
 /// <summary>
 /// Get the names of the indexes for a specified owner
 /// </summary>
 /// <param name="owner">Database owner</param>
 /// <param name="connection">Database connection (null for a new connection)</param>
 /// <param name="connectionStringName">Connection string name (must not be null if connection is null)</param>
 /// <returns>List of index names for the specified owner</returns>
 public static Dictionary <string, string> GetIndexes(string owner, DBOracleConnection connection = null, string connectionStringName = null)
 {
     using (var dbOracleMedatadataDAL = DBOracleMetadataDAL.Create(connection: connection, connectionStringName: connectionStringName))
     {
         return(dbOracleMedatadataDAL.GetIndexes(owner: owner));
     }
 }
Example #5
0
 /// <summary>
 /// Get the current database date/time
 /// </summary>
 /// <param name="connection">Database connection (null for a new connection)</param>
 /// <param name="connectionStringName">Connection string name (must not be null if connection is null)</param>
 /// <returns>The current database date/time</returns>
 public static DateTime GetDateTime(DBOracleConnection connection = null, string connectionStringName = null)
 {
     using (var dbOracleMedatadataDAL = DBOracleMetadataDAL.Create(connection: connection, connectionStringName: connectionStringName))
     {
         return(dbOracleMedatadataDAL.GetDateTime());
     }
 }
Example #6
0
 /// <summary>
 /// Get the creation script for an index
 /// </summary>
 /// <param name="owner">Database owner</param>
 /// <param name="indexName">Index name</param>
 /// <param name="connection">Database connection (null for a new connection)</param>
 /// <param name="connectionStringName">Connection string name (must not be null if connection is null)</param>
 /// <returns>The creation script for the specified index</returns>
 public static string GetCreationScriptIndex(string owner, string indexName, DBOracleConnection connection = null, string connectionStringName = null)
 {
     using (var dbOracleMedatadataDAL = DBOracleMetadataDAL.Create(connection: connection, connectionStringName: connectionStringName))
     {
         return(dbOracleMedatadataDAL.GetCreationScriptIndex(owner: owner, indexName: indexName));
     }
 }
Example #7
0
 /// <summary>
 /// Get the creation script for an object
 /// </summary>
 /// <param name="owner">Database owner</param>
 /// <param name="objectName">Object name</param>
 /// <param name="objectType">Object type (see Oracle documentation for valid values)</param>
 /// <param name="connection">Database connection (null for a new connection)</param>
 /// <param name="connectionStringName">Connection string name (must not be null if connection is null)</param>
 /// <returns>The creation script for the specified object</returns>
 public static string GetCreationScript(string owner, string objectName, string objectType, DBOracleConnection connection = null, string connectionStringName = null)
 {
     using (var dbOracleMedatadataDAL = DBOracleMetadataDAL.Create(connection: connection, connectionStringName: connectionStringName))
     {
         return(dbOracleMedatadataDAL.GetCreationScript(owner: owner, objectName: objectName, objectType: objectType));
     }
 }