![\"\"](\"https:\/\/www.auctionpro.co.kr\/wp-content\/uploads\/2023\/01\/image-9.png\")
<\/a><\/figure>\n\n\n\n2.\uc124\uce58<\/h2>\n\n\n\nNuGet \ud328\uce90\uc9c0 \uad00\ub9ac\uc5d0\uc11c \uc124\uce58 \ubc0f \ucc38\uc870 \ucd94\uac00 \ud655\uc778<\/h3>\n\n\n\n![\"\"](\"https:\/\/www.auctionpro.co.kr\/wp-content\/uploads\/2023\/01\/image-8.png\")
<\/a><\/figure>\n\n\n\n3.\ucc38\uc870 \ud655\uc778<\/h2>\n\n\n\n![\"\"](\"https:\/\/www.auctionpro.co.kr\/wp-content\/uploads\/2023\/01\/image-11.png\")
<\/a><\/figure>\n\n\n\n4. Simple Source<\/h2>\n\n\n\nvar cache = new System.Runtime.Caching.MemoryCache(\"MyTestCache\");\ncache[\"ObjectList\"] = list; \/\/ add\nlist = (List<object>)cache[\"ObjectList\"]; \/\/ retrieve\ncache.Remove(\"ObjectList\"); \/\/ remove<\/pre><\/div>\n\n\n\n5. Process diagram<\/h2>\n\n\n\n![\"\"](\"https:\/\/www.auctionpro.co.kr\/wp-content\/uploads\/2023\/01\/image-12.png\")
<\/a><\/figure>\n\n\n\n6.DB<\/h2>\n\n\n\n![\"\"](\"https:\/\/www.auctionpro.co.kr\/wp-content\/uploads\/2023\/01\/image-6.png\")
<\/a><\/figure>\n\n\n\n7. Insert Query<\/h2>\n\n\n\n
\ub9c1\ud06c : https:\/\/github.com\/iammukeshm\/RepositoryPatternWithCachingAndHangfire\/blob\/master\/SampleCustomers.sql<\/p>\n\n\n\n
insert into Customers (FirstName, LastName, Contact, Email, DateOfBirth) values ('Caressa', 'Walsh', '868-449-3013', 'cwalsh0@google.es', '3\/23\/1996');\ninsert into Customers (FirstName, LastName, Contact, Email, DateOfBirth) values ('Rhea', 'Andrichuk', '733-892-8926', 'randrichuk1@elpais.com', '12\/11\/1997');\ninsert into Customers (FirstName, LastName, Contact, Email, DateOfBirth) values ('Amelia', 'Epp', '247-422-8619', 'aepp2@spiegel.de', '7\/16\/1999');\ninsert into Customers (FirstName, LastName, Contact, Email, DateOfBirth) values ('Cesaro', 'Goodwin', '606-804-3382', 'cgoodwin3@salon.com', '8\/16\/1990');\ninsert into Customers (FirstName, LastName, Contact, Email, DateOfBirth) values ('Lira', 'Crookall', '320-145-2453', 'lcrookall4@g.co', '9\/14\/1996');\ninsert into Customers (FirstName, LastName, Contact, Email, DateOfBirth) values ('Tye', 'Collin', '548-245-2593', 'tcollin5@dailymail.co.uk', '4\/9\/1993');\ninsert into Customers (FirstName, LastName, Contact, Email, DateOfBirth) values ('Clare', 'Kelson', '324-249-1362', 'ckelson6@amazon.co.jp', '11\/26\/1992');\ninsert into Customers (FirstName, LastName, Contact, Email, DateOfBirth) values ('Wilmer', 'Swaite', '657-532-9884', 'wswaite7@addthis.com', '9\/22\/1990');\ninsert into Customers (FirstName, LastName, Contact, Email, DateOfBirth) values ('Delphine', 'Gasson', '392-230-1556', 'dgasson8@51.la', '8\/7\/1994');\ninsert into Customers (FirstName, LastName, Contact, Email, DateOfBirth) values ('Manon', 'Yeowell', '789-838-9532', 'myeowell9@jimdo.com', '10\/11\/1999');<\/pre><\/div>\n\n\n\n8.WebService Call (DataSet)<\/h2>\n\n\n\n![\"\"](\"https:\/\/www.auctionpro.co.kr\/wp-content\/uploads\/2023\/02\/image-24-1024x637.png\")
<\/a><\/figure>\n\n\n\nusing System.Web.Services;\nusing System.Data;\n\nnamespace WebService1\n{ \n public class Service1 : System.Web.Services.WebService\n {\n\n [WebMethod()]\n public DataSet GetProductCatalog()\n {\n \/\/ Return the complete DataSet (from the cache, if possible). \n \/\/return Function.GetCache();\n return CacheClass.GetCustomerDataSet();\n }\n\n [WebMethod()]\n public string[] GetProductList()\n {\n \/\/ Get the customer table (from the cache if possible). \n DataTable dt = CacheClass.GetCustomerDataSet().Tables[0];\n \/\/ Create an array that will hold the name of each customer. \n string[] names = new string[dt.Rows.Count];\n \/\/ Fill the array. \n int i = 0;\n\n foreach (DataRow row in dt.Rows)\n {\n names[i] = row[\"FirstName\"].ToString();\n i += 1;\n }\n return names;\n }\n }\n}<\/pre><\/div>\n\n\n\n9.Cache Insert (DataSet)<\/h2>\n\n\n\nusing System;\nusing System.Data;\nusing System.Data.SqlClient;\nusing System.Runtime.Caching;\n\nnamespace WebService1\n{\n public class CacheClass\n {\n private static string _key = \"Customers\";\n private static readonly MemoryCache _cache = MemoryCache.Default;\n\n \/\/private static string connectionString = \"Data Source=localhost;\" + \"Initial Catalog=Northwind;user ID=sa\";\n private static string connectionString = \"Server=SQLOLEDB.1;Password=*******;Persist Security Info=True;User ID=MYID;Initial Catalog=MYDB;Data Source=MYCOM\";\n\n public static DataSet GetCustomerDataSet()\n {\n \/\/ Check for cached item. \n \/\/DataSet ds = HttpContext.Current.Cache[\"Customers\"] as DataSet;\n \/\/_cache.Remove(_key);\n if (!(_cache.Get(_key) is DataSet ds))\n {\n \/\/ Recreate the item. \n string SQL = \"SELECT * FROM Customers\";\n \/\/ Create ADO.NET objects. \n SqlConnection con = new SqlConnection(connectionString);\n SqlCommand com = new SqlCommand(SQL, con);\n SqlDataAdapter adapter = new SqlDataAdapter(com);\n ds = new DataSet();\n \/\/ Execute the command. \n try\n {\n con.Open();\n adapter.Fill(ds, \"Customers\");\n \/\/ Store the item in the cache (for 60 seconds). \n \/\/Do what you need to do here. Database Interaction, Serialization,etc.\n var cacheItemPolicy = new CacheItemPolicy()\n {\n \/\/Set your Cache expiration.\n AbsoluteExpiration = DateTime.Now.AddMinutes(60)\n };\n\n _cache.Add(_key, ds, cacheItemPolicy);\n\n }\n catch (Exception err)\n {\n System.Diagnostics.Debug.WriteLine(err.ToString());\n }\n finally\n {\n con.Close();\n }\n }\n return _cache.Get(_key) as DataSet;\n }\n\n }\n}<\/pre><\/div>\n\n\n\n![\"\"](\"https:\/\/www.auctionpro.co.kr\/wp-content\/uploads\/2023\/02\/image-19.png\")
<\/a>DataSet<\/figcaption><\/figure>\n\n\n\n10.\ud654\uba74<\/h2>\n\n\n\n![\"\"](\"https:\/\/www.auctionpro.co.kr\/wp-content\/uploads\/2023\/01\/image-7.png\")
<\/a><\/figure>\n\n\n\n11.Result<\/h2>\n\n\n\n<ArrayOfString xmlns:xsi=\"http:\/\/www.w3.org\/2001\/XMLSchema-instance\" xmlns:xsd=\"http:\/\/www.w3.org\/2001\/XMLSchema\" xmlns=\"http:\/\/tempuri.org\/\">\n<string>Caressa<\/string>\n<string>Rhea<\/string>\n<string>Amelia<\/string>\n<string>Cesaro<\/string>\n<string>Lira<\/string>\n<string>Tye<\/string>\n<string>Clare<\/string>\n<string>Wilmer<\/string>\n<string>Delphine<\/string>\n<string>Manon<\/string>\n<string>Bev<\/string>\n<string>Lodovico<\/string>\n<\/pre><\/div>\n\n\n\n12.Cache Insert advance<\/h2>\n\n\n\n
Multi Cache, stored procedure<\/strong><\/p>\n\n\n\nusing System;\nusing System.Data;\nusing System.Data.SqlClient;\nusing System.Runtime.Caching;\nusing System.Configuration;\n\nnamespace ConsoleHostRule\n{\n class CacheClass\n { \n private static readonly MemoryCache _cache = MemoryCache.Default;\n\n private static double CacheTime = double.Parse(ConfigurationManager.AppSettings[\"CacheTime\"]);\/\/CacheTime\n private static string connectionString = ConfigurationManager.ConnectionStrings[\"Customers\"].ToString();\/\/connectionString\n\n public static DataSet GetCacheData(string _key)\n {\n if (!(_cache.Get(_key) is DataSet ds))\n {\n ds = new DataSet();\n\n try\n {\n using (SqlConnection conn = new SqlConnection(connectionString))\n {\n SqlCommand cmd = conn.CreateCommand();\n cmd.Connection = conn;\n cmd.CommandType = CommandType.StoredProcedure;\n cmd.CommandText = \"cache_\" + _key; \/\/StoredProcedure Name\n SqlDataAdapter adapter = new SqlDataAdapter\n {\n SelectCommand = cmd\n };\n\n conn.Open();\n\n adapter.Fill(ds);\n cmd.Dispose();\n\n conn.Close();\n conn.Dispose();\n }\n\n var cacheItemPolicy = new CacheItemPolicy()\n {\n \/\/Set your Cache expiration.\n AbsoluteExpiration = DateTime.Now.AddMinutes(CacheTime)\n };\n\n _cache.Add(_key, ds, cacheItemPolicy);\n\n }\n catch (Exception err)\n {\n System.Diagnostics.Debug.WriteLine(err.ToString());\n }\n }\n\n return _cache.Get(_key) as DataSet;\n }\n\n }\n}<\/pre><\/div>\n\n\n\n<\/p>\n\n\n\n
source : https:\/\/stackoverflow.com\/questions\/41684213\/looking-for-a-very-simple-cache-example?utm_medium=organic&utm_source=google_rich_qa&utm_campaign=google_rich_qa<\/p>\n\n\n\n
\ucc38\uc870 : https:\/\/swconsulting.tistory.com\/801<\/p>\n","protected":false},"excerpt":{"rendered":"
<\/a><\/figure>\n\n\n\n3.\ucc38\uc870 \ud655\uc778<\/h2>\n\n\n\n<\/a><\/figure>\n\n\n\n4. Simple Source<\/h2>\n\n\n\nvar cache = new System.Runtime.Caching.MemoryCache(\"MyTestCache\");\ncache[\"ObjectList\"] = list; \/\/ add\nlist = (List<object>)cache[\"ObjectList\"]; \/\/ retrieve\ncache.Remove(\"ObjectList\"); \/\/ remove<\/pre><\/div>\n\n\n\n5. Process diagram<\/h2>\n\n\n\n<\/a><\/figure>\n\n\n\n6.DB<\/h2>\n\n\n\n<\/a><\/figure>\n\n\n\n7. Insert Query<\/h2>\n\n\n\n
\ub9c1\ud06c : https:\/\/github.com\/iammukeshm\/RepositoryPatternWithCachingAndHangfire\/blob\/master\/SampleCustomers.sql<\/p>\n\n\n\n
insert into Customers (FirstName, LastName, Contact, Email, DateOfBirth) values ('Caressa', 'Walsh', '868-449-3013', 'cwalsh0@google.es', '3\/23\/1996');\ninsert into Customers (FirstName, LastName, Contact, Email, DateOfBirth) values ('Rhea', 'Andrichuk', '733-892-8926', 'randrichuk1@elpais.com', '12\/11\/1997');\ninsert into Customers (FirstName, LastName, Contact, Email, DateOfBirth) values ('Amelia', 'Epp', '247-422-8619', 'aepp2@spiegel.de', '7\/16\/1999');\ninsert into Customers (FirstName, LastName, Contact, Email, DateOfBirth) values ('Cesaro', 'Goodwin', '606-804-3382', 'cgoodwin3@salon.com', '8\/16\/1990');\ninsert into Customers (FirstName, LastName, Contact, Email, DateOfBirth) values ('Lira', 'Crookall', '320-145-2453', 'lcrookall4@g.co', '9\/14\/1996');\ninsert into Customers (FirstName, LastName, Contact, Email, DateOfBirth) values ('Tye', 'Collin', '548-245-2593', 'tcollin5@dailymail.co.uk', '4\/9\/1993');\ninsert into Customers (FirstName, LastName, Contact, Email, DateOfBirth) values ('Clare', 'Kelson', '324-249-1362', 'ckelson6@amazon.co.jp', '11\/26\/1992');\ninsert into Customers (FirstName, LastName, Contact, Email, DateOfBirth) values ('Wilmer', 'Swaite', '657-532-9884', 'wswaite7@addthis.com', '9\/22\/1990');\ninsert into Customers (FirstName, LastName, Contact, Email, DateOfBirth) values ('Delphine', 'Gasson', '392-230-1556', 'dgasson8@51.la', '8\/7\/1994');\ninsert into Customers (FirstName, LastName, Contact, Email, DateOfBirth) values ('Manon', 'Yeowell', '789-838-9532', 'myeowell9@jimdo.com', '10\/11\/1999');<\/pre><\/div>\n\n\n\n8.WebService Call (DataSet)<\/h2>\n\n\n\n<\/a><\/figure>\n\n\n\nusing System.Web.Services;\nusing System.Data;\n\nnamespace WebService1\n{ \n public class Service1 : System.Web.Services.WebService\n {\n\n [WebMethod()]\n public DataSet GetProductCatalog()\n {\n \/\/ Return the complete DataSet (from the cache, if possible). \n \/\/return Function.GetCache();\n return CacheClass.GetCustomerDataSet();\n }\n\n [WebMethod()]\n public string[] GetProductList()\n {\n \/\/ Get the customer table (from the cache if possible). \n DataTable dt = CacheClass.GetCustomerDataSet().Tables[0];\n \/\/ Create an array that will hold the name of each customer. \n string[] names = new string[dt.Rows.Count];\n \/\/ Fill the array. \n int i = 0;\n\n foreach (DataRow row in dt.Rows)\n {\n names[i] = row[\"FirstName\"].ToString();\n i += 1;\n }\n return names;\n }\n }\n}<\/pre><\/div>\n\n\n\n9.Cache Insert (DataSet)<\/h2>\n\n\n\nusing System;\nusing System.Data;\nusing System.Data.SqlClient;\nusing System.Runtime.Caching;\n\nnamespace WebService1\n{\n public class CacheClass\n {\n private static string _key = \"Customers\";\n private static readonly MemoryCache _cache = MemoryCache.Default;\n\n \/\/private static string connectionString = \"Data Source=localhost;\" + \"Initial Catalog=Northwind;user ID=sa\";\n private static string connectionString = \"Server=SQLOLEDB.1;Password=*******;Persist Security Info=True;User ID=MYID;Initial Catalog=MYDB;Data Source=MYCOM\";\n\n public static DataSet GetCustomerDataSet()\n {\n \/\/ Check for cached item. \n \/\/DataSet ds = HttpContext.Current.Cache[\"Customers\"] as DataSet;\n \/\/_cache.Remove(_key);\n if (!(_cache.Get(_key) is DataSet ds))\n {\n \/\/ Recreate the item. \n string SQL = \"SELECT * FROM Customers\";\n \/\/ Create ADO.NET objects. \n SqlConnection con = new SqlConnection(connectionString);\n SqlCommand com = new SqlCommand(SQL, con);\n SqlDataAdapter adapter = new SqlDataAdapter(com);\n ds = new DataSet();\n \/\/ Execute the command. \n try\n {\n con.Open();\n adapter.Fill(ds, \"Customers\");\n \/\/ Store the item in the cache (for 60 seconds). \n \/\/Do what you need to do here. Database Interaction, Serialization,etc.\n var cacheItemPolicy = new CacheItemPolicy()\n {\n \/\/Set your Cache expiration.\n AbsoluteExpiration = DateTime.Now.AddMinutes(60)\n };\n\n _cache.Add(_key, ds, cacheItemPolicy);\n\n }\n catch (Exception err)\n {\n System.Diagnostics.Debug.WriteLine(err.ToString());\n }\n finally\n {\n con.Close();\n }\n }\n return _cache.Get(_key) as DataSet;\n }\n\n }\n}<\/pre><\/div>\n\n\n\n<\/a>DataSet<\/figcaption><\/figure>\n\n\n\n10.\ud654\uba74<\/h2>\n\n\n\n<\/a><\/figure>\n\n\n\n11.Result<\/h2>\n\n\n\n<ArrayOfString xmlns:xsi=\"http:\/\/www.w3.org\/2001\/XMLSchema-instance\" xmlns:xsd=\"http:\/\/www.w3.org\/2001\/XMLSchema\" xmlns=\"http:\/\/tempuri.org\/\">\n<string>Caressa<\/string>\n<string>Rhea<\/string>\n<string>Amelia<\/string>\n<string>Cesaro<\/string>\n<string>Lira<\/string>\n<string>Tye<\/string>\n<string>Clare<\/string>\n<string>Wilmer<\/string>\n<string>Delphine<\/string>\n<string>Manon<\/string>\n<string>Bev<\/string>\n<string>Lodovico<\/string>\n<\/pre><\/div>\n\n\n\n12.Cache Insert advance<\/h2>\n\n\n\n
Multi Cache, stored procedure<\/strong><\/p>\n\n\n\nusing System;\nusing System.Data;\nusing System.Data.SqlClient;\nusing System.Runtime.Caching;\nusing System.Configuration;\n\nnamespace ConsoleHostRule\n{\n class CacheClass\n { \n private static readonly MemoryCache _cache = MemoryCache.Default;\n\n private static double CacheTime = double.Parse(ConfigurationManager.AppSettings[\"CacheTime\"]);\/\/CacheTime\n private static string connectionString = ConfigurationManager.ConnectionStrings[\"Customers\"].ToString();\/\/connectionString\n\n public static DataSet GetCacheData(string _key)\n {\n if (!(_cache.Get(_key) is DataSet ds))\n {\n ds = new DataSet();\n\n try\n {\n using (SqlConnection conn = new SqlConnection(connectionString))\n {\n SqlCommand cmd = conn.CreateCommand();\n cmd.Connection = conn;\n cmd.CommandType = CommandType.StoredProcedure;\n cmd.CommandText = \"cache_\" + _key; \/\/StoredProcedure Name\n SqlDataAdapter adapter = new SqlDataAdapter\n {\n SelectCommand = cmd\n };\n\n conn.Open();\n\n adapter.Fill(ds);\n cmd.Dispose();\n\n conn.Close();\n conn.Dispose();\n }\n\n var cacheItemPolicy = new CacheItemPolicy()\n {\n \/\/Set your Cache expiration.\n AbsoluteExpiration = DateTime.Now.AddMinutes(CacheTime)\n };\n\n _cache.Add(_key, ds, cacheItemPolicy);\n\n }\n catch (Exception err)\n {\n System.Diagnostics.Debug.WriteLine(err.ToString());\n }\n }\n\n return _cache.Get(_key) as DataSet;\n }\n\n }\n}<\/pre><\/div>\n\n\n\n<\/p>\n\n\n\n
source : https:\/\/stackoverflow.com\/questions\/41684213\/looking-for-a-very-simple-cache-example?utm_medium=organic&utm_source=google_rich_qa&utm_campaign=google_rich_qa<\/p>\n\n\n\n
\ucc38\uc870 : https:\/\/swconsulting.tistory.com\/801<\/p>\n","protected":false},"excerpt":{"rendered":"
<\/a><\/figure>\n\n\n\n4. Simple Source<\/h2>\n\n\n\nvar cache = new System.Runtime.Caching.MemoryCache(\"MyTestCache\");\ncache[\"ObjectList\"] = list; \/\/ add\nlist = (List<object>)cache[\"ObjectList\"]; \/\/ retrieve\ncache.Remove(\"ObjectList\"); \/\/ remove<\/pre><\/div>\n\n\n\n5. Process diagram<\/h2>\n\n\n\n<\/a><\/figure>\n\n\n\n6.DB<\/h2>\n\n\n\n<\/a><\/figure>\n\n\n\n7. Insert Query<\/h2>\n\n\n\n
\ub9c1\ud06c : https:\/\/github.com\/iammukeshm\/RepositoryPatternWithCachingAndHangfire\/blob\/master\/SampleCustomers.sql<\/p>\n\n\n\n
insert into Customers (FirstName, LastName, Contact, Email, DateOfBirth) values ('Caressa', 'Walsh', '868-449-3013', 'cwalsh0@google.es', '3\/23\/1996');\ninsert into Customers (FirstName, LastName, Contact, Email, DateOfBirth) values ('Rhea', 'Andrichuk', '733-892-8926', 'randrichuk1@elpais.com', '12\/11\/1997');\ninsert into Customers (FirstName, LastName, Contact, Email, DateOfBirth) values ('Amelia', 'Epp', '247-422-8619', 'aepp2@spiegel.de', '7\/16\/1999');\ninsert into Customers (FirstName, LastName, Contact, Email, DateOfBirth) values ('Cesaro', 'Goodwin', '606-804-3382', 'cgoodwin3@salon.com', '8\/16\/1990');\ninsert into Customers (FirstName, LastName, Contact, Email, DateOfBirth) values ('Lira', 'Crookall', '320-145-2453', 'lcrookall4@g.co', '9\/14\/1996');\ninsert into Customers (FirstName, LastName, Contact, Email, DateOfBirth) values ('Tye', 'Collin', '548-245-2593', 'tcollin5@dailymail.co.uk', '4\/9\/1993');\ninsert into Customers (FirstName, LastName, Contact, Email, DateOfBirth) values ('Clare', 'Kelson', '324-249-1362', 'ckelson6@amazon.co.jp', '11\/26\/1992');\ninsert into Customers (FirstName, LastName, Contact, Email, DateOfBirth) values ('Wilmer', 'Swaite', '657-532-9884', 'wswaite7@addthis.com', '9\/22\/1990');\ninsert into Customers (FirstName, LastName, Contact, Email, DateOfBirth) values ('Delphine', 'Gasson', '392-230-1556', 'dgasson8@51.la', '8\/7\/1994');\ninsert into Customers (FirstName, LastName, Contact, Email, DateOfBirth) values ('Manon', 'Yeowell', '789-838-9532', 'myeowell9@jimdo.com', '10\/11\/1999');<\/pre><\/div>\n\n\n\n8.WebService Call (DataSet)<\/h2>\n\n\n\n<\/a><\/figure>\n\n\n\nusing System.Web.Services;\nusing System.Data;\n\nnamespace WebService1\n{ \n public class Service1 : System.Web.Services.WebService\n {\n\n [WebMethod()]\n public DataSet GetProductCatalog()\n {\n \/\/ Return the complete DataSet (from the cache, if possible). \n \/\/return Function.GetCache();\n return CacheClass.GetCustomerDataSet();\n }\n\n [WebMethod()]\n public string[] GetProductList()\n {\n \/\/ Get the customer table (from the cache if possible). \n DataTable dt = CacheClass.GetCustomerDataSet().Tables[0];\n \/\/ Create an array that will hold the name of each customer. \n string[] names = new string[dt.Rows.Count];\n \/\/ Fill the array. \n int i = 0;\n\n foreach (DataRow row in dt.Rows)\n {\n names[i] = row[\"FirstName\"].ToString();\n i += 1;\n }\n return names;\n }\n }\n}<\/pre><\/div>\n\n\n\n9.Cache Insert (DataSet)<\/h2>\n\n\n\nusing System;\nusing System.Data;\nusing System.Data.SqlClient;\nusing System.Runtime.Caching;\n\nnamespace WebService1\n{\n public class CacheClass\n {\n private static string _key = \"Customers\";\n private static readonly MemoryCache _cache = MemoryCache.Default;\n\n \/\/private static string connectionString = \"Data Source=localhost;\" + \"Initial Catalog=Northwind;user ID=sa\";\n private static string connectionString = \"Server=SQLOLEDB.1;Password=*******;Persist Security Info=True;User ID=MYID;Initial Catalog=MYDB;Data Source=MYCOM\";\n\n public static DataSet GetCustomerDataSet()\n {\n \/\/ Check for cached item. \n \/\/DataSet ds = HttpContext.Current.Cache[\"Customers\"] as DataSet;\n \/\/_cache.Remove(_key);\n if (!(_cache.Get(_key) is DataSet ds))\n {\n \/\/ Recreate the item. \n string SQL = \"SELECT * FROM Customers\";\n \/\/ Create ADO.NET objects. \n SqlConnection con = new SqlConnection(connectionString);\n SqlCommand com = new SqlCommand(SQL, con);\n SqlDataAdapter adapter = new SqlDataAdapter(com);\n ds = new DataSet();\n \/\/ Execute the command. \n try\n {\n con.Open();\n adapter.Fill(ds, \"Customers\");\n \/\/ Store the item in the cache (for 60 seconds). \n \/\/Do what you need to do here. Database Interaction, Serialization,etc.\n var cacheItemPolicy = new CacheItemPolicy()\n {\n \/\/Set your Cache expiration.\n AbsoluteExpiration = DateTime.Now.AddMinutes(60)\n };\n\n _cache.Add(_key, ds, cacheItemPolicy);\n\n }\n catch (Exception err)\n {\n System.Diagnostics.Debug.WriteLine(err.ToString());\n }\n finally\n {\n con.Close();\n }\n }\n return _cache.Get(_key) as DataSet;\n }\n\n }\n}<\/pre><\/div>\n\n\n\n<\/a>DataSet<\/figcaption><\/figure>\n\n\n\n10.\ud654\uba74<\/h2>\n\n\n\n<\/a><\/figure>\n\n\n\n11.Result<\/h2>\n\n\n\n<ArrayOfString xmlns:xsi=\"http:\/\/www.w3.org\/2001\/XMLSchema-instance\" xmlns:xsd=\"http:\/\/www.w3.org\/2001\/XMLSchema\" xmlns=\"http:\/\/tempuri.org\/\">\n<string>Caressa<\/string>\n<string>Rhea<\/string>\n<string>Amelia<\/string>\n<string>Cesaro<\/string>\n<string>Lira<\/string>\n<string>Tye<\/string>\n<string>Clare<\/string>\n<string>Wilmer<\/string>\n<string>Delphine<\/string>\n<string>Manon<\/string>\n<string>Bev<\/string>\n<string>Lodovico<\/string>\n<\/pre><\/div>\n\n\n\n12.Cache Insert advance<\/h2>\n\n\n\n
Multi Cache, stored procedure<\/strong><\/p>\n\n\n\nusing System;\nusing System.Data;\nusing System.Data.SqlClient;\nusing System.Runtime.Caching;\nusing System.Configuration;\n\nnamespace ConsoleHostRule\n{\n class CacheClass\n { \n private static readonly MemoryCache _cache = MemoryCache.Default;\n\n private static double CacheTime = double.Parse(ConfigurationManager.AppSettings[\"CacheTime\"]);\/\/CacheTime\n private static string connectionString = ConfigurationManager.ConnectionStrings[\"Customers\"].ToString();\/\/connectionString\n\n public static DataSet GetCacheData(string _key)\n {\n if (!(_cache.Get(_key) is DataSet ds))\n {\n ds = new DataSet();\n\n try\n {\n using (SqlConnection conn = new SqlConnection(connectionString))\n {\n SqlCommand cmd = conn.CreateCommand();\n cmd.Connection = conn;\n cmd.CommandType = CommandType.StoredProcedure;\n cmd.CommandText = \"cache_\" + _key; \/\/StoredProcedure Name\n SqlDataAdapter adapter = new SqlDataAdapter\n {\n SelectCommand = cmd\n };\n\n conn.Open();\n\n adapter.Fill(ds);\n cmd.Dispose();\n\n conn.Close();\n conn.Dispose();\n }\n\n var cacheItemPolicy = new CacheItemPolicy()\n {\n \/\/Set your Cache expiration.\n AbsoluteExpiration = DateTime.Now.AddMinutes(CacheTime)\n };\n\n _cache.Add(_key, ds, cacheItemPolicy);\n\n }\n catch (Exception err)\n {\n System.Diagnostics.Debug.WriteLine(err.ToString());\n }\n }\n\n return _cache.Get(_key) as DataSet;\n }\n\n }\n}<\/pre><\/div>\n\n\n\n<\/p>\n\n\n\n
source : https:\/\/stackoverflow.com\/questions\/41684213\/looking-for-a-very-simple-cache-example?utm_medium=organic&utm_source=google_rich_qa&utm_campaign=google_rich_qa<\/p>\n\n\n\n
\ucc38\uc870 : https:\/\/swconsulting.tistory.com\/801<\/p>\n","protected":false},"excerpt":{"rendered":"
var cache = new System.Runtime.Caching.MemoryCache(\"MyTestCache\");\ncache[\"ObjectList\"] = list; \/\/ add\nlist = (List<object>)cache[\"ObjectList\"]; \/\/ retrieve\ncache.Remove(\"ObjectList\"); \/\/ remove<\/pre><\/div>\n\n\n\n5. Process diagram<\/h2>\n\n\n\n<\/a><\/figure>\n\n\n\n6.DB<\/h2>\n\n\n\n<\/a><\/figure>\n\n\n\n7. Insert Query<\/h2>\n\n\n\n
\ub9c1\ud06c : https:\/\/github.com\/iammukeshm\/RepositoryPatternWithCachingAndHangfire\/blob\/master\/SampleCustomers.sql<\/p>\n\n\n\n
insert into Customers (FirstName, LastName, Contact, Email, DateOfBirth) values ('Caressa', 'Walsh', '868-449-3013', 'cwalsh0@google.es', '3\/23\/1996');\ninsert into Customers (FirstName, LastName, Contact, Email, DateOfBirth) values ('Rhea', 'Andrichuk', '733-892-8926', 'randrichuk1@elpais.com', '12\/11\/1997');\ninsert into Customers (FirstName, LastName, Contact, Email, DateOfBirth) values ('Amelia', 'Epp', '247-422-8619', 'aepp2@spiegel.de', '7\/16\/1999');\ninsert into Customers (FirstName, LastName, Contact, Email, DateOfBirth) values ('Cesaro', 'Goodwin', '606-804-3382', 'cgoodwin3@salon.com', '8\/16\/1990');\ninsert into Customers (FirstName, LastName, Contact, Email, DateOfBirth) values ('Lira', 'Crookall', '320-145-2453', 'lcrookall4@g.co', '9\/14\/1996');\ninsert into Customers (FirstName, LastName, Contact, Email, DateOfBirth) values ('Tye', 'Collin', '548-245-2593', 'tcollin5@dailymail.co.uk', '4\/9\/1993');\ninsert into Customers (FirstName, LastName, Contact, Email, DateOfBirth) values ('Clare', 'Kelson', '324-249-1362', 'ckelson6@amazon.co.jp', '11\/26\/1992');\ninsert into Customers (FirstName, LastName, Contact, Email, DateOfBirth) values ('Wilmer', 'Swaite', '657-532-9884', 'wswaite7@addthis.com', '9\/22\/1990');\ninsert into Customers (FirstName, LastName, Contact, Email, DateOfBirth) values ('Delphine', 'Gasson', '392-230-1556', 'dgasson8@51.la', '8\/7\/1994');\ninsert into Customers (FirstName, LastName, Contact, Email, DateOfBirth) values ('Manon', 'Yeowell', '789-838-9532', 'myeowell9@jimdo.com', '10\/11\/1999');<\/pre><\/div>\n\n\n\n8.WebService Call (DataSet)<\/h2>\n\n\n\n<\/a><\/figure>\n\n\n\nusing System.Web.Services;\nusing System.Data;\n\nnamespace WebService1\n{ \n public class Service1 : System.Web.Services.WebService\n {\n\n [WebMethod()]\n public DataSet GetProductCatalog()\n {\n \/\/ Return the complete DataSet (from the cache, if possible). \n \/\/return Function.GetCache();\n return CacheClass.GetCustomerDataSet();\n }\n\n [WebMethod()]\n public string[] GetProductList()\n {\n \/\/ Get the customer table (from the cache if possible). \n DataTable dt = CacheClass.GetCustomerDataSet().Tables[0];\n \/\/ Create an array that will hold the name of each customer. \n string[] names = new string[dt.Rows.Count];\n \/\/ Fill the array. \n int i = 0;\n\n foreach (DataRow row in dt.Rows)\n {\n names[i] = row[\"FirstName\"].ToString();\n i += 1;\n }\n return names;\n }\n }\n}<\/pre><\/div>\n\n\n\n9.Cache Insert (DataSet)<\/h2>\n\n\n\nusing System;\nusing System.Data;\nusing System.Data.SqlClient;\nusing System.Runtime.Caching;\n\nnamespace WebService1\n{\n public class CacheClass\n {\n private static string _key = \"Customers\";\n private static readonly MemoryCache _cache = MemoryCache.Default;\n\n \/\/private static string connectionString = \"Data Source=localhost;\" + \"Initial Catalog=Northwind;user ID=sa\";\n private static string connectionString = \"Server=SQLOLEDB.1;Password=*******;Persist Security Info=True;User ID=MYID;Initial Catalog=MYDB;Data Source=MYCOM\";\n\n public static DataSet GetCustomerDataSet()\n {\n \/\/ Check for cached item. \n \/\/DataSet ds = HttpContext.Current.Cache[\"Customers\"] as DataSet;\n \/\/_cache.Remove(_key);\n if (!(_cache.Get(_key) is DataSet ds))\n {\n \/\/ Recreate the item. \n string SQL = \"SELECT * FROM Customers\";\n \/\/ Create ADO.NET objects. \n SqlConnection con = new SqlConnection(connectionString);\n SqlCommand com = new SqlCommand(SQL, con);\n SqlDataAdapter adapter = new SqlDataAdapter(com);\n ds = new DataSet();\n \/\/ Execute the command. \n try\n {\n con.Open();\n adapter.Fill(ds, \"Customers\");\n \/\/ Store the item in the cache (for 60 seconds). \n \/\/Do what you need to do here. Database Interaction, Serialization,etc.\n var cacheItemPolicy = new CacheItemPolicy()\n {\n \/\/Set your Cache expiration.\n AbsoluteExpiration = DateTime.Now.AddMinutes(60)\n };\n\n _cache.Add(_key, ds, cacheItemPolicy);\n\n }\n catch (Exception err)\n {\n System.Diagnostics.Debug.WriteLine(err.ToString());\n }\n finally\n {\n con.Close();\n }\n }\n return _cache.Get(_key) as DataSet;\n }\n\n }\n}<\/pre><\/div>\n\n\n\n<\/a>DataSet<\/figcaption><\/figure>\n\n\n\n10.\ud654\uba74<\/h2>\n\n\n\n<\/a><\/figure>\n\n\n\n11.Result<\/h2>\n\n\n\n<ArrayOfString xmlns:xsi=\"http:\/\/www.w3.org\/2001\/XMLSchema-instance\" xmlns:xsd=\"http:\/\/www.w3.org\/2001\/XMLSchema\" xmlns=\"http:\/\/tempuri.org\/\">\n<string>Caressa<\/string>\n<string>Rhea<\/string>\n<string>Amelia<\/string>\n<string>Cesaro<\/string>\n<string>Lira<\/string>\n<string>Tye<\/string>\n<string>Clare<\/string>\n<string>Wilmer<\/string>\n<string>Delphine<\/string>\n<string>Manon<\/string>\n<string>Bev<\/string>\n<string>Lodovico<\/string>\n<\/pre><\/div>\n\n\n\n12.Cache Insert advance<\/h2>\n\n\n\n
Multi Cache, stored procedure<\/strong><\/p>\n\n\n\nusing System;\nusing System.Data;\nusing System.Data.SqlClient;\nusing System.Runtime.Caching;\nusing System.Configuration;\n\nnamespace ConsoleHostRule\n{\n class CacheClass\n { \n private static readonly MemoryCache _cache = MemoryCache.Default;\n\n private static double CacheTime = double.Parse(ConfigurationManager.AppSettings[\"CacheTime\"]);\/\/CacheTime\n private static string connectionString = ConfigurationManager.ConnectionStrings[\"Customers\"].ToString();\/\/connectionString\n\n public static DataSet GetCacheData(string _key)\n {\n if (!(_cache.Get(_key) is DataSet ds))\n {\n ds = new DataSet();\n\n try\n {\n using (SqlConnection conn = new SqlConnection(connectionString))\n {\n SqlCommand cmd = conn.CreateCommand();\n cmd.Connection = conn;\n cmd.CommandType = CommandType.StoredProcedure;\n cmd.CommandText = \"cache_\" + _key; \/\/StoredProcedure Name\n SqlDataAdapter adapter = new SqlDataAdapter\n {\n SelectCommand = cmd\n };\n\n conn.Open();\n\n adapter.Fill(ds);\n cmd.Dispose();\n\n conn.Close();\n conn.Dispose();\n }\n\n var cacheItemPolicy = new CacheItemPolicy()\n {\n \/\/Set your Cache expiration.\n AbsoluteExpiration = DateTime.Now.AddMinutes(CacheTime)\n };\n\n _cache.Add(_key, ds, cacheItemPolicy);\n\n }\n catch (Exception err)\n {\n System.Diagnostics.Debug.WriteLine(err.ToString());\n }\n }\n\n return _cache.Get(_key) as DataSet;\n }\n\n }\n}<\/pre><\/div>\n\n\n\n<\/p>\n\n\n\n
source : https:\/\/stackoverflow.com\/questions\/41684213\/looking-for-a-very-simple-cache-example?utm_medium=organic&utm_source=google_rich_qa&utm_campaign=google_rich_qa<\/p>\n\n\n\n
\ucc38\uc870 : https:\/\/swconsulting.tistory.com\/801<\/p>\n","protected":false},"excerpt":{"rendered":"