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)
{
if (_joins.Count == 0)
return;
foreach (var join in _joins.Values)
{
writer.AppendLine();
join.Render(writer);
}
}
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 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);
}
}
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 virtual void Render(SqlWriter writer)
{
writer.Append(Operator);
if(Precedence > Expr.Precedence)
{
writer.Append("(");
writer.Append(Expr);
writer.Append(")");
}
else
{
writer.Append(Expr);
}
}
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 QueryContext(IEnumerable<EntityMap> entityMaps, string connectionString)
{
if (entityMaps == null)
throw new ArgumentNullException("entityMaps");
if (connectionString == null)
throw new ArgumentNullException("connectionString");
Values = new Dictionary<string, IValueProvider>();
EntityMaps = entityMaps;
ConnectionString = connectionString;
_writer = new SqlWriter();
_alias = 0;
_param = 0;
}
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 CanWriteFormattedText()
{
string expected = "<ul>\n\t<li>\n\t\t1 + 2 = 3\n\t</li>\n</ul>";
var writer = new SqlWriter();
writer.AppendLine("<ul>");
writer.Indent();
writer.AppendLine("<li>");
writer.Indent();
writer.AppendLine("1", "+", "2", "=", "3");
writer.Unindent();
writer.AppendLine("</li>");
writer.Unindent();
writer.AppendLine("</ul>");
var result = writer.GetResult();
Assert.AreEqual(expected, result);
}
public void CanRenderSelect()
{
var writer = new SqlWriter();
var convention = new DefaultConvention();
var builder = new EntityMapBuilder<Student>(convention);
var map = ((EntityMapBuilder<Student>) builder
.Key(_ => _.ID, "Student_id")).Build();
var selectEntity = new Select(map, "t0");
selectEntity.Render(writer);
var result = writer.GetResult();
AssertHelper.AreEqualWithNoSpaces(
@"SELECT [t0].[Student_id], [t0].[Name]
FROM [dbo].[Student] AS [t0] (NOLOCK)", result);
}
public void Render(SqlWriter writer)
{
writer.AppendLine(SqlStrings.Select);
writer.Indent();
writer.AppendLine(Top);
writer.AppendLine(Columns);
writer.Unindent();
writer.AppendLine(From);
writer.AppendLine(JoinGroup);
writer.AppendLine(Where);
writer.AppendLine(OrderBy);
}
public void Render(SqlWriter writer)
{
writer.AppendLine(SqlStrings.Select);
writer.Indent();
writer.AppendLine(Top);
writer.AppendLine("*");
writer.Unindent();
writer.AppendLine(SqlStrings.From, "(");
writer.Indent();
writer.AppendLine(_innerSelect);
writer.Unindent();
writer.AppendLine(")", SqlStrings.As, _alias);
writer.AppendLine(SqlStrings.Where, (BracketedName)SqlStrings.ROW_NUMBER, ">", _skip.ParamName);
}
public void Render(SqlWriter writer)
{
writer.AppendLine(SqlStrings.From, _select.EntityMap.Schema + _select.EntityMap.Table, SqlStrings.As, _select.Alias, SqlStrings.NoLock);
}
public void Render(SqlWriter writer)
{
writer.Append(SqlStrings.Null);
}
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(Name);
}
public void Render(SqlWriter writer)
{
writer.AppendLine(SqlStrings.Where);
expr.Render(writer);
}
public void Render(SqlWriter writer)
{
writer.Append(SqlStrings.Top + '(' + _valueProvider.ParamName + ')');
}