public void Dispose()
{
sqlHelper.Dispose();
sqlHelper = null;
formCacheSyncLock = null;
}
public void Dispose()
{
sqlHelper.Dispose();
recordFieldValueStorage.Dispose();
sqlHelper = null;
formCacheSyncLock = null;
}
public void Dispose()
{
sqlHelper.Dispose();
sqlHelper = null;
settings.Dispose();
settings = null;
}
public void Dispose()
{
storage.Dispose();
sqlHelper.Dispose();
storage = null;
sqlHelper = null;
}
public void Dispose()
{
sqlHelper.Dispose();
pageStorage.Dispose();
sqlHelper = null;
pageStorage = null;
formCacheSyncLock = null;
}
public void Dispose()
{
prevalueSourceStorage.Dispose();
prevalueSourceStorage = null;
conditionStorage.Dispose();
conditionStorage = null;
sqlHelper.Dispose();
sqlHelper = null;
}
/// <summary>
/// Retrieve HTML from the database cache for the given node
/// </summary>
/// <param name="nodeId">Id of the node</param>
/// <param name="fullHtml">string to fill with HTML</param>
/// <returns>bool indicating success/failure</returns>
public static bool GetRecord(int nodeId, out string fullHtml)
{
fullHtml = "";
if (nodeId < 1)
{
return(false);
}
var success = false;
ISqlHelper sqlHelper = null;
IRecordsReader result = null;
try
{
const string sqlQuery = "SELECT fullHTML FROM fullTextCache WHERE nodeId = @nodeId";
sqlHelper = DataLayerHelper.CreateSqlHelper(global::Umbraco.Core.ApplicationContext.Current.DatabaseContext.ConnectionString);
result = sqlHelper.ExecuteReader(sqlQuery, sqlHelper.CreateParameter("@nodeId", nodeId));
if (result != null && result.HasRecords && result.Read() && result.ContainsField("fullHTML"))
{
fullHtml = result.GetString("fullHTML");
success = true;
}
}
catch (umbraco.UmbracoException ex)
{
LogHelper.Error(typeof(DbAccess), "Error In Database Query to fullTextCache", ex);
fullHtml = "";
}
finally
{
if (result != null)
{
result.Close();
}
if (sqlHelper != null)
{
sqlHelper.Dispose();
}
}
return(success);
}
/// <summary>
/// Wrapper around umbraco's sqlHelper.ExecuteNonQuery that handles a few exceptions
/// </summary>
/// <param name="query">The SQL Query to execute</param>
/// <param name="parameters">Dictionary mapping parameter name to parameter value</param>
/// <returns>The number of rows affected, or -1 on failure</returns>
private static int?NonQuery(string query, Dictionary <string, object> parameters)
{
int? numRows;
ISqlHelper sqlHelper = null;
try
{
sqlHelper = DataLayerHelper.CreateSqlHelper(global::Umbraco.Core.ApplicationContext.Current.DatabaseContext.ConnectionString);
var numParams = parameters.Count;
if (numParams < 1)
{
numRows = sqlHelper.ExecuteNonQuery(query);
}
else
{
var sqlParameters = new IParameter[numParams];
var i = 0;
foreach (var parameter in parameters)
{
sqlParameters[i++] = sqlHelper.CreateParameter(parameter.Key, parameter.Value);
}
numRows = sqlHelper.ExecuteNonQuery(query, sqlParameters);
}
}
catch (umbraco.UmbracoException ex)
{
LogHelper.Error(typeof(DbAccess), "Error In Database Query to fullTextCache.", ex);
numRows = null;
}
finally
{
if (sqlHelper != null)
{
sqlHelper.Dispose();
}
}
return(numRows);
}
public void Dispose()
{
sqlHelper.Dispose();
sqlHelper = null;
}
/// <summary>
/// Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources.
/// </summary>
public void Dispose()
{
m_SqlHelper.Dispose();
}
public void Dispose()
{
_config = null;
_sqlhelper.Dispose();
_sqlhelper = null;
}
public override void Dispose()
{
_sqlHelper?.Dispose();
_context?.Dispose();
}