public static string LoadIdByField(this IDBConnection connection, ColumnSpec column, string value) { List <string> ids = connection.LoadIdsByConditions( column.table, new ComparisonCondition( column, ComparisonType.EQUAL, value ), Diapasone.unlimited ); if (ids.Count > 1) { throw new CriticalException("not unique"); } else if (ids.Count == 1) { return(ids[0]); } else { throw new NotFoundInDBException(column, value); } }
public JoinSpec(ColumnSpec mainColumn, ITableSpec additionalTable, string alias) { this.mainColumn = mainColumn; this.additionalTableRaw = additionalTable; this.additionalTable = new TableSpec(additionalTable, alias); }
public static ColumnOrValue createColumn(ColumnSpec column) { return(new ColumnOrValue { _isColumn = true, _column = column }); }
public SortSpec(ColumnSpec column, bool ascending) { this.column = column; this.ascending = ascending; }
public static List <string> LoadIdsByConditions(this IDBConnection connection, ITableSpec table, AbstractCondition conditions, Diapasone diapasone, ColumnSpec idSpec, params SortSpec[] sorts) { return(connection.LoadIdsByConditions(table, conditions, diapasone, new JoinSpec[0], sorts, idSpec, false)); }