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);
}
}
