JoinType() public static method

public static JoinType ( QualifiedJoinType jType, JoinHint jHint ) : string
jType QualifiedJoinType
jHint JoinHint
return string
Example #1
0
        internal override string ToString(string indent)
        {
            var sb = new StringBuilder(32);

            sb.Append(FirstTableRef.ToString(indent) + "\n");

            sb.AppendFormat(" {1}{0}\n ", TsqlFragmentToString.JoinType(QualifiedJoinType, JoinHint), indent);

            //if (SecondTableRef.OneLine())
            //{
            //    sb.Append(SecondTableRef.ToString());
            //}
            //else
            //{
            //sb.Append("\r\n");
            sb.Append(SecondTableRef.ToString(indent));
            //}

            sb.Append("\n" + indent + "ON ");

            //if (JoinCondition.OneLine())
            //{
            //    sb.Append(JoinCondition.ToString());
            //}
            //else
            //{
            //sb.Append("\r\n");
            sb.Append(JoinCondition.ToString(""));
            //}

            return(sb.ToString());
        }
Example #2
0
        internal override string ToString(string indent)
        {
            var sb = new StringBuilder(32);

            if (OneLine())
            {
                if (FirstTableRef != null)
                {
                    sb.AppendFormat("{0}{1} ", indent, FirstTableRef.ToString(""));
                }
                sb.Append(TsqlFragmentToString.JoinType(UnqualifiedJoinType));
                sb.AppendFormat(" {0}", SecondTableRef.ToString(""));
            }
            else
            {
                if (FirstTableRef != null)
                {
                    sb.Append(FirstTableRef.ToString(indent + "  "));
                    sb.Append("\r\n");
                }
                sb.AppendFormat("{0}  {1}\r\n", indent, TsqlFragmentToString.JoinType(UnqualifiedJoinType));
                sb.Append(SecondTableRef.ToString(indent + "  "));
            }

            return(sb.ToString());
        }
Example #3
0
        internal override string ToString(string indent)
        {
            var sb = new StringBuilder(32);

            sb.Append(FirstTableRef.ToString(indent) + "\n");

            sb.AppendFormat(" {1}\t{0} ", TsqlFragmentToString.JoinType(UnqualifiedJoinType), indent);

            //if (SecondTableRef.OneLine())
            //{
            //    sb.Append(SecondTableRef);
            //}
            //else
            {
                //sb.Append("\r\n");
                sb.Append(SecondTableRef.ToString(""));
            }

            return(sb.ToString());
        }