public class AccountController : System.Web.Mvc.Controller{ \n public System.Web.Mvc.ActionResult Index(){\n List<object> list = new List<Object>();\n\n HttpContext.Cache[\"ObjectList\"] = list; \/\/ add\n list = (List<object>)HttpContext.Cache[\"ObjectList\"]; \/\/ retrieve\n HttpContext.Cache.Remove(\"ObjectList\"); \/\/ remove\n return new System.Web.Mvc.EmptyResult();\n }\n}<\/pre><\/div>\n\n\n\n<\/p>\n\n\n\n
2.HttpContext.Cache<\/h2>\n\n\n\n<\/div>\n\n\n\n![\"\"](\"https:\/\/www.auctionpro.co.kr\/wp-content\/uploads\/2023\/01\/image-5.png\")
<\/a><\/figure>\n\n\n\n3.DB<\/h2>\n\n\n\n![\"\"](\"https:\/\/www.auctionpro.co.kr\/wp-content\/uploads\/2023\/01\/image-6.png\")
<\/a><\/figure>\n\n\n\n4.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\n5.WebService Call<\/h2>\n\n\n\nusing System;\nusing System.Collections.Generic;\nusing System.Linq;\nusing System.Web;\nusing System.Web.Services;\nusing System.Data;\nusing System.Data.SqlClient;\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\n6.Cache Insert<\/h2>\n\n\n\nusing System;\nusing System.Collections.Generic;\nusing System.Linq;\nusing System.Web;\nusing System.Data;\nusing System.Data.SqlClient;\n\nnamespace WebService1\n{\n public class CacheClass\n { \n private static string connectionString = \"Server=SQLOLEDB.1;Password=******;Persist Security Info=True;User ID=MYID;Initial Catalog=MYDB;Data Source=MYPC\";\n\n public static DataSet GetCustomerDataSet()\n {\n \/\/ Check for cached item. \n DataSet ds = HttpContext.Current.Cache[\"Customers\"] as DataSet;\n if (ds == null)\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 Minutes). \n HttpContext.Current.Cache.Insert(\"Customers\", ds, null, DateTime.Now.AddMinutes(60), TimeSpan.Zero);\n }\n catch (Exception err)\n {\n System.Diagnostics.Debug.WriteLine(err.ToString());\n }\n finally\n {\n con.Close();\n }\n }\n return ds;\n }\n\n }\n}<\/pre><\/div>\n\n\n\n7.\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\n8.Result<\/h2>\n\n\n\n