/// <summary>
/// 执行SQL字符串缓存操作
/// </summary>
/// <param name="key">SQL字符串缓存的KEY</param>
/// <param name="parameter">需要映射的实例</param>
/// <param name="commandTimeout">超时时间</param>
/// <returns>返回集合</returns>
public IEnumerable <T> GetCache(string key, object parameter, int?commandTimeout = null)
{
string sql = VasilyCache.GetFromCache(key);
if (sql != null)
{
return(Connection.Query <T>(sql, parameter, commandTimeout: commandTimeout));
}
return(null);
}
/// <summary>
/// 执行SQL字符串缓存操作
/// </summary>
/// <param name="key">SQL字符串缓存的KEY</param>
/// <param name="commandTimeout">超时时间</param>
/// <param name="instance">需要映射的实例</param>
/// <returns>返回影响的行数</returns>
public int ExecuteCache(string key, int?commandTimeout = null, params object[] instance)
{
int result = 0;
string sql = VasilyCache.GetFromCache(key);
if (sql != null)
{
for (int i = 0; i < instance.Length; i += 1)
{
result += Connection.Execute(sql, instance, commandTimeout: commandTimeout);
}
}
return(result);
}
public T GetFirst(string key, object instance, int?commandTimeout = null)
{
string sql = VasilyCache.GetFromCache(key);
return(Connection.QueryFirst <T>(sql, instance, commandTimeout: commandTimeout));
}
