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); }