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

Figure 4 Example of a Read-Through Handler for SQL Server

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

answer Figure 4 Example of a Read-Through Handler for SQL Server

Figure 4 Example of a Read-Through Handler for SQL Server

Comment

using System.Web.Caching; using System.Data.SqlClient; using Company.MyDistributedCache; ... public class SqlReadThruProvider : IReadhThruProvider { private SqlConnection _connection; // Called upon startup to initialize connection public void Start(IDictionary parameters) { _connection = new SqlConnection(parameters["connstring"]); _connection.Open(); } // Called at the end to close connection public void Stop() { _connection.Close(); } // Responsible for loading object from external data source public object Load(string key, ref CacheDependency dep) { string sql = "SELECT * FROM Customers WHERE "; sql += "CustomerID = @ID"; SqlCommand cmd = new SqlCommand(sql, _connection); cmd.Parameters.Add("@ID", System.Data.SqlDbType.VarChar); // Let's extract actual customerID from "key" int keyFormatLen = "Customers:CustomerID:".Length; string custId = key.Substring(keyFormatLen, key.Length - keyFormatLen); cmd.Parameters["@ID"].Value = custId; // fetch the row in the table SqlDataReader reader = cmd.ExecuteReader(); // copy data from "reader" to "cust" object Customers cust = new Customers(); FillCustomers(reader, cust); // specify a SqlCacheDependency for this object dep = new SqlCacheDependency(cmd); return cust; } }

Popularity 1/10 Helpfulness 1/10 Language sql

Source: medium.com

Tags: figure handler sql sql-server

Link to this answer
Share Copy Link

Contributed on Jun 24 2023

Sumit Rawal

0 Answers Avg Quality 2/10

Figure 4 Example of a Read-Through Handler for SQL Server

Contents

More Related Answers

Figure 4 Example of a Read-Through Handler for SQL Server

Grepper

Documentation

Social

Legal

Contact

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