public UpdateQuery(Type type)
{
fieldValues = new Dictionary<string, object>(StringComparer.Ordinal);
conditions = new QueryCondition();
table = DataFieldAttribute.GetTable(type);
}
public UpdateQuery(string tableName)
{
fieldValues = new Dictionary<string, object>(StringComparer.Ordinal);
conditions = new QueryCondition();
table = tableName;
}
public TableJoin(JoinTypes type, string joinTable, string table, string joinField, string tableField)
{
conditions = new QueryCondition();
Type = type;
JoinTable = joinTable;
Table = table;
JoinField = joinField;
TableField = tableField;
AddCondition(new DataField(joinTable, joinField).ToString(), new DataField(table, tableField));
}
public TableJoin(JoinTypes type, DataField joinField, DataField tableField)
{
conditions = new QueryCondition();
Type = type;
JoinTable = joinField.Table;
JoinField = joinField.Name;
Table = tableField.Table;
TableField = tableField.Name;
AddCondition(joinField.ToString(), tableField);
}
public DeleteQuery(Type type)
{
conditions = new QueryCondition();
table = DataFieldAttribute.GetTable(type);
}
public DeleteQuery(string tableName)
{
conditions = new QueryCondition();
table = tableName;
}
public QueryCondition AddCondition(ConditionRelations relation, string field, ConditionEquality equality, object value)
{
QueryCondition condition = new QueryCondition(field, equality, value);
conditions.Add(new KeyValuePair<QueryCondition, ConditionRelations>(condition, relation));
return condition;
}
public TableSort(SortOrder order, DataField field, QueryCondition sortLast)
{
Order = order;
Field = field.ToString();
SortLast = sortLast;
}
public TableSort(SortOrder order, string field, QueryCondition sortLast)
{
Order = order;
Field = field;
SortLast = sortLast;
}
public void AddSort(SortOrder order, QueryCondition lastSort)
{
sorts.Add(new TableSort(order, string.Empty, lastSort));
}
internal SelectQuery(Type type, QueryStub stub)
{
this.stub = stub;
tables = new List<string>(4);
fields = new List<string>(64);
groupings = new List<string>(2);
conditions = new QueryCondition();
joins = new List<TableJoin>(4);
sorts = new List<TableSort>(4);
tables.Add(DataFieldAttribute.GetTable(type));
}
public SelectQuery(Type type)
{
tables = new List<string>(4);
fields = new List<string>(64);
groupings = new List<string>(2);
conditions = new QueryCondition();
joins = new List<TableJoin>(4);
sorts = new List<TableSort>(4);
tables.Add(DataFieldAttribute.GetTable(type));
}
public SelectQuery(string baseTableName)
{
tables = new List<string>(4);
fields = new List<string>(64);
groupings = new List<string>(2);
conditions = new QueryCondition();
joins = new List<TableJoin>(4);
sorts = new List<TableSort>(4);
tables.Add(baseTableName);
}