private CacheDependency GetNonAggregateDependencies(ExpirationHint hint)
{
if (hint is KeyDependency)
{
KeyDependency keyDep = (KeyDependency)hint;
return(new Runtime.Dependencies.KeyDependency(keyDep.CacheKeys, new DateTime(keyDep.StartAfterTicks)));
}
else if (hint is FileDependency)
{
FileDependency fileDep = (FileDependency)hint;
return(new Runtime.Dependencies.FileDependency(fileDep.fileNames, new DateTime(fileDep.StartAfterTicks)));
}
else if (hint is OleDbCacheDependency)
{
OleDbCacheDependency oleDbDep = (OleDbCacheDependency)hint;
return(DBDependencyFactory.CreateOleDbCacheDependency(oleDbDep.ConnectionString, oleDbDep.DbCacheKey));
}
else if (hint is Sql7CacheDependency)
{
Sql7CacheDependency sql7Dep = (Sql7CacheDependency)hint;
return(DBDependencyFactory.CreateSqlCacheDependency(sql7Dep.ConnectionString, sql7Dep.DbCacheKey));
}
else if (hint is OracleCacheDependency)
{
OracleCacheDependency oracleDep = (OracleCacheDependency)hint;
Dictionary <string, OracleCmdParams> parameters = new Dictionary <string, OracleCmdParams>();
IDictionaryEnumerator enu = oracleDep.CommandParams.GetEnumerator();
while (enu.MoveNext())
{
string key = enu.Key.ToString();
OracleCommandParams cmdParam = (OracleCommandParams)enu.Value;
OracleCmdParams commandParam = new OracleCmdParams();
commandParam.Direction = (OracleParameterDirection)cmdParam.Direction;
commandParam.Type = (OracleCmdParamsType)cmdParam.Type;
commandParam.Value = cmdParam.Value;
parameters.Add(key, commandParam);
}
Runtime.Dependencies.OracleCacheDependency oraDep = new Runtime.Dependencies.OracleCacheDependency(oracleDep.ConnectionString,
oracleDep.QueryString,
(OracleCommandType)oracleDep.CommandType,
parameters);
return(oraDep);
}
else if (hint is SqlYukonCacheDependency)
{
SqlYukonCacheDependency yukonDep = (SqlYukonCacheDependency)hint;
Dictionary <string, Runtime.Dependencies.SqlCmdParams> parameters = new Dictionary <string, Runtime.Dependencies.SqlCmdParams>();
IDictionaryEnumerator enu = yukonDep.CommandParams.GetEnumerator();
while (enu.MoveNext())
{
string key = enu.Key.ToString();
SqlCmdParams param = (SqlCmdParams)enu.Value;
Runtime.Dependencies.SqlCmdParams yukonCmdParam = new Runtime.Dependencies.SqlCmdParams();
yukonCmdParam.SqlParamDir = param.Direction;
yukonCmdParam.Type = (CmdParamsType)param.DbType;
yukonCmdParam.IsNullable = param.IsNullable;
yukonCmdParam.LocaleID = param.LocaleID;
yukonCmdParam.Offset = param.Offset;
yukonCmdParam.Precision = param.Precision;
yukonCmdParam.Scale = param.Scale;
yukonCmdParam.Size = param.ParamSize;
yukonCmdParam.SourceColumn = param.SourceColumn;
yukonCmdParam.SourceColumnNullMapping = param.SourceColumnNullMapping;
yukonCmdParam.SqlValue = param.SqlValue;
yukonCmdParam.SourceVersion = (SqlDataRowVersion)(int)param.SrcVersion;
yukonCmdParam.TypeName = param.TypeName;
yukonCmdParam.UdtTypeName = param.UdtName;
yukonCmdParam.Value = param.Value;
parameters.Add(key, yukonCmdParam);
}
Runtime.Dependencies.SqlCacheDependency sqlDep = new Runtime.Dependencies.SqlCacheDependency(yukonDep.ConnectionString,
yukonDep.QueryString,
(SqlCommandType)yukonDep.CommandType,
parameters);
return(sqlDep);
}
if (hint is NosDBCacheDependency)
{
NosDBCacheDependency nosDbDep = (NosDBCacheDependency)hint;
Dictionary <string, object> parameters = new Dictionary <string, object>();
IDictionaryEnumerator enu = nosDbDep.CommandParams.GetEnumerator();
while (enu.MoveNext())
{
string key = enu.Key.ToString();
parameters.Add(key, enu.Value);
}
NosDBDependency oraDep = new NosDBDependency(nosDbDep.ConnectionString, nosDbDep.QueryString, parameters, nosDbDep.Timeout);
return(oraDep);
}
return(null);
}
private static ExpirationHint GetExpirationHint(CacheDependency cacheDependency, AggregateExpirationHint aggregateHint)
{
if (cacheDependency == null)
{
return(null);
}
ExpirationHint hint = null;
if (cacheDependency is Runtime.Dependencies.KeyDependency)
{
Runtime.Dependencies.KeyDependency keyDependency = cacheDependency as Runtime.Dependencies.KeyDependency;
hint = new KeyDependency(keyDependency.CacheKeys, new DateTime(keyDependency.StartAfterTicks));
aggregateHint.Add(hint);
}
else if (cacheDependency is Runtime.Dependencies.FileDependency)
{
Runtime.Dependencies.FileDependency fileDependency = cacheDependency as Runtime.Dependencies.FileDependency;
hint = new FileDependency(fileDependency.fileNames, new DateTime(fileDependency.StartAfterTicks));
aggregateHint.Add(hint);
}
else if (cacheDependency is Runtime.Dependencies.DBCacheDependency)
{
Runtime.Dependencies.DBCacheDependency dbDependency = cacheDependency as Runtime.Dependencies.DBCacheDependency;
switch (dbDependency.Type)
{
case Runtime.Dependencies.DBDependencyType.OleDbCacheDependency:
hint = new OleDbCacheDependency(dbDependency.ConnectionString, dbDependency.PrimaryKey);
break;
case Runtime.Dependencies.DBDependencyType.SqlCacheDependency:
hint = new Sql7CacheDependency(dbDependency.ConnectionString, dbDependency.PrimaryKey);
break;
}
aggregateHint.Add(hint);
}
else if (cacheDependency is Runtime.Dependencies.OracleCacheDependency)
{
Runtime.Dependencies.OracleCacheDependency oracleDependency = cacheDependency as Runtime.Dependencies.OracleCacheDependency;
Hashtable parameters = new Hashtable();
if (oracleDependency.CommandParams != null)
{
foreach (KeyValuePair <string, Runtime.Dependencies.OracleCmdParams> pair in oracleDependency.CommandParams)
{
Runtime.Dependencies.OracleCmdParams oracleCommandParams = pair.Value;
OracleCommandParams commandParam = new OracleCommandParams((OracleCmdParamsType)oracleCommandParams.Type, oracleCommandParams.Value, oracleCommandParams.Direction);
parameters.Add(pair.Key, commandParam);
}
}
hint = new OracleCacheDependency(oracleDependency.ConnectionString, oracleDependency.CommandText, oracleDependency.CommandType, parameters);
aggregateHint.Add(hint);
}
else if (cacheDependency is Runtime.Dependencies.SqlCacheDependency)
{
Runtime.Dependencies.SqlCacheDependency sqlDependency = cacheDependency as Runtime.Dependencies.SqlCacheDependency;
Hashtable parameters = new Hashtable();
if (sqlDependency.CommandParams != null)
{
foreach (KeyValuePair <string, Runtime.Dependencies.SqlCmdParams> pair in sqlDependency.CommandParams)
{
Runtime.Dependencies.SqlCmdParams param = pair.Value;
Alachisoft.NCache.Caching.AutoExpiration.SqlCmdParams commandParam = new SqlCmdParams();
commandParam.CmpInfo = param.SqlCmpInfo;
commandParam.Direction = param.SqlParamDir;
commandParam.IsNullable = param.IsNullable;
commandParam.LocaleID = param.LocaleID;
commandParam.Offset = param.Offset;
commandParam.Precision = param.Precision;
commandParam.Scale = param.Scale;
commandParam.ParamSize = param.Size;
commandParam.SourceColumn = param.SourceColumn;
commandParam.SourceColumnNullMapping = param.SourceColumnNullMapping;
commandParam.SqlValue = param.SqlValue;
commandParam.SrcVersion = param.SrcVersion;
commandParam.DbType = (SqlDbType)param.Type;
commandParam.TypeName = param.TypeName;
commandParam.UdtName = param.UdtTypeName;
commandParam.Value = param.Value;
parameters.Add(pair.Key, commandParam);
}
}
hint = new SqlYukonCacheDependency(sqlDependency.ConnectionString, sqlDependency.CommandText, sqlDependency.CommandType, parameters);
aggregateHint.Add(hint);
}
else if (cacheDependency is Runtime.Dependencies.ExtensibleDependency)
{
hint = new ExtensibleDependency(cacheDependency as Runtime.Dependencies.ExtensibleDependency);
aggregateHint.Add(hint);
}
else if (cacheDependency is NosDBDependency)
{
NosDBDependency nosDbDependency = cacheDependency as NosDBDependency;
hint = new NosDBCacheDependency(nosDbDependency.ConnectionString, nosDbDependency.CommandText, nosDbDependency.Timeout, nosDbDependency.Parameters);
aggregateHint.Add(hint);
}
else
{
foreach (CacheDependency dep in cacheDependency.Dependencies)
{
hint = GetExpirationHint(dep, aggregateHint);
}
}
IList <ExpirationHint> hints = aggregateHint.Hints;
if (hints.Count == 0)
{
return(null);
}
if (hints.Count == 1)
{
return(hints[0]);
}
return(aggregateHint);
}
public static CacheDependency GetCacheDependency(ExpirationHint hint, ref DateTime absoluteExpiration, ref TimeSpan slidingExpiration)
{
CacheDependency cacheDependency = null;
if (hint != null)
{
if (hint is AggregateExpirationHint)
{
AggregateExpirationHint aggregate = (AggregateExpirationHint)hint;
IList <ExpirationHint> hints = aggregate.Hints;
if (hints != null && hints.Count > 0)
{
foreach (ExpirationHint h in hints)
{
AddToDependency(ref cacheDependency, GetCacheDependency(h, ref absoluteExpiration, ref slidingExpiration));
}
}
}
else if (hint is FixedExpiration)
{
absoluteExpiration = ((FixedExpiration)hint).AbsoluteTime;
}
else if (hint is IdleExpiration)
{
slidingExpiration = ((IdleExpiration)hint).SlidingTime;
}
else if (hint is KeyDependency)
{
KeyDependency keyDep = (KeyDependency)hint;
AddToDependency(ref cacheDependency,
new Runtime.Dependencies.KeyDependency(keyDep.CacheKeys, new DateTime(keyDep.StartAfterTicks)));
}
else if (hint is FileDependency)
{
FileDependency fileDep = (FileDependency)hint;
AddToDependency(ref cacheDependency, new Runtime.Dependencies.FileDependency(fileDep.fileNames, new DateTime(fileDep.StartAfterTicks)));
}
else if (hint is OleDbCacheDependency)
{
OleDbCacheDependency oleDbDep = (OleDbCacheDependency)hint;
AddToDependency(ref cacheDependency,
new CacheDependency(null, null, DBDependencyFactory.CreateOleDbCacheDependency(
oleDbDep.ConnectionString, oleDbDep.DbCacheKey)));
}
else if (hint is Sql7CacheDependency)
{
Sql7CacheDependency sql7Dep = (Sql7CacheDependency)hint;
AddToDependency(ref cacheDependency,
new CacheDependency(null, null, DBDependencyFactory.CreateSqlCacheDependency(
sql7Dep.ConnectionString, sql7Dep.DbCacheKey)));
}
else if (hint is OracleCacheDependency)
{
OracleCacheDependency oracleDep = (OracleCacheDependency)hint;
Dictionary <string, OracleCmdParams> parameters = new Dictionary <string, OracleCmdParams>();
IDictionaryEnumerator enu = oracleDep.CommandParams.GetEnumerator();
while (enu.MoveNext())
{
string key = enu.Key.ToString();
OracleCommandParams cmdParam = (OracleCommandParams)enu.Value;
OracleCmdParams commandParam = new OracleCmdParams();
commandParam.Direction = (OracleParameterDirection)cmdParam.Direction;
commandParam.Type = (OracleCmdParamsType)cmdParam.Type;
commandParam.Value = cmdParam.Value;
parameters.Add(key, commandParam);
}
Runtime.Dependencies.OracleCacheDependency oraDep = new Runtime.Dependencies.OracleCacheDependency(oracleDep.ConnectionString,
oracleDep.QueryString,
(OracleCommandType)oracleDep.CommandType,
parameters);
AddToDependency(ref cacheDependency, oraDep);
}
else if (hint is SqlYukonCacheDependency)
{
SqlYukonCacheDependency yukonDep = (SqlYukonCacheDependency)hint;
Dictionary <string, Runtime.Dependencies.SqlCmdParams> parameters = new Dictionary <string, Runtime.Dependencies.SqlCmdParams>();
IDictionaryEnumerator enu = yukonDep.CommandParams.GetEnumerator();
while (enu.MoveNext())
{
string key = enu.Key.ToString();
SqlCmdParams param = (SqlCmdParams)enu.Value;
Runtime.Dependencies.SqlCmdParams yukonCmdParam = new Runtime.Dependencies.SqlCmdParams();
yukonCmdParam.SqlParamDir = param.Direction;
yukonCmdParam.Type = (CmdParamsType)param.DbType;
yukonCmdParam.IsNullable = param.IsNullable;
yukonCmdParam.LocaleID = param.LocaleID;
yukonCmdParam.Offset = param.Offset;
yukonCmdParam.Precision = param.Precision;
yukonCmdParam.Scale = param.Scale;
yukonCmdParam.Size = param.ParamSize;
yukonCmdParam.SourceColumn = param.SourceColumn;
yukonCmdParam.SourceColumnNullMapping = param.SourceColumnNullMapping;
yukonCmdParam.SqlValue = param.SqlValue;
yukonCmdParam.SourceVersion = (SqlDataRowVersion)(int)param.SrcVersion;
yukonCmdParam.TypeName = param.TypeName;
yukonCmdParam.UdtTypeName = param.UdtName;
yukonCmdParam.Value = param.Value;
parameters.Add(key, yukonCmdParam);
}
Runtime.Dependencies.SqlCacheDependency sqlDep = new Runtime.Dependencies.SqlCacheDependency(yukonDep.ConnectionString,
yukonDep.QueryString,
(SqlCommandType)yukonDep.CommandType,
parameters);
AddToDependency(ref cacheDependency, sqlDep);
}
else if (hint is NosDBCacheDependency)
{
NosDBCacheDependency nosDbDep = (NosDBCacheDependency)hint;
Dictionary <string, object> parameters = new Dictionary <string, object>();
IDictionaryEnumerator enu = nosDbDep.CommandParams.GetEnumerator();
while (enu.MoveNext())
{
string key = enu.Key.ToString();
parameters.Add(key, enu.Value);
}
NosDBDependency nosDb = new NosDBDependency(nosDbDep.ConnectionString, nosDbDep.QueryString, parameters, nosDbDep.Timeout);
AddToDependency(ref cacheDependency, nosDb);
}
}
return(cacheDependency);
}
public static ExpirationHint ReadExpHint(CompactReader reader)
{
ExpirationHintType expHint = ExpirationHintType.Parent;
expHint = (ExpirationHintType)reader.ReadInt16();
ExpirationHint tmpObj = null;
switch (expHint)
{
case ExpirationHintType.NULL:
return(null);
case ExpirationHintType.Parent:
tmpObj = (ExpirationHint)reader.ReadObject();
return((ExpirationHint)tmpObj);
case ExpirationHintType.FixedExpiration:
FixedExpiration fe = new FixedExpiration();
((ICompactSerializable)fe).Deserialize(reader);
return((ExpirationHint)fe);
case ExpirationHintType.TTLExpiration:
TTLExpiration ttle = new TTLExpiration();
((ICompactSerializable)ttle).Deserialize(reader);
return((ExpirationHint)ttle);
case ExpirationHintType.TTLIdleExpiration:
TTLIdleExpiration ttlie = new TTLIdleExpiration();
((ICompactSerializable)ttlie).Deserialize(reader);
return((ExpirationHint)ttlie);
case ExpirationHintType.FixedIdleExpiration:
FixedIdleExpiration fie = new FixedIdleExpiration();
((ICompactSerializable)fie).Deserialize(reader);
return((ExpirationHint)fie);
case ExpirationHintType.FileDependency:
FileDependency fd = new FileDependency();
((ICompactSerializable)fd).Deserialize(reader);
return((ExpirationHint)fd);
case ExpirationHintType.KeyDependency:
KeyDependency kd = new KeyDependency();
((ICompactSerializable)kd).Deserialize(reader);
return((ExpirationHint)kd);
#if !(DEVELOPMENT || CLIENT)
case ExpirationHintType.NodeExpiration:
NodeExpiration ne = new NodeExpiration();
((ICompactSerializable)ne).Deserialize(reader);
return((ExpirationHint)ne);
#endif
case ExpirationHintType.Sql7CacheDependency:
Sql7CacheDependency s7cd = new Sql7CacheDependency();
((ICompactSerializable)s7cd).Deserialize(reader);
return((ExpirationHint)s7cd);
case ExpirationHintType.OleDbCacheDependency:
OleDbCacheDependency oledbDependency = new OleDbCacheDependency();
((ICompactSerializable)oledbDependency).Deserialize(reader);
return((ExpirationHint)oledbDependency);
case ExpirationHintType.SqlYukonCacheDependency:
SqlYukonCacheDependency sycd = new SqlYukonCacheDependency();
((ICompactSerializable)sycd).Deserialize(reader);
return((ExpirationHint)sycd);
case ExpirationHintType.OracleCacheDependency:
OracleCacheDependency orclcd = new OracleCacheDependency();
((ICompactSerializable)orclcd).Deserialize(reader);
return((ExpirationHint)orclcd);
case ExpirationHintType.IdleExpiration:
IdleExpiration ie = new IdleExpiration();
((ICompactSerializable)ie).Deserialize(reader);
return((ExpirationHint)ie);
case ExpirationHintType.AggregateExpirationHint:
AggregateExpirationHint aeh = new AggregateExpirationHint();
((ICompactSerializable)aeh).Deserialize(reader);
return((ExpirationHint)aeh);
case ExpirationHintType.DBCacheDependency:
DBCacheDependency dbcd = new DBCacheDependency();
((ICompactSerializable)dbcd).Deserialize(reader);
return((ExpirationHint)dbcd);
case ExpirationHintType.ExtensibleDependency:
ExtensibleDependency ed = new ExtensibleDependency();
ed = (ExtensibleDependency)reader.ReadObject();
return((ExpirationHint)ed);
case ExpirationHintType.NosDBCacheDependency:
NosDBCacheDependency nosDbd = new NosDBCacheDependency();
((ICompactSerializable)nosDbd).Deserialize(reader);
return(nosDbd);
case ExpirationHintType.DependencyHint:
break;
default:
break;
}
return(null);
}
private static Alachisoft.NCache.Common.Protobuf.KeyDependency GetKeyDependency(Alachisoft.NCache.Caching.AutoExpiration.KeyDependency keyDep)
{
Common.Protobuf.KeyDependency protoKeyDep = new Common.Protobuf.KeyDependency();
protoKeyDep.keys.AddRange(keyDep.CacheKeys);
protoKeyDep.startAfter = keyDep.StartAfterTicks;
return(protoKeyDep);
}
public static ExpirationHint GetExpirationHintObj(Alachisoft.NCache.Common.Protobuf.Dependency dependency, bool resyncOnExpiration, string serializationContext)
{
AggregateExpirationHint hints = new AggregateExpirationHint();
if (dependency != null && dependency.keyDep != null && dependency.keyDep.Count > 0)
{
for (int i = 0; i < dependency.keyDep.Count; i++)
{
Alachisoft.NCache.Caching.AutoExpiration.KeyDependency keyDep =
new Alachisoft.NCache.Caching.AutoExpiration.KeyDependency(dependency.keyDep[i].keys.ToArray(),
new DateTime(dependency.keyDep[i].startAfter));
hints.Add(keyDep);
}
}
if (dependency != null && dependency.fileDep != null && dependency.fileDep.Count > 0)
{
for (int i = 0; i < dependency.fileDep.Count; i++)
{
Alachisoft.NCache.Caching.AutoExpiration.FileDependency fileDep =
new Alachisoft.NCache.Caching.AutoExpiration.FileDependency(dependency.fileDep[i].filePaths.ToArray(),
new DateTime(dependency.fileDep[i].startAfter));
hints.Add(fileDep);
}
}
if (dependency != null && dependency.oleDbDep != null && dependency.oleDbDep.Count > 0)
{
for (int i = 0; i < dependency.oleDbDep.Count; i++)
{
OleDbCacheDependency oleDb = new OleDbCacheDependency(dependency.oleDbDep[i].connectionString,
dependency.oleDbDep[i].dbCacheKey);
hints.Add(oleDb);
}
}
if (dependency != null && dependency.sql7Dep != null && dependency.sql7Dep.Count > 0)
{
for (int i = 0; i < dependency.sql7Dep.Count; i++)
{
Sql7CacheDependency sql7Dep = new Sql7CacheDependency(dependency.sql7Dep[i].connectionString,
dependency.sql7Dep[i].dbCacheKey);
hints.Add(sql7Dep);
}
}
if (dependency != null && dependency.xtDep != null && dependency.xtDep.Count > 0)
{
try
{
for (int i = 0; i < dependency.xtDep.Count; i++)
{
IFormatter formater = new BinaryFormatter();
byte[] buffer = dependency.xtDep[i].data;
object obj = null;
using (MemoryStream stream = new MemoryStream(buffer))
{
obj = formater.Deserialize(stream);
}
Alachisoft.NCache.Caching.AutoExpiration.ExtensibleDependency xtDep =
new Alachisoft.NCache.Caching.AutoExpiration.ExtensibleDependency(
(Runtime.Dependencies.ExtensibleDependency)obj);
hints.Add(xtDep);
}
}
catch (SerializationException ex)
{
throw new OperationFailedException(ex.Message);
}
}
if (dependency != null && dependency.oracleDep != null && dependency.oracleDep.Count > 0)
{
for (int i = 0; i < dependency.oracleDep.Count; i++)
{
Hashtable parameters = new Hashtable();
for (int pc = 0; pc < dependency.oracleDep[i].param.Count; pc++)
{
OracleCommandParams commandParam = new OracleCommandParams((Runtime.Dependencies.OracleCmdParamsType)dependency.oracleDep[i].param[pc].cmdParam.dbType,
dependency.oracleDep[i].param[pc].cmdParam.value,
(Runtime.Dependencies.OracleParameterDirection)dependency.oracleDep[i].param[pc].cmdParam.direction);
parameters.Add(dependency.oracleDep[i].param[pc].key, commandParam);
}
OracleCacheDependency oraDep = new OracleCacheDependency(dependency.oracleDep[i].connectionString,
dependency.oracleDep[i].query,
(CommandType)dependency.oracleDep[i].commandType,
parameters);
hints.Add(oraDep);
}
}
if (dependency != null && dependency.yukonDep != null && dependency.yukonDep.Count > 0)
{
for (int i = 0; i < dependency.yukonDep.Count; i++)
{
Hashtable parameters = new Hashtable();
for (int pc = 0; pc < dependency.yukonDep[i].param.Count; pc++)
{
YukonCommandParam yukonParam = dependency.yukonDep[i].param[pc].cmdParam;
SqlCmdParams commandParam = new SqlCmdParams((SqlDbType)yukonParam.dbType, yukonParam.value);
commandParam.CmpInfo = (System.Data.SqlTypes.SqlCompareOptions)yukonParam.cmpOptions;
commandParam.Direction = (ParameterDirection)yukonParam.direction;
commandParam.IsNullable = yukonParam.isNullable;
commandParam.LocaleID = yukonParam.localeId;
commandParam.Offset = yukonParam.offset;
commandParam.Precision = (byte)yukonParam.precision;
commandParam.Scale = (byte)yukonParam.scale;
commandParam.ParamSize = yukonParam.size;
commandParam.SourceColumn = yukonParam.sourceColumn;
commandParam.SourceColumnNullMapping = yukonParam.sourceColumnNull;
commandParam.SqlValue = yukonParam.sqlValue;
commandParam.SrcVersion = (DataRowVersion)yukonParam.version;
commandParam.DbType = (SqlDbType)yukonParam.typeId;
commandParam.TypeName = yukonParam.typeName;
commandParam.UdtName = yukonParam.udtTypeName;
if (!yukonParam.nullValueProvided)
{
string val = yukonParam.value as string;
if (val != null)
{
if (commandParam.DbType == SqlDbType.Binary || commandParam.DbType == SqlDbType.VarBinary || commandParam.DbType == SqlDbType.Image || commandParam.DbType == SqlDbType.Timestamp)
{
System.Text.UTF8Encoding encoding = new System.Text.UTF8Encoding();
commandParam.Value = encoding.GetBytes(val);
}
else if (commandParam.DbType == SqlDbType.DateTime || commandParam.DbType == SqlDbType.DateTime2 || commandParam.DbType == SqlDbType.Date || commandParam.DbType == SqlDbType.SmallDateTime)
{
commandParam.Value = new DateTime(Convert.ToInt64(val));
}
else if (commandParam.DbType == SqlDbType.Time)
{
commandParam.Value = new TimeSpan(Convert.ToInt64(val));
}
else if (commandParam.DbType == SqlDbType.DateTimeOffset)
{
string[] dateOffset = val.Split(new char[] { ',' });
commandParam.Value = new DateTimeOffset(new DateTime(Convert.ToInt64(dateOffset[0])), TimeSpan.FromMinutes(Convert.ToInt32(dateOffset[1])));
}
else if (commandParam.DbType == SqlDbType.Money || commandParam.DbType == SqlDbType.SmallMoney || commandParam.DbType == SqlDbType.Decimal)
{
commandParam.Value = Convert.ToDecimal(val);
}
else if (commandParam.DbType == SqlDbType.Int)
{
commandParam.Value = Convert.ToInt32(val);
}
else if (commandParam.DbType == SqlDbType.BigInt)
{
commandParam.Value = Convert.ToInt64(val);
}
else if (commandParam.DbType == SqlDbType.SmallInt)
{
commandParam.Value = Convert.ToInt16(val);
}
else if (commandParam.DbType == SqlDbType.Real)
{
commandParam.Value = Convert.ToSingle(val);
}
else if (commandParam.DbType == SqlDbType.UniqueIdentifier)
{
commandParam.Value = System.Data.SqlTypes.SqlGuid.Parse(val);
}
else if (commandParam.DbType == SqlDbType.TinyInt)
{
commandParam.Value = Convert.ToByte(val);
}
else if (commandParam.DbType == SqlDbType.Float)
{
commandParam.Value = Convert.ToDouble(val);
}
else if (commandParam.DbType == SqlDbType.Bit)
{
commandParam.Value = Convert.ToBoolean(val);
}
else
{
commandParam.Value = val;
}
}
else
{
commandParam.Value = DBNull.Value;
}
}
else
{
commandParam.Value = DBNull.Value;
}
parameters.Add(dependency.yukonDep[i].param[pc].key, commandParam);
}
SqlYukonCacheDependency yukonDep = new SqlYukonCacheDependency(dependency.yukonDep[i].connectionString,
dependency.yukonDep[i].query,
(CommandType)dependency.yukonDep[i].commandType,
parameters);
hints.Add(yukonDep);
}
}
if (dependency != null && dependency.NosDep != null && dependency.NosDep.Count > 0)
{
for (int i = 0; i < dependency.NosDep.Count; i++)
{
Hashtable parameters = new Hashtable();
for (int pc = 0; pc < dependency.NosDep[i].param.Count; pc++)
{
parameters.Add(dependency.NosDep[i].param[pc].key, dependency.NosDep[i].param[pc].value);
}
NosDBCacheDependency oraDep = new NosDBCacheDependency(dependency.NosDep[i].connectionString,
dependency.NosDep[i].query,
dependency.NosDep[i].timeout,
parameters);
hints.Add(oraDep);
}
}
if (resyncOnExpiration)
{
hints.SetBit(ExpirationHint.NEEDS_RESYNC);
}
IList <ExpirationHint> expHints = hints.Hints;
if (expHints.Count == 0)
{
return(null);
}
if (expHints.Count == 1)
{
return(expHints[0]);
}
return(hints);
}