public string BuildSelectQuery(string[] properties = null, QueryCondition <T> condition = null,
int?limit = null)
{
var columns = SelectColumnsGivenModelProperties(properties);
var fields = columns.BuildCharacterSeparatedString(item => item.Item1.ResolveName(item.Item2));
var conditionText = condition == null ? string.Empty : $" WHERE {condition.Build(this)}";
var limitText = limit.HasValue ? $" LIMIT {limit.Value}" : string.Empty;
return($"SELECT {fields} FROM {TableName}{conditionText}{limitText};");
}
public string BuildDeleteQuery(QueryCondition <T> condition)
{
var conditionText = $" WHERE {condition.Build(this)}";
return($"DELETE FROM {TableName}{conditionText};");
}
