Breaking News: Grepper is joining You.com. Read the official announcement!

Figure 3 Using SqlDependency to Synchronize with a Relational Database

Sumit Rawal answered on June 24, 2023 Popularity 1/10 Helpfulness 1/10

answer Figure 3 Using SqlDependency to Synchronize with a Relational Database

Figure 3 Using SqlDependency to Synchronize with a Relational Database

Comment

using System.Web.Caching; using System.Data.SqlClient; ... public void CreateSqlDependency(Customers cust, SqlConnection conn) { // Make cust dependent on a corresponding row in the // Customers table in Northwind database string sql = "SELECT CustomerID FROM Customers WHERE "; sql += "CustomerID = @ID"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.Add("@ID", System.Data.SqlDbType.VarChar); cmd.Parameters["@ID"].Value = cust.CustomerID; SqlCacheDependency dep = new SqlCacheDependency(cmd); string key = "Customers:CustomerID:" + cust.CustomerID; Cache.Insert(key, cust, dep); }

Popularity 1/10 Helpfulness 1/10 Language sql

Source: medium.com

Tags: figure relational-database sql sqldependency synchronize using

Link to this answer
Share Copy Link

Contributed on Jun 24 2023

Sumit Rawal

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

Figure 3 Using SqlDependency to Synchronize with a Relational Database

Contents

More Related Answers

Figure 3 Using SqlDependency to Synchronize with a Relational Database

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.