public override void BuildQuery(SQLSyntax syntax, params string[] statement)
{
switch (syntax)
{
case SQLSyntax.Select:
_select = "SELECT " + statement[0];
break;
case SQLSyntax.Top:
_top = "SELECT TOP " + statement[0] + " " + statement[1];
break;
case SQLSyntax.From:
_from = "FROM \"" + statement[0] + "\"";
break;
case SQLSyntax.Where:
_where = "WHERE " + statement[0];
break;
case SQLSyntax.OrderBy:
_hasOrderBy = true;
_orderby = "ORDER BY " + statement[0];
break;
case SQLSyntax.OrderByDescending:
_hasOrderBy = true;
_orderby = "ORDER BY " + statement[0] + " DESC";
break;
case SQLSyntax.ThenBy:
if (_hasOrderBy)
{
_orderby += ", " + statement[0];
}
else
{
_orderby = "ORDER BY " + statement[0];
}
break;
case SQLSyntax.ThenByDescending:
if (_hasOrderBy)
{
_orderby += ", " + statement[0] + " DESC";
}
else
{
_orderby = "ORDER BY " + statement[0] + " DESC";
}
break;
}
}
public override void BuildDelete(SQLSyntax syntax, string statement)
{
switch (syntax)
{
case SQLSyntax.Delete:
_delete = "DELETE \"" + statement + "\"";
break;
case SQLSyntax.Where:
_where = "WHERE " + statement;
break;
}
}
public override void BuildInsert(SQLSyntax syntax, string statement)
{
switch (syntax)
{
case SQLSyntax.Insert:
_insert = "INSERT INTO \"" + statement + "\"";
break;
case SQLSyntax.Fields:
_fields = "(" + statement + ")";
break;
case SQLSyntax.Values:
_values = "VALUES (" + statement + ")";
break;
}
}
public override void BuildUpdate(SQLSyntax syntax, string statement)
{
switch (syntax)
{
case SQLSyntax.Update:
_update = "UPDATE \"" + statement + "\"";
break;
case SQLSyntax.Set:
_set = "SET " + statement;
break;
case SQLSyntax.Where:
_where = "WHERE " + statement;
break;
}
}
private ICriteria <T> AddExpression(SQLSyntax key, Expression predicate)
{
List <Expression> expressionList = null;
if (!(expressionDictionary.TryGetValue(key.ToString(), out expressionList)))
{
expressionList = new List <Expression>()
{
predicate
};
this.expressionDictionary.Add(key.ToString(), expressionList);
}
else
{
expressionList = this.expressionDictionary[key.ToString()];
expressionList.Add(predicate);
this.expressionDictionary[key.ToString()] = expressionList;
}
return(this);
}
public abstract void BuildDelete(SQLSyntax syntax, string statement);
public abstract void BuildInsert(SQLSyntax syntax, string statement);
public abstract void BuildQuery(SQLSyntax syntax, params string[] statement);
