Try Playground
Show / Hide Table of Contents

Constructor SqlCacheDependency

SqlCacheDependency(String, String)

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

Declaration
public SqlCacheDependency(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 at the data source.

Remarks

This constructor is used to create SqlCacheDependency objects that use the query-notification feature of SQL Server 2005 products.

SQL query must include the following:

SqlCacheDependency(String, String, SqlCommandType, Dictionary<String, SqlCmdParams>)

Initializes a new instance of the SqlCacheDependency class. It supports the use of 'Stored Procedures'.

Declaration
public SqlCacheDependency(string connectionString, string cmdText, SqlCommandType cmdType, Dictionary<string, SqlCmdParams> cmdParams)
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.

SqlCommandType cmdType

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

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

Parameters to be passed to the command.

Remarks

This constructor is used to create SqlCacheDependency objects that use the query-notification feature of SQL Server 2005 products.

SQL query must include the following:

  1. 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 SQL statement must refer to "dbo.customers".
  2. Explicit column names in the Select statement. You cannot use the asterisk (*) wildcard character to select all columns from a table. For example, instead of "select * from customers", you must use "select name, address, city, state from dbo.customers".

Contact Us

PHONE

+1 (214) 764-6933   (US)

+44 20 7993 8327   (UK)

 
EMAIL

sales@alachisoft.com

support@alachisoft.com

NCache
  • NCache Enterprise
  • NCache Professional
  • 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