public string GetValue(string key)
 {
     try
     {
         var entityModelFactory = new EntityModelFactory();
         entityModelFactory.ConnectionString = ConnectionString;
         var entityModels = entityModelFactory.GetEntityModels <EntityModel>(tmpUserCacheTableName, $"select * from {tmpUserCacheTableName} where `key`='{key}'", "id");
         if (entityModels != null && entityModels.Any())
         {
             foreach (var item in entityModels)
             {
                 return(item["value"].ToString());
             }
             return(null);
         }
         else
         {
             return(null);
         }
     }
     catch (Exception)
     {
         return(null);
     }
 }
 public static bool StaticSetValue(string value, string key)
 {
     try
     {
         var entityModelFactory = new EntityModelFactory();
         entityModelFactory.ConnectionString = ConnectionString;
         var entityModels = entityModelFactory.GetEntityModels <EntityModel>(tmpUserCacheTableName, $"select * from {tmpUserCacheTableName} where `key`='{key}';", "id");
         if (entityModels != null && entityModels.Any() && entityModels.Count > 0)
         {
             foreach (var item in entityModels)
             {
                 if (item["key"].ToString() == key)
                 {
                     item["value"] = value;
                     item.SaveChange("value");
                 }
             }
             return(true);
         }
         else
         {
             var entityModel = new EntityModel();
             entityModel.ConnectionString = ConnectionString;
             entityModel.EntityName       = tmpUserCacheTableName;
             entityModel.PrimaryKey       = new KeyValuePair <string, object>("id", Guid.NewGuid());
             entityModel.Add("key", key);
             entityModel.Add("value", value);
             return(entityModelFactory.AddEntityModel(entityModel));
         }
     }
     catch (Exception ex)
     {
         return(false);
     }
 }
 public Dictionary <string, object> GetAll()
 {
     try
     {
         var entityModelFactory = new EntityModelFactory();
         entityModelFactory.ConnectionString = ConnectionString;
         var entityModels = entityModelFactory.GetEntityModels <EntityModel>(tmpUserCacheTableName, $"select * from {tmpUserCacheTableName}", "id");
         if (entityModels != null && entityModels.Any())
         {
             var dictionary = new Dictionary <string, object>();
             foreach (var item in entityModels)
             {
                 dictionary.Add(item["key"].ToString(), Json2KeyValue.JsonConvert.DeserializeObject <UserInfo>(item["value"].ToString()));
             }
             return(dictionary);
         }
         else
         {
             return(null);
         }
     }
     catch (Exception)
     {
         return(null);
     }
 }
 public bool Contains(string key)
 {
     try
     {
         var entityModelFactory = new EntityModelFactory();
         entityModelFactory.ConnectionString = ConnectionString;
         var entityModels = entityModelFactory.GetEntityModels <EntityModel>(tmpUserCacheTableName, $"select * from {tmpUserCacheTableName} where `key`='{key}'", "id");
         if (entityModels != null && entityModels.Any())
         {
             return(true);
         }
         else
         {
             return(false);
         }
     }
     catch (Exception)
     {
         return(false);
     }
 }