public SQLBuilder BuildUpdate <T>(string[] columnNames)
{
_sqlsb.Clear();
var setValues = columnNames.Select(p => string.Concat(' ', UseEscapeChar(p), " = ", UseParmChar(p), ' '));
_sqlsb.Append(string.Concat("UPDATE ", UseEscapeChar(TypeMapper.GetTableName <T>()), " SET ", string.Join(",", setValues), ' '));
return(this);
}
public SQLBuilder BuildInsert <T>()
{
_sqlsb.Clear();
var props = UseEscapeChar(TypeMapper.GetColumnNames <T>());
var parms = UseParmChar(TypeMapper.GetColumnNames <T>());
_sqlsb.Append(string.Concat("INSERT INTO ", UseEscapeChar(TypeMapper.GetTableName <T>()), " (", string.Join(",", props), ") VALUES (", string.Join(",", parms), ") "));
return(this);
}
public SQLBuilder BuildDelete <T>()
{
_sqlsb.Clear();
_sqlsb.Append(string.Concat("DELETE FROM ", UseEscapeChar(TypeMapper.GetTableName <T>()), ' '));
return(this);
}
public SQLBuilder BuildSelectWithColumn <T>()
{
_sqlsb.Clear();
_sqlsb.Append(string.Concat("SELECT ", string.Join(",", UseEscapeChar(TypeMapper.GetColumnNames <T>())), " FROM ", UseEscapeChar(TypeMapper.GetTableName <T>())));
return(this);
}
public SQLBuilder BuildSelectCount <T>()
{
_sqlsb.Clear();
_sqlsb.Append(string.Concat("SELECT COUNT(*) FROM ", UseEscapeChar(TypeMapper.GetTableName <T>()), ' '));
return(this);
}