/// <summary> /// 缓存文件测试 /// </summary> private void FileTest(string path) { DateTimeOffset dtOffset = new DateTimeOffset(DateTime.Now.AddHours(3)); string filePath = path; string key = "file"; GLCacheExpiration.CreateFileCache(key, filePath, dtOffset); }
public CacheItem LoadSQLDataList() { Console.WriteLine("From SQL"); DateTimeOffset dtOffset = new DateTimeOffset(DateTime.Now.AddHours(3)); string sqlCmd = "SELECT ID,Name,Gender,Phone FROM dbo.Customer"; CacheItem cacheItem = GLCacheExpiration.CreateSQLCache <Customers>("cus", dbConnectionString, sqlCmd, dtOffset, onListSourceChange, SqlCacheOption.List); return(cacheItem); }
public CacheItem LoadSQLDataScalar() { Console.WriteLine("From SQL"); DateTimeOffset dtOffset = new DateTimeOffset(DateTime.Now.AddHours(3)); string sqlCmd = "SELECT Gender FROM dbo.Customers WHERE ID='00000ddb92044fad8be0913b68697318'"; CacheItem cacheItem = GLCacheExpiration.CreateSQLCache("cus", dbConnectionString, sqlCmd, dtOffset, onScalarSourceChange); return(cacheItem); }
public CacheItem LoadSQLDataSingle() { Console.WriteLine("From SQL"); DateTimeOffset dtOffset = new DateTimeOffset(DateTime.Now.AddHours(3)); string sqlCmd = "SELECT ID,UserName,Gender,Phone FROM dbo.Customers WHERE ID='00000ddb92044fad8be0913b68697318'"; CacheItem cacheItem = GLCacheExpiration.CreateSQLCache <Customers>("cus", dbConnectionString, sqlCmd, dtOffset, onSingleSourceChange, SqlCacheOption.Single); return(cacheItem); }