internal List <StaticContent> InternalLoadByParentInstanceId(int parentId)
{
RawSqlExecuteReaderAction readerAction = new RawSqlExecuteReaderAction();
readerAction.CommandText = _loadByParentInstanceIdCommandText;
readerAction.AddParameter("@ParentInstanceId", parentId, DbType.Int32);
this.ExecuteCommand(readerAction);
List <StaticContent> rootContList = new List <StaticContent>();
IDataReader dataReader = readerAction.DataReader;
try
{
int[] ordinals = GetRootContFieldOrdinals(dataReader);
while (dataReader.Read())
{
StaticContent p = new StaticContent();
TranslateToRootCont(dataReader, p, ordinals[0], ordinals[1], ordinals[2], ordinals[3]);
rootContList.Add(p);
}
}
finally
{
dataReader.Close();
}
return(rootContList);
}
internal List <PlugFile> InternalLoadByDestinationLocationId(int destLocId)
{
RawSqlExecuteReaderAction readerAction = new RawSqlExecuteReaderAction();
readerAction.CommandText = _loadByDestLocIdCommandText;
readerAction.AddParameter("@DestinationLocationId", destLocId, DbType.Int32);
this.ExecuteCommand(readerAction);
List <PlugFile> plugFileList = new List <PlugFile>();
IDataReader dataReader = readerAction.DataReader;
try
{
int[] ordinals = GetPlugFileFieldOrdinals(dataReader);
while (dataReader.Read())
{
PlugFile res = new PlugFile();
TranslateToPlugFile(dataReader, res, ordinals[0], ordinals[1], ordinals[2], ordinals[3], ordinals[4]);
plugFileList.Add(res);
}
}
finally
{
dataReader.Close();
}
return(plugFileList);
}
internal List <StaticContent> InternalLoadAll()
{
RawSqlExecuteReaderAction readerAction = new RawSqlExecuteReaderAction();
readerAction.CommandText = _loadAllCommandText;
this.ExecuteCommand(readerAction);
List <StaticContent> rootContList = new List <StaticContent>();
IDataReader dataReader = readerAction.DataReader;
try
{
int[] ordinals = GetRootContFieldOrdinals(dataReader);
while (dataReader.Read())
{
StaticContent p = new StaticContent();
TranslateToRootCont(dataReader, p, ordinals[0], ordinals[1], ordinals[2], ordinals[3]);
rootContList.Add(p);
}
}
finally
{
dataReader.Close();
}
return(rootContList);
}
internal List <ClassDefinition> InternalLoadByPlugIdName(int plugId)
{
RawSqlExecuteReaderAction readerAction = new RawSqlExecuteReaderAction();
readerAction.CommandText = _loadByPlugIdCommandText;
readerAction.AddParameter("@PlugId", plugId, DbType.Int32);
this.ExecuteCommand(readerAction);
List <ClassDefinition> classDefList = new List <ClassDefinition>();
IDataReader dataReader = readerAction.DataReader;
try
{
int[] ordinals = GetClassDefinitionFieldOrdinals(dataReader);
while (dataReader.Read())
{
ClassDefinition res = new ClassDefinition();
TranslateToClassDefinition(dataReader, res, ordinals[0], ordinals[1], ordinals[2], ordinals[3], ordinals[4], ordinals[5]);
classDefList.Add(res);
}
}
finally
{
dataReader.Close();
}
return(classDefList);
}
public List <Binding> LoadByImplementationId(int implementationId)
{
RawSqlExecuteReaderAction readerAction = new RawSqlExecuteReaderAction();
readerAction.CommandText = _loadByImplementationIdCommandText;
readerAction.AddParameter("@ImplementationId", implementationId, DbType.Int32);
this.ExecuteCommand(readerAction);
List <Binding> bindingList = new List <Binding>();
IDataReader dataReader = readerAction.DataReader;
try
{
int[] ordinals = GetBindingFieldOrdinals(dataReader);
while (dataReader.Read())
{
Binding res = new Binding();
TranslateToBinding(dataReader, res, ordinals[0], ordinals[1], ordinals[2]);
bindingList.Add(res);
}
}
finally
{
dataReader.Close();
}
return(bindingList);
}
internal List <Instance> InternalLoadAll()
{
RawSqlExecuteReaderAction readerAction = new RawSqlExecuteReaderAction();
readerAction.CommandText = _loadAllCommandText;
this.ExecuteCommand(readerAction);
List <Instance> instanceList = new List <Instance>();
IDataReader dataReader = readerAction.DataReader;
try
{
int[] ordinals = GetInstanceFieldOrdinals(dataReader);
while (dataReader.Read())
{
Instance p = new Instance();
TranslateToInstance(dataReader, p, ordinals[0], ordinals[1], ordinals[2]);
instanceList.Add(p);
}
}
finally
{
dataReader.Close();
}
return(instanceList);
}
internal List <PlugLocation> InternalLoadAll()
{
RawSqlExecuteReaderAction readerAction = new RawSqlExecuteReaderAction();
readerAction.CommandText = _loadAllCommandText;
this.ExecuteCommand(readerAction);
List <PlugLocation> plugLocList = new List <PlugLocation>();
IDataReader dataReader = readerAction.DataReader;
try
{
int[] ordinals = GetPlugLocationFieldOrdinals(dataReader);
while (dataReader.Read())
{
PlugLocation res = new PlugLocation();
TranslateToPlugLocation(dataReader, res, ordinals[0], ordinals[1], ordinals[2], ordinals[3], ordinals[4]);
plugLocList.Add(res);
}
}
finally
{
dataReader.Close();
}
return(plugLocList);
}
internal List <Binding> InternalLoadAll()
{
RawSqlExecuteReaderAction readerAction = new RawSqlExecuteReaderAction();
readerAction.CommandText = _loadAllCommandText;
this.ExecuteCommand(readerAction);
List <Binding> bindingList = new List <Binding>();
IDataReader dataReader = readerAction.DataReader;
try
{
int[] ordinals = GetBindingFieldOrdinals(dataReader);
while (dataReader.Read())
{
Binding res = new Binding();
TranslateToBinding(dataReader, res, ordinals[0], ordinals[1], ordinals[2]);
bindingList.Add(res);
}
}
finally
{
dataReader.Close();
}
return(bindingList);
}
internal List <Instance> InternalLoadByClassDefinitionId(int classDefId)
{
RawSqlExecuteReaderAction readerAction = new RawSqlExecuteReaderAction();
readerAction.CommandText = _loadByClassDefinitionIdCommandText;
readerAction.AddParameter("@ClassDefinitionId", classDefId, DbType.Int32);
this.ExecuteCommand(readerAction);
List <Instance> instanceList = new List <Instance>();
IDataReader dataReader = readerAction.DataReader;
try
{
int[] ordinals = GetInstanceFieldOrdinals(dataReader);
while (dataReader.Read())
{
Instance p = new Instance();
TranslateToInstance(dataReader, p, ordinals[0], ordinals[1], ordinals[2]);
instanceList.Add(p);
}
}
finally
{
dataReader.Close();
}
return(instanceList);
}
internal List <BindablePointDefinition> InternalLoadByInterfaceId(string interfaceId)
{
RawSqlExecuteReaderAction readerAction = new RawSqlExecuteReaderAction();
readerAction.CommandText = _loadByInterfaceCommandText;
readerAction.AddParameter("@InterfaceId", interfaceId, DbType.Int32);
this.ExecuteCommand(readerAction);
List <BindablePointDefinition> bindPointDefList = new List <BindablePointDefinition>();
IDataReader dataReader = readerAction.DataReader;
try
{
int[] ordinals = GetBindablePointDefinitionFieldOrdinals(dataReader);
while (dataReader.Read())
{
BindablePointDefinition res = new BindablePointDefinition();
TranslateToBindablePointDefinition(dataReader, res, ordinals[0], ordinals[1], ordinals[2], ordinals[3], ordinals[4], ordinals[5]);
bindPointDefList.Add(res);
}
}
finally
{
dataReader.Close();
}
return(bindPointDefList);
}
internal BindablePointDefinition InternalLoadByName(string bindPointName)
{
RawSqlExecuteReaderAction readerAction = new RawSqlExecuteReaderAction();
readerAction.CommandText = _loadByNameCommandText;
readerAction.AddParameter("@BindablePointName", bindPointName, DbType.String);
BindablePointDefinition bindPointDef = null;
this.ExecuteCommand(readerAction);
try
{
readerAction.DataReader.Read();
bindPointDef = TranslateToBindablePointDefinition(readerAction.DataReader);
}
finally
{
readerAction.DataReader.Close();
}
return(bindPointDef);
}
internal BindablePointDefinition InternalLoadByPrimaryKey(int bindPointDefId)
{
RawSqlExecuteReaderAction readerAction = new RawSqlExecuteReaderAction();
readerAction.CommandText = _loadByIdCommandText;
readerAction.AddParameter("@BindablePointDefinitionId", bindPointDefId, DbType.Int32);
BindablePointDefinition bindPointDef = null;
this.ExecuteCommand(readerAction);
try
{
readerAction.DataReader.Read();
bindPointDef = TranslateToBindablePointDefinition(readerAction.DataReader);
}
finally
{
readerAction.DataReader.Close();
}
return(bindPointDef);
}
internal PlugLocation InternalLoadByName(string plugLocName)
{
RawSqlExecuteReaderAction readerAction = new RawSqlExecuteReaderAction();
readerAction.CommandText = _loadByNameCommandText;
readerAction.AddParameter("@PlugLocationName", plugLocName, DbType.String);
PlugLocation plugLoc = null;
this.ExecuteCommand(readerAction);
try
{
readerAction.DataReader.Read();
plugLoc = TranslateToPlugLocation(readerAction.DataReader);
}
finally
{
readerAction.DataReader.Close();
}
return(plugLoc);
}
internal PlugLocation InternalLoadByPrimaryKey(int plugLocId)
{
RawSqlExecuteReaderAction readerAction = new RawSqlExecuteReaderAction();
readerAction.CommandText = _loadByIdCommandText;
readerAction.AddParameter("@PlugLocationId", plugLocId, DbType.Int32);
PlugLocation plugLoc = null;
this.ExecuteCommand(readerAction);
try
{
readerAction.DataReader.Read();
plugLoc = TranslateToPlugLocation(readerAction.DataReader);
}
finally
{
readerAction.DataReader.Close();
}
return(plugLoc);
}
internal ClassDefinition InternalLoadByClassName(string className)
{
RawSqlExecuteReaderAction readerAction = new RawSqlExecuteReaderAction();
readerAction.CommandText = _loadByNameCommandText;
readerAction.AddParameter("@ClassName", className, DbType.String);
ClassDefinition classDef = null;
this.ExecuteCommand(readerAction);
try
{
readerAction.DataReader.Read();
classDef = TranslateToClassDefinition(readerAction.DataReader);
}
finally
{
readerAction.DataReader.Close();
}
return(classDef);
}
internal ClassDefinition InternalLoadByPrimaryKey(int classDefId)
{
RawSqlExecuteReaderAction readerAction = new RawSqlExecuteReaderAction();
readerAction.CommandText = _loadByIdCommandText;
readerAction.AddParameter("@ClassDefinitionId", classDefId, DbType.Int32);
ClassDefinition classDef = null;
this.ExecuteCommand(readerAction);
try
{
readerAction.DataReader.Read();
classDef = TranslateToClassDefinition(readerAction.DataReader);
}
finally
{
readerAction.DataReader.Close();
}
return(classDef);
}
internal Instance InternalLoadByPrimaryKey(int instanceId)
{
RawSqlExecuteReaderAction readerAction = new RawSqlExecuteReaderAction();
readerAction.CommandText = _loadByIdCommandText;
readerAction.AddParameter("@InstanceId", instanceId, DbType.Int32);
Instance instance = null;
this.ExecuteCommand(readerAction);
try
{
readerAction.DataReader.Read();
instance = TranslateToInstance(readerAction.DataReader);
}
finally
{
readerAction.DataReader.Close();
}
return(instance);
}
internal StaticContent InternalLoadByPrimaryKey(int instanceId)
{
RawSqlExecuteReaderAction readerAction = new RawSqlExecuteReaderAction();
readerAction.CommandText = _loadByIdCommandText;
readerAction.AddParameter("@InstanceId", instanceId, DbType.Int32);
StaticContent rootCont = null;
this.ExecuteCommand(readerAction);
try
{
readerAction.DataReader.Read();
rootCont = TranslateToRootCont(readerAction.DataReader);
}
finally
{
readerAction.DataReader.Close();
}
return(rootCont);
}
internal StaticContent InternalLoadByFriendlyName(string instanceName)
{
RawSqlExecuteReaderAction readerAction = new RawSqlExecuteReaderAction();
readerAction.CommandText = _loadByInstanceNameCommandText;
readerAction.AddParameter("@ContentFriendlyName", instanceName, DbType.String);
StaticContent rootCont = null;
this.ExecuteCommand(readerAction);
try
{
readerAction.DataReader.Read();
rootCont = TranslateToRootCont(readerAction.DataReader);
}
finally
{
readerAction.DataReader.Close();
}
return(rootCont);
}
internal Instance InternalLoadByName(string instanceName)
{
RawSqlExecuteReaderAction readerAction = new RawSqlExecuteReaderAction();
readerAction.CommandText = _loadByNameCommandText;
readerAction.AddParameter("@InstanceName", instanceName, DbType.String);
Instance instance = null;
this.ExecuteCommand(readerAction);
try
{
readerAction.DataReader.Read();
instance = TranslateToInstance(readerAction.DataReader);
}
finally
{
readerAction.DataReader.Close();
}
return(instance);
}
