public SQLBuilder BuildUpdate <T>() { _sqlsb.Clear(); var setValues = TypeMapper.GetColumnNames <T>().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 BuildSelectWithColumn <T>() { _sqlsb.Clear(); _sqlsb.Append(string.Concat("SELECT ", string.Join(",", UseEscapeChar(TypeMapper.GetColumnNames <T>())), " FROM ", UseEscapeChar(TypeMapper.GetTableName <T>()))); return(this); }