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