public string ToStatement(List <IDataParameter> @params)
{
var result = new StringBuilder();
result.Append($"UPDATE [{_entityName}]");
result.Append(_setFieldList.ToStatement(@params));
result.Append(_where.ToStatement(@params));
var sql = result.Append(";").ToString();
OrmDebug.Trace(sql);
return(sql);
}
public string ToStatement(List <IDataParameter> @params)
{
var result = new StringBuilder();
result.Append(FromStatement());
result.Append(JoinStatement(@params));
result.Append(_where.ToStatement(@params));
result.Append(_groupBy.ToStatement());
result.Append(_orderBy.ToStatement());
var sql = result.Append(";").ToString();
OrmDebug.Trace(sql);
return(sql);
}
private IDbCommand BuildCommand(IClause sqlClause)
{
var @params = new List <IDataParameter>();
var sql = sqlClause.ToStatement(@params);
var command = SqlFactory.CreateCommand();
command.CommandType = CommandType.Text;
command.CommandText = sql;
foreach (var param in @params)
{
command.Parameters.Add(param);
}
return(command);
}