private void JoinToString(Join join, StringBuilder sb, bool modifySelf)
{
sb.Append(join.GetKeyword());
sb.Append(' ');
sb.Append(join.Table);
// joinAlias belirtilmişse ekle
if (!string.IsNullOrEmpty(join.Name))
{
sb.Append(' ');
sb.Append(join.Name);
}
if (!ReferenceEquals(null, join.OnCriteria) &&
!join.OnCriteria.IsEmpty)
{
sb.Append(" ON (");
if (modifySelf)
{
sb.Append(join.OnCriteria.ToString(this));
}
else
{
sb.Append(join.OnCriteria.ToStringIgnoreParams());
}
sb.Append(')');
}
}
private void JoinToString(Join join, StringBuilder sb, bool modifySelf)
{
sb.Append(join.GetKeyword());
sb.Append(' ');
sb.Append(SqlSyntax.AutoBracketValid(join.Table));
// joinAlias belirtilmişse ekle
if (!string.IsNullOrEmpty(join.Name))
{
sb.Append(' ');
sb.Append(join.Name);
}
if (!ReferenceEquals(null, join.OnCriteria) &&
!join.OnCriteria.IsEmpty)
{
sb.Append(" ON (");
if (modifySelf)
sb.Append(join.OnCriteria.ToString(this));
else
sb.Append(join.OnCriteria.ToStringIgnoreParams());
sb.Append(')');
}
}
public SqlQuery Join(Join join)
{
if (join == null)
{
throw new ArgumentNullException("join");
}
if (from.Length > 0)
{
from.Append(" \n");
}
from.Append(join.GetKeyword());
from.Append(' ');
from.Append(join.Table);
// joinAlias belirtilmişse ekle
if (!join.Name.IsNullOrEmpty())
{
from.Append(' ');
from.Append(join.Name);
if (aliases == null)
{
aliases = new HashSet <string>(StringComparer.OrdinalIgnoreCase);
}
aliases.Add(join.Name);
}
if (!ReferenceEquals(null, join.OnCriteria) &&
!join.OnCriteria.IsEmpty)
{
from.Append(" ON (");
from.Append(join.OnCriteria.ToString(this));
from.Append(')');
}
return(this);
}
private void JoinToString(Join join, StringBuilder sb, bool modifySelf)
{
sb.Append(join.GetKeyword());
sb.Append(' ');
sb.Append(SqlSyntax.AutoBracketValid(join.Table));
// joinAlias belirtilmişse ekle
if (!string.IsNullOrEmpty(join.Name))
{
sb.Append(' ');
sb.Append(join.Name);
}
if (join.OnCriteria is object &&
!join.OnCriteria.IsEmpty)
{
sb.Append(" ON ");
if (!(join.OnCriteria is BinaryCriteria))
{
sb.Append('(');
}
if (modifySelf)
{
sb.Append(join.OnCriteria.ToString(this));
}
else
{
sb.Append(join.OnCriteria.ToStringIgnoreParams());
}
if (!(join.OnCriteria is BinaryCriteria))
{
sb.Append(')');
}
}
}
