public void WriteSql(SqlWriter writer, SqlGenerator sqlGenerator)
{
writer.Write("OFFSET ");
SkipCount.WriteSql(writer, sqlGenerator);
writer.Write(" ROWS ");
}
private static void WriteOffsetFetch(SqlWriter writer, TopClause top, SkipClause skip, SqlGenerator sqlGenerator)
{
skip.WriteSql(writer, sqlGenerator);
if (top != null)
{
writer.Write("FETCH NEXT ");
top.TopCount.WriteSql(writer, sqlGenerator);
writer.Write(" ROWS ONLY ");
}
}
public void WriteSql(SqlWriter writer, SqlGenerator sqlGenerator)
{
if (NeedsRenaming)
{
int i;
if (sqlGenerator.AllColumnNames.TryGetValue(NewName, out i))
{
string newNameCandidate;
do
{
++i;
newNameCandidate = NewName + i.ToString(CultureInfo.InvariantCulture);
}while (sqlGenerator.AllColumnNames.ContainsKey(newNameCandidate));
sqlGenerator.AllColumnNames[NewName] = i;
NewName = newNameCandidate;
}
sqlGenerator.AllColumnNames[NewName] = 0;
NeedsRenaming = false;
}
writer.Write(SqlGenerator.QuoteIdentifier(NewName));
}
public virtual void WriteSql(SqlWriter writer, SqlGenerator sqlGenerator)
{
if (null != _sqlFragments)
{
foreach (var o in _sqlFragments)
{
var str = (o as String);
if (null != str)
{
writer.Write(str);
}
else
{
var sqlFragment = (o as ISqlFragment);
if (null != sqlFragment)
{
sqlFragment.WriteSql(writer, sqlGenerator);
}
else
{
throw new InvalidOperationException();
}
}
}
}
}
public void WriteSql(SqlWriter writer, SqlGenerator sqlGenerator)
{
writer.Write("TOP ");
writer.Write("(");
TopCount.WriteSql(writer, sqlGenerator);
writer.Write(")");
writer.Write(" ");
if (WithTies)
{
writer.Write("WITH TIES ");
}
}
public bool WriteSqlIfUsed(SqlWriter writer, SqlGenerator sqlGenerator, string separator)
{
if (m_usageManager.IsUsed(m_symbol))
{
writer.Write(separator);
m_builder.WriteSql(writer, sqlGenerator);
return(true);
}
return(false);
}
public override void WriteSql(SqlWriter writer, SqlGenerator sqlGenerator)
{
writer.Write("SELECT ");
if (IsDistinct)
{
writer.Write("DISTINCT ");
}
if (Top != null && Skip == null)
{
Top.WriteSql(writer, sqlGenerator);
}
if (IsEmpty)
{
writer.Write("*");
}
else
{
var printedAny = WriteOptionalColumns(writer, sqlGenerator);
if (!base.IsEmpty)
{
if (printedAny)
{
writer.Write(", ");
}
base.WriteSql(writer, sqlGenerator);
}
else if (!printedAny)
{
m_optionalColumns[0].MarkAsUsed();
m_optionalColumns[0].WriteSqlIfUsed(writer, sqlGenerator, "");
}
}
}
public void WriteSql(SqlWriter writer, SqlGenerator sqlGenerator)
{
List <string> outerExtentAliases = null;
if ((null != outerExtents) && (0 < outerExtents.Count))
{
foreach (var outerExtent in outerExtents.Keys)
{
var joinSymbol = outerExtent as JoinSymbol;
if (joinSymbol != null)
{
foreach (var symbol in joinSymbol.FlattenedExtentList)
{
if (null == outerExtentAliases)
{
outerExtentAliases = new List <string>();
}
outerExtentAliases.Add(symbol.NewName);
}
}
else
{
if (null == outerExtentAliases)
{
outerExtentAliases = new List <string>();
}
outerExtentAliases.Add(outerExtent.NewName);
}
}
}
var extentList = AllJoinExtents ?? fromExtents;
if (null != extentList)
{
foreach (var fromAlias in extentList)
{
if ((null != outerExtentAliases) && outerExtentAliases.Contains(fromAlias.Name))
{
var i = sqlGenerator.AllExtentNames[fromAlias.Name];
string newName;
do
{
++i;
newName = fromAlias.Name + i.ToString(CultureInfo.InvariantCulture);
}while (sqlGenerator.AllExtentNames.ContainsKey(newName));
sqlGenerator.AllExtentNames[fromAlias.Name] = i;
fromAlias.NewName = newName;
sqlGenerator.AllExtentNames[newName] = 0;
}
if (null == outerExtentAliases)
{
outerExtentAliases = new List <string>();
}
outerExtentAliases.Add(fromAlias.NewName);
}
}
writer.Indent += 1;
@select.WriteSql(writer, sqlGenerator);
writer.WriteLine();
writer.Write("FROM ");
From.WriteSql(writer, sqlGenerator);
if ((null != @where) && !Where.IsEmpty)
{
writer.WriteLine();
writer.Write("WHERE ");
Where.WriteSql(writer, sqlGenerator);
}
if ((null != groupBy) && !GroupBy.IsEmpty)
{
writer.WriteLine();
writer.Write("GROUP BY ");
GroupBy.WriteSql(writer, sqlGenerator);
}
if ((null != orderBy) && !OrderBy.IsEmpty && (IsTopMost || Select.Top != null || Select.Skip != null))
{
writer.WriteLine();
writer.Write("ORDER BY ");
OrderBy.WriteSql(writer, sqlGenerator);
}
if (null != Select.Skip)
{
writer.WriteLine();
WriteOffsetFetch(writer, Select.Top, Select.Skip, sqlGenerator);
}
--writer.Indent;
}
