private static void HttpRuntimeCache() { ICacheService myCache = new HttpRuntimeCache();//ICacheService SqlSugarClient db = new SqlSugarClient(new ConnectionConfig() { ConnectionString = Config.ConnectionString, DbType = DbType.SqlServer, IsAutoCloseConnection = true, ConfigureExternalServices = new ConfigureExternalServices() { DataInfoCacheService = myCache //Setting external cache service } }); for (int i = 0; i < 10000; i++) { db.Queryable <Student>().Where(it => it.Id > 0).WithCache().ToList(); } db.Queryable <Student, Student>((s1, s2) => s1.Id == s2.Id).Select(s1 => s1).WithCache().ToList(); db.Queryable <Student, Student>((s1, s2) => new object[] { JoinType.Left, s1.Id == s2.Id }).Select(s1 => s1).WithCache().ToList(); Console.WriteLine("Cache Key Count:" + myCache.GetAllKey <string>().Count()); foreach (var item in myCache.GetAllKey <string>()) { Console.WriteLine(); Console.WriteLine(item); Console.WriteLine(); } db.Deleteable <Student>().Where(it => it.Id == 1).RemoveDataCache().ExecuteCommand(); Console.WriteLine("Cache Key Count:" + myCache.GetAllKey <string>().Count()); }
private static void HttpRuntimeCache() { ICacheService myCache = new HttpRuntimeCache();//ICacheService SqlSugarClient db = new SqlSugarClient(new ConnectionConfig() { ConnectionString = Config.ConnectionString, DbType = DbType.SqlServer, IsAutoCloseConnection = true, ConfigureExternalServices = new ConfigureExternalServices() { DataInfoCacheService = myCache //Setting external cache service } }); db.Aop.OnLogExecuted = (s, p) => { Console.WriteLine(s); }; db.CodeFirst.InitTables <Student>(); db.Insertable(new Student() { CreateTime = DateTime.Now, Name = "a", SchoolId = 0 }).ExecuteCommand(); var x = db.Queryable <Student>().WithCache().ToDictionaryList(); // db.Queryable<Student>().Select("1 as idx").WithCache().ToList(); Console.WriteLine("Cache Key Count:" + myCache.GetAllKey <string>().Count()); foreach (var item in myCache.GetAllKey <string>()) { Console.WriteLine(); Console.WriteLine(item); Console.WriteLine(); } db.Deleteable <Student>().Where(it => it.Id == 1).RemoveDataCache().ExecuteCommand(); Console.WriteLine("Cache Key Count:" + myCache.GetAllKey <string>().Count()); }