private static List <ORM_CMN_QST_QuestionItem_EnumerationAnswer> Search(Query query, string connectionString, DbConnection connection, DbTransaction transaction)
{
CSV2Core.Core.Interfaces.IManagedConnection managedConnection = new CSV2Core_MySQL.MySQLManagedConnection();
List <ORM_CMN_QST_QuestionItem_EnumerationAnswer> items;
try
{
managedConnection.set(connectionString, connection, transaction);
var loader = new CSV2Core_MySQL.Dictionaries.MultiTable.Loader.DictionaryLoader(managedConnection.getConnection(), managedConnection.getTransaction());
DbCommand command = managedConnection.manage(query.CreateSelectQuery(TableName));
query.SetParameters(command);
items = new List <ORM_CMN_QST_QuestionItem_EnumerationAnswer>();
var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader());
reader.SetOrdinals(new string[] { "CMN_QST_QuestionItem_EnumerationAnswerID", "EnumerationAnswerType_RefID", "EnumerationAnswer_Text_DictID", "Creation_Timestamp", "IsDeleted", "Tenant_RefID" });
while (reader.Read())
{
ORM_CMN_QST_QuestionItem_EnumerationAnswer item = new ORM_CMN_QST_QuestionItem_EnumerationAnswer();
//0:Parameter CMN_QST_QuestionItem_EnumerationAnswerID of type Guid
item.CMN_QST_QuestionItem_EnumerationAnswerID = reader.GetGuid(0);
//1:Parameter EnumerationAnswerType_RefID of type Guid
item.EnumerationAnswerType_RefID = reader.GetGuid(1);
//2:Parameter EnumerationAnswer_Text of type Dict
item.EnumerationAnswer_Text = reader.GetDictionary(2);
loader.Append(item.EnumerationAnswer_Text, TableName);
//3:Parameter Creation_Timestamp of type DateTime
item.Creation_Timestamp = reader.GetDate(3);
//4:Parameter IsDeleted of type Boolean
item.IsDeleted = reader.GetBoolean(4);
//5:Parameter Tenant_RefID of type Guid
item.Tenant_RefID = reader.GetGuid(5);
item.Status_IsAlreadySaved = true;
item.Status_IsDirty = false;
items.Add(item);
}
reader.Close();
loader.Load();
managedConnection.commit();
}
catch (Exception ex)
{
managedConnection.rollback();
throw ex;
}
return(items);
}
