mschill 378653c536 C2025-011 PROMS – RO Update Admin Tool Memory Enhancements
The purpose of this upgrade is to improve the user experience when using the Admin tool to Update ROs. Currently for larger RO dbs (like Barakah) we can run up against memory constraints that do not allow all the ROs to be updated at one time. This is based upon some initial resource where some places were identified where we could improve memory usage.  Some of these should benefit PROMS as a whole while others will be specific to the RO Update option in Admin Tools.
2025-02-04 13:23:21 -05:00

163 lines
5.4 KiB
C#

// ========================================================================
// Copyright 2006 - Volian Enterprises, Inc. All rights reserved.
// Volian Enterprises - Proprietary Information - DO NOT COPY OR DISTRIBUTE
// ------------------------------------------------------------------------
// $Workfile: $ $Revision: $
// $Author: $ $Date: $
//
// $History: $
// ========================================================================
using System;
using System.Data;
using System.Data.SqlClient;
using Csla;
using Csla.Data;
namespace Volian.Object.Library
{
/// <summary>
/// ConnectionInfo Generated by MyGeneration using the CSLA Object Mapping template
/// </summary>
[Serializable()]
public partial class ConnectionInfo : ReadOnlyBase<ConnectionInfo>
{
#region Business Methods
private int _dbid;
[System.ComponentModel.DataObjectField(true, true)]
public int Dbid
{
[System.Runtime.CompilerServices.MethodImpl(System.Runtime.CompilerServices.MethodImplOptions.NoInlining)]
get
{
return _dbid;
}
}
private string _name = string.Empty;
[System.ComponentModel.DataObjectField(true, true)]
public string Name
{
[System.Runtime.CompilerServices.MethodImpl(System.Runtime.CompilerServices.MethodImplOptions.NoInlining)]
get
{
return _name;
}
}
private string _title = string.Empty;
[System.ComponentModel.DataObjectField(true, true)]
public string Title
{
[System.Runtime.CompilerServices.MethodImpl(System.Runtime.CompilerServices.MethodImplOptions.NoInlining)]
get
{
return _title;
}
}
private string _connectionstring = string.Empty;
[System.ComponentModel.DataObjectField(true, true)]
public string ConnectionString
{
[System.Runtime.CompilerServices.MethodImpl(System.Runtime.CompilerServices.MethodImplOptions.NoInlining)]
get
{
return _connectionstring;
}
}
private int _servertype;
/// <summary>
/// 0 SQL Server
/// </summary>
[System.ComponentModel.DataObjectField(true, true)]
public int ServerType
{
[System.Runtime.CompilerServices.MethodImpl(System.Runtime.CompilerServices.MethodImplOptions.NoInlining)]
get
{
return _servertype;
}
}
private string _config = string.Empty;
[System.ComponentModel.DataObjectField(true, true)]
public string Config
{
[System.Runtime.CompilerServices.MethodImpl(System.Runtime.CompilerServices.MethodImplOptions.NoInlining)]
get
{
return _config;
}
}
private DateTime _dts = new DateTime();
[System.ComponentModel.DataObjectField(true, true)]
public DateTime Dts
{
[System.Runtime.CompilerServices.MethodImpl(System.Runtime.CompilerServices.MethodImplOptions.NoInlining)]
get
{
return _dts;
}
}
private string _usrid = string.Empty;
[System.ComponentModel.DataObjectField(true, true)]
public string Usrid
{
[System.Runtime.CompilerServices.MethodImpl(System.Runtime.CompilerServices.MethodImplOptions.NoInlining)]
get
{
return _usrid;
}
}
// TODO: Replace base ConnectionInfo.ToString function as necessary
/// <summary>
/// Overrides Base ToString
/// </summary>
/// <returns>A string representation of current ConnectionInfo</returns>
//public override string ToString()
//{
// return base.ToString();
//}
// TODO: Check ConnectionInfo.GetIdValue to assure that the ID returned is unique
/// <summary>
/// Overrides Base GetIdValue - Used internally by CSLA to determine equality
/// </summary>
/// <returns>A Unique ID for the current ConnectionInfo</returns>
protected override object GetIdValue()
{
return _dbid;
}
#endregion
#region Factory Methods
private ConnectionInfo()
{ /* require use of factory methods */ }
#endregion
#region Data Access Portal
internal ConnectionInfo(SafeDataReader dr)
{
try
{
_dbid = dr.GetInt32("DBID");
_name = dr.GetString("Name");
_title = dr.GetString("Title");
_connectionstring = dr.GetString("ConnectionString");
_servertype = dr.GetInt32("ServerType");
_config = dr.GetString("Config");
_dts = dr.GetDateTime("DTS");
_usrid = dr.GetString("UsrID");
}
catch (Exception ex)
{
Database.LogException("ConnectionInfo", ex);
}
}
#endregion
} // Class
} // Namespace