private string BuildSqlWithCondition(string tableName, string sqlFields, string sqlValues)
{
var sqlWhere = new SqlWhereBuilder(condition).Build();
return("INSERT INTO {0}s ({1}) VALUES ({2}) WHERE {3}".FormatWith(tableName, sqlFields, sqlValues, sqlWhere));
}
private string BuildSqlWithCondition(dynamic condition, string sqlFields, string tableName)
{
var sqlWhere = new SqlWhereBuilder(condition).Build();
return(String.Format("SELECT {0} FROM {1}s WHERE {2}", sqlFields, tableName, sqlWhere));
}
private string BuildSqlWithCondition(string tableName, dynamic condition)
{
var sqlWhere = new SqlWhereBuilder(condition).Build();
return(String.Format("DELETE FROM {0}s WHERE {1}", tableName, sqlWhere));
}
private string BuildSqlWithCondition(dynamic condition, string tableName, string sqlUpdate)
{
var sqlWhere = new SqlWhereBuilder(condition).Build();
return(String.Format("UPDATE {0}s {1} WHERE {2}", tableName, sqlUpdate, sqlWhere));
}