{"id":8409,"date":"2023-02-07T15:14:00","date_gmt":"2023-02-07T06:14:00","guid":{"rendered":"https:\/\/www.auctionpro.co.kr\/?p=8409"},"modified":"2023-02-07T18:02:01","modified_gmt":"2023-02-07T09:02:01","slug":"memory-cache-datatable","status":"publish","type":"post","link":"https:\/\/www.auctionpro.co.kr\/?p=8409","title":{"rendered":"Memory Cache (DataTable)"},"content":{"rendered":"\n

Overview : DataTable \ub85c Cache \ud654 \ud574\ubcf4\uae30
<\/h2>\n\n\n\n

1.Net Framework 4.6 \uc774\uc0c1\uc5d0\uc11c \uc124\uce58\uac00\ub2a5<\/h2>\n\n\n\n
\"\"<\/a><\/figure>\n\n\n\n

2.\uc124\uce58<\/h2>\n\n\n\n

NuGet \ud328\uce90\uc9c0 \uad00\ub9ac\uc5d0\uc11c \uc124\uce58 \ubc0f \ucc38\uc870 \ucd94\uac00 \ud655\uc778<\/h3>\n\n\n\n
\"\"<\/a><\/figure>\n\n\n\n

3.\ucc38\uc870 \ud655\uc778<\/h2>\n\n\n\n
\"\"<\/a><\/figure>\n\n\n\n

4. Simple Source<\/h2>\n\n\n\n
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\n
5. Process diagram<\/h2>\n\n\n\n
\"\"<\/a><\/figure>\n\n\n\n
6.DB<\/h2>\n\n\n\n
\"\"<\/a><\/figure>\n\n\n\n
7. Insert Query<\/h2>\n\n\n\n
\ub9c1\ud06c : \ub9c1\ud06c :\u00a0https:\/\/github.com\/iammukeshm\/RepositoryPatternWithCachingAndHangfire\/blob\/master\/SampleCustomers.sql<\/a><\/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\n
8.WebService Call (DataTable)<\/h2>\n\n\n\n
using 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 DataTable 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();\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\n
9.Cache Insert (DataSet)<\/h2>\n\n\n\n
using System;\nusing System.Collections.Generic;\nusing System.Linq;\nusing System.Web;\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 DataTable GetCustomerDataSet()\n        {\n            \/\/ Check for cached item.         \n            \/\/DataSet ds = HttpContext.Current.Cache[\"Products\"] as DataSet;\n            \/\/_cache.Remove(_key);\n            \/\/if (!(_cache.Get(_key) is DataSet ds))\n            if (!_cache.Contains(_key))\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\n                DataTable ds = new DataTable();\n                ds.TableName = _key;\n\n                \/\/ Execute the command.             \n                try\n                {\n                    con.Open();\n                    adapter.Fill(ds);\n                    \/\/ Store the item in the cache (for 60 Minutes).                 \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 DataTable;\n        }\n\n    }\n}<\/pre><\/div>\n\n\n\n
\"\"<\/a>
DataSet<\/figcaption><\/figure>\n\n\n\n
10.\ud654\uba74<\/h2>\n\n\n\n
\"\"<\/a><\/figure>\n\n\n\n
11.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\n
12.Cache Insert advance<\/h2>\n\n\n\n
Multi Cache, stored procedure<\/strong><\/p>\n\n\n\n
using 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 DataTable GetCacheData(string _key)\n        {\n            if (!_cache.Contains(_key))\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(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            }\n\n            return _cache.Get(_key) as DataTable;\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":"
Overview : DataTable \ub85c Cache \ud654 \ud574\ubcf4\uae30 1.Net Framework 4.6 \uc774\uc0c1\uc5d0\uc11c \uc124\uce58\uac00\ub2a5 2.\uc124\uce58 NuGet \ud328\uce90\uc9c0 \uad00\ub9ac\uc5d0\uc11c \uc124\uce58 \ubc0f \ucc38\uc870 \ucd94\uac00 \ud655\uc778 3.\ucc38\uc870 \ud655\uc778 4. Simple […]<\/a><\/p>\n<\/div>","protected":false},"author":6,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[237],"tags":[],"class_list":["post-8409","post","type-post","status-publish","format-standard","hentry","category-memory-cache"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/8409","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=8409"}],"version-history":[{"count":0,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/8409\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=8409"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=8409"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=8409"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}