• Facebook
  • Twitter
  • Youtube
  • LinedIn
  • RSS
  • Docs
  • Comparisons
  • Blogs
  • Download
  • Contact Us
Download
Show / Hide Table of Contents

Class OracleCacheDependency

Establishes a relationship between an item stored in an application's cache object and either a row in a specific Oracle database table or the results of an Oracle query. This class cannot be inherited.

Inheritance
System.Object
CacheDependency
OracleCacheDependency
Inherited Members
CacheDependency.sizeInBytes
CacheDependency.DEPENDENCY_TYPE_OVERHEAD
CacheDependency.DEPENDENCY_COUNT_OVERHEAD
CacheDependency.AddDependencies(CacheDependency[])
CacheDependency.Dependencies
CacheDependency.Dispose()
CacheDependency.DependencyDispose()
Assembly: Alachisoft.NCache.Runtime.dll
Syntax
[Serializable]
public sealed class OracleCacheDependency : CacheDependency, IDisposable, IBinaryProtocolSerializable
Remarks

You can add items with dependencies to your application's cache with the Add, Insert or AddDependency methods.

When you add an item to an application's cache object with OracleCacheDependency, on all ODP.NET supported versions of Oracle database, it monitors a row in a specific Oracle database table so that when that row changes, items associated with the row will be automatically removed from the cache.
This helps you to avoid losing changes made to the object between the time it is created and the time it is inserted into the cache. OracleCacheDependency class supports the association of cached items with an Oracle query.

Constructors

OracleCacheDependency(String, String)

Initializes a new instance of the OracleCacheDependency class, using the supplied connection string and query string.

Declaration
public OracleCacheDependency(string connectionString, string cmdText)
Parameters
Type Name Description
System.String connectionString

Connection string to be used by the dependency.

System.String cmdText

SQL statement, table name or stored procedure to execute on the data source.

Remarks

This constructor is used to create OracleCacheDependency objects which use the query-notification feature of Oracle products.

Query must include the following: Fully qualified table names, including the name of the table owner. For example, to refer to a table called "customers" that is owned by the database owner, the statement must refer to "dbo.customers".

OracleCacheDependency(String, String, OracleCommandType, Dictionary<String, OracleCmdParams>)

Initializes a new instance of the OracleCacheDependency class. It supports the use of stored procedures.

Declaration
public OracleCacheDependency(string connectionString, string cmdText, OracleCommandType cmdType, Dictionary<string, OracleCmdParams> cmdParams)
Parameters
Type Name Description
System.String connectionString

Connection string to be used by dependency.

System.String cmdText

SQL statement, table name or stored procedure to execute on the data source.

OracleCommandType cmdType

The type of the command (text/stored procedures).

System.Collections.Generic.Dictionary<System.String, OracleCmdParams> cmdParams

Parameters to be passed to the command.

Remarks

This constructor is used to create OracleCacheDependency objects that use the query-notification feature of Oracle products.

Query must include the fully qualified table names, including the name of the table owner. For example, to refer to a table called "customers" that is owned by the database owner, the statement must refer to "dbo.customers".

Properties

CommandParams

Describes the type of the parameters passed to the Oracle command.

Declaration
public Dictionary<string, OracleCmdParams> CommandParams { get; set; }
Property Value
Type Description
System.Collections.Generic.Dictionary<System.String, OracleCmdParams>

CommandText

CommandText to be used by the dependency.

Declaration
public string CommandText { get; set; }
Property Value
Type Description
System.String

CommandText to be used by the dependency.

CommandType

Describes the type of the Oracle command passed to the OracleDependency.

Declaration
public CommandType CommandType { get; set; }
Property Value
Type Description
System.Data.CommandType

The type and value of the parameters passed to the command instance.

ConnectionString

Connection String that is required by the cache in order to connect with database.

Declaration
public string ConnectionString { get; set; }
Property Value
Type Description
System.String

Connection String that is required by the cache in order to connect with database

Contact Us

PHONE

+1 (214) 764-6933   (US)

+44 20 7993 8327   (UK)

 
EMAIL

sales@alachisoft.com

support@alachisoft.com

NCache
  • NCache Enterprise
  • NCache Community
  • Edition Comparison
  • NCache Architecture
  • Benchmarks
Download
Pricing
Try Playground

Deployments
  • Cloud (SaaS & Software)
  • On-Premises
  • Kubernetes
  • Docker
Technical Use Cases
  • ASP.NET Sessions
  • ASP.NET Core Sessions
  • Pub/Sub Messaging
  • Real-Time ASP.NET SignalR
  • Internet of Things (IoT)
  • NoSQL Database
  • Stream Processing
  • Microservices
Resources
  • Magazine Articles
  • Third-Party Articles
  • Articles
  • Videos
  • Whitepapers
  • Shows
  • Talks
  • Blogs
  • Docs
Customer Case Studies
  • Testimonials
  • Customers
Support
  • Schedule a Demo
  • Forum (Google Groups)
  • Tips
Company
  • Leadership
  • Partners
  • News
  • Events
  • Careers
Contact Us

  • EnglishChinese (Simplified)FrenchGermanItalianJapaneseKoreanPortugueseSpanish

  • Contact Us
  •  
  • Sitemap
  •  
  • Terms of Use
  •  
  • Privacy Policy
© Copyright Alachisoft 2002 - . All rights reserved. NCache is a registered trademark of Diyatech Corp.
Back to top