public override string ToSql()
{
var sqlBuilder = new StringBuilder(Verb);
if (EntityMapper.SqlGenerator.IncludeDbNameInQuery)
{
sqlBuilder.Append(string.Format("FROM {0}.{1}.{2} {3} ", DatabaseName, SchemaName, TableName, TableAlias));
}
else
{
sqlBuilder.Append(string.Format("FROM {0}.{1} {2} ", SchemaName, TableName, TableAlias));
}
foreach (var join in Joins)
{
sqlBuilder.Append(join.ToSql());
}
if (PredicateParts != null && PredicateParts.Any())
{
sqlBuilder.Append(string.Format("WHERE {0} ", PredicateParts.ToSql()));
}
else if (Predicate != null)
{
sqlBuilder.Append(string.Format("WHERE {0} ", Predicate.ToSql()));
}
return(sqlBuilder.ToString());
}
public override string ToSql()
{
var sqlBuilder = new StringBuilder();
var dbNameFormatted = string.Format("[{0}].", DatabaseName);
var includeDbName = EntityMapper.SqlGenerator.IncludeDbNameInQuery;
sqlBuilder.AppendFormat("{0} {4} FROM {1}[{2}].[{3}] {4} ",
Verb,
includeDbName ? dbNameFormatted : "",
SchemaName,
TableName,
TableAlias);
foreach (var join in Joins)
{
sqlBuilder.Append(join.ToSql());
}
if (PredicateParts != null && PredicateParts.Any())
{
sqlBuilder.AppendFormat("WHERE {0}; ", PredicateParts.ToSql());
}
else if (Predicate != null)
{
sqlBuilder.AppendFormat("WHERE {0}; ", Predicate.ToSql());
}
sqlBuilder.Append("SELECT @@ROWCOUNT;");
return(sqlBuilder.ToString());
}
public override string ToSql()
{
var sqlBuilder = new StringBuilder();
var selectFields = new List <string>();
var sqlJoinBuilder = new StringBuilder();
selectFields = SqlServerHelper.BraketFieldNames(Fields.Select(f => f.ColumnName), TableAlias).ToList();
foreach (var join in Joins)
{
var rightTableAlias = join.RightQuery.TableAlias;
foreach (var field in join.RightQuery.Fields)
{
selectFields.Add(string.Format("{0}.[{1}]", rightTableAlias, field.ColumnName));
}
sqlJoinBuilder.Append(join.ToSql());
}
if (TopRows > 0)
{
sqlBuilder.Append(string.Format("{0} {1} {2} {3} ", Verb, EntityMapper.SqlGenerator.Top, TopRows, string.Join(",", selectFields)));
}
else
{
sqlBuilder.Append(string.Format("{0} {1} ", Verb, string.Join(",", selectFields)));
}
if (EntityMapper.SqlGenerator.IncludeDbNameInQuery)
{
sqlBuilder.Append(string.Format("FROM [{0}].[{1}].[{2}] {3} ", DatabaseName, SchemaName, TableName, TableAlias));
}
else
{
sqlBuilder.Append(string.Format("FROM [{0}].[{1}] {2} ", SchemaName, TableName, TableAlias));
}
sqlBuilder.Append(sqlJoinBuilder.ToString());
if (PredicateParts != null && PredicateParts.Any())
{
sqlBuilder.Append(string.Format("WHERE {0} ", PredicateParts.ToSql()));
}
else if (Predicate != null)
{
sqlBuilder.Append(string.Format("WHERE {0} ", Predicate.ToSql()));
}
if (OrderByFields != null)
{
sqlBuilder.Append(string.Format("ORDER BY {0}", string.Join(",", OrderByFields.Select(f => f.ToSql()))));
}
return(sqlBuilder.ToString());
}
public override string ToSql()
{
var sqlBuilder = new StringBuilder();
var selectFields = new List <string>();
var sqlJoinBuilder = new StringBuilder();
selectFields.AddRange(Fields.Select(f => string.Format("{0}.{1}", TableAlias, f.ColumnName)));
foreach (var join in Joins)
{
var rightTableAlias = join.RightQuery.TableAlias;
foreach (var field in join.RightQuery.Fields)
{
selectFields.Add(string.Format("{0}.{1}", rightTableAlias, field.ColumnName));
}
sqlJoinBuilder.Append(join.ToSql());
}
if (TopRows > 0)
{
sqlBuilder.Append(string.Format("{0} {1} {2} {3} ", Verb, EntityMapper.SqlGenerator.Top, TopRows, string.Join(",", selectFields)));
}
else
{
sqlBuilder.Append(string.Format("{0} {1} ", Verb, string.Join(",", selectFields)));
}
sqlBuilder.Append(string.Format("FROM {0} {1} ", TableName, TableAlias));
sqlBuilder.Append(sqlJoinBuilder.ToString());
if (PredicateParts != null && PredicateParts.Any())
{
sqlBuilder.Append(string.Format("WHERE {0} ", PredicateParts.ToSql()));
}
else if (Predicate != null)
{
sqlBuilder.Append(string.Format("WHERE {0} ", Predicate.ToSql()));
}
if (OrderByFields != null)
{
sqlBuilder.Append(string.Format("ORDER BY {0}", string.Join(",", OrderByFields.Select(f => f.ToSql()))));
}
return(sqlBuilder.ToString());
}
public override string ToSql()
{
if (Fields == null || !Fields.Any())
{
return(string.Empty);
}
var sqlJoinBuilder = new StringBuilder();
var sqlBuilder = new StringBuilder();
var predicateSql = string.Empty;
var includeDbName = EntityMapper.SqlGenerator.IncludeDbNameInQuery;
var dbNameFormatted = string.Format("[{0}].", DatabaseName);
if (PredicateParts != null)
{
predicateSql = PredicateParts.ToSql();
}
else
{
predicateSql = Predicate == null ? "" : Predicate.ToSql();
}
foreach (var join in Joins)
{
sqlJoinBuilder.Append(join.ToSql());
}
sqlBuilder.AppendFormat("{0} [{1}] SET {2} FROM {3}[{4}].[{5}] [{1}] {6} WHERE {7}; ",
Verb,
TableAlias,
SetClause.ToSql(),
includeDbName ? dbNameFormatted : "",
SchemaName,
TableName,
sqlJoinBuilder.ToString(),
predicateSql);
sqlBuilder.Append("SELECT @@ROWCOUNT;");
return(sqlBuilder.ToString());
}
public override string ToSql()
{
if (Fields == null || !Fields.Any())
{
return(string.Empty);
}
var sqlBuilder = new StringBuilder();
var predicateSql = string.Empty;
if (PredicateParts != null)
{
predicateSql = PredicateParts.ToSql();
}
else
{
predicateSql = Predicate == null ? "" : Predicate.ToSql();
}
if (Predicate == null && PredicateParts == null)
{
sqlBuilder.AppendFormat("{0} {1}.{2} SET {3} ",
Verb,
SchemaName,
TableName,
SetClause.ToSql());
}
else
{
sqlBuilder.AppendFormat("{0} {1}.{2} SET {3} WHERE {4} ",
Verb,
SchemaName,
TableName,
SetClause.ToSql(),
predicateSql);
}
return(sqlBuilder.ToString());
}
