コード例 #1
0
        public static string GetJoinOperatorString(SQLiteJoinOperator join)
        {
            StringBuilder sb = new StringBuilder();

            if ((join & SQLiteJoinOperator.Natural) != 0)
            {
                sb.Append("NATURAL");
            }
            if ((join & SQLiteJoinOperator.Inner) != 0)
            {
                sb.Append(" INNER");
            }
            if ((join & SQLiteJoinOperator.Cross) != 0)
            {
                sb.Append(" CROSS");
            }
            if ((join & SQLiteJoinOperator.Left) != 0)
            {
                sb.Append(" LEFT");
            }
            if ((join & SQLiteJoinOperator.Outer) != 0)
            {
                sb.Append(" OUTER");
            }

            if (sb.Length > 0)
            {
                sb.Append(" JOIN");
                return(sb.ToString());
            }

            return(",");
        }
コード例 #2
0
 public SQLiteFromClause AddJoin(SQLiteJoinOperator join)
 {
     _tables.Add(join);
     return(this);
 }