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