public virtual void Render(SqlWriter writer) { if(Precedence > Left.Precedence) { writer.Append("("); writer.Append(Left); writer.Append(")"); } else { writer.Append(Left); } writer.Append(Operator); if (Precedence > Right.Precedence) { writer.Append("("); writer.Append(Right); writer.Append(")"); } else { writer.Append(Right); } }
public void Render(SqlWriter writer) { var type = PropertyMap.Property.PropertyType; if (type == typeof(bool) && !(Parent is Relational)) { writer.Append(Alias + PropertyMap.Column, SqlStrings.Equal, "1"); } else { writer.Append(Alias + PropertyMap.Column); } }
public void Render(SqlWriter writer) { for (var i = 0; i < _entityMap.Properties.Length; i++) { if (i > 0) writer.Append(","); writer.Append(_alias + _entityMap.Properties[i].Column); } RenderRowNumber(writer); }
public virtual void Render(SqlWriter writer) { writer.Append(Operator); if(Precedence > Expr.Precedence) { writer.Append("("); writer.Append(Expr); writer.Append(")"); } else { writer.Append(Expr); } }
private void RenderRowNumber(SqlWriter writer) { if (!_showRowNumber) return; writer.Append(",", SqlStrings.ROW_NUMBER + "()", SqlStrings.Over, "("); if (_orderBy == null) writer.Append(SqlStrings.OrderBy, _alias + _entityMap.Key.Column, SqlStrings.Ascending); else writer.Append(_orderBy); writer.Append(")", SqlStrings.As, (BracketedName)SqlStrings.ROW_NUMBER); }
public void Render(SqlWriter writer) { for (var i = 0; i < _items.Count; i++) { var item = _items[i]; if(i == 0) writer.Append(SqlStrings.OrderBy); else writer.Append(","); writer.Append(item.Alias + item.Property.Column, item.Ascending ? SqlStrings.Ascending : SqlStrings.Descending); } }
public void Render(SqlWriter writer) { var value = (string)Context.Values[Parameter.Name].Value; if (PartialPrefix && !value.EndsWith("%")) value = value + '%'; if (PartialPostfix && !value.StartsWith("%")) value = '%' + value; Context.Values[Parameter.Name].Value = value; PropertyAccess.Render(writer); writer.Append(SqlStrings.Like); Parameter.Render(writer); }
public void Render(SqlWriter writer) { writer.Append(Join, ReferenceMap.To.Table, SqlStrings.As, ToAlias, SqlStrings.NoLock); writer.Indent(); writer.AppendLine(SqlStrings.On, FromAlias + ReferenceMap.Column, "=", ToAlias + ReferenceMap.To.Key.Column); writer.Unindent(); }
public void Render(SqlWriter writer) { writer.Append(SqlStrings.Top + '(' + _valueProvider.ParamName + ')'); }
public void Render(SqlWriter writer) { writer.Append(Name); }
public void Render(SqlWriter writer) { writer.Append(SqlStrings.Null); }