C# (CSharp) QueryMethods.CrossJoinWithJoinの例

コード例 #1

        public void JoinTest()
        {
            QueryMethods.InnerJoinWithJoin(new AdventureWorks());
            QueryMethods.InnerJoinWithSelect(new AdventureWorks());
            QueryMethods.InnerJoinWithSelectMany(new AdventureWorks());
            QueryMethods.InnerJoinWithSelectAndRelationship(new AdventureWorks());
            QueryMethods.InnerJoinWithSelectManyAndRelationship(new AdventureWorks());
            QueryMethods.InnerJoinWithMultipleKeys(new AdventureWorks());
            QueryMethods.MultipleInnerJoinsWithRelationship(new AdventureWorks());
            QueryMethods.InnerJoinWithGroupJoinAndSelectMany(new AdventureWorks());
            QueryMethods.LeftOuterJoinWithGroupJoin(new AdventureWorks());
            QueryMethods.LeftOuterJoinWithGroupJoinAndSelectMany(new AdventureWorks());
            QueryMethods.LeftOuterJoinWithSelect(new AdventureWorks());
            QueryMethods.LeftOuterJoinWithSelectMany(new AdventureWorks());
#if NETFX
            QueryMethods.LeftOuterJoinWithSelectAndRelationship(new AdventureWorks());
#else
            try
            {
                QueryMethods.LeftOuterJoinWithSelectAndRelationship(new AdventureWorks());
                Assert.Fail();
            }
            catch (ArgumentOutOfRangeException exception)
            {
                Trace.WriteLine(exception);
            }
#endif
#if NETFX
            QueryMethods.LeftOuterJoinWithSelectManyAndRelationship(new AdventureWorks());
#else
            try
            {
                QueryMethods.LeftOuterJoinWithSelectManyAndRelationship(new AdventureWorks());
                Assert.Fail();
            }
            catch (ArgumentOutOfRangeException exception)
            {
                Trace.WriteLine(exception);
            }
#endif
            QueryMethods.CrossJoinWithSelectMany(new AdventureWorks());
            QueryMethods.CrossJoinWithJoin(new AdventureWorks());
            QueryMethods.SelfJoin(new AdventureWorks());
        }

コード例 #2

ファイル: QueryMethodsTests.cs プロジェクト: xtmhm2000/CodeSnippets

 public void JoinTest()
 {
     QueryMethods.InnerJoinWithJoin();
     QueryMethods.InnerJoinWithSelectMany();
     QueryMethods.InnerJoinWithGroupJoin();
     QueryMethods.InnerJoinWithSelect();
     QueryMethods.InnerJoinWithAssociation();
     QueryMethods.MultipleInnerJoinsWithAssociations();
     QueryMethods.InnerJoinWithMultipleKeys();
     QueryMethods.InnerJoinWithGroupJoin();
     QueryMethods.LeftOuterJoinWithGroupJoin();
     QueryMethods.LeftOuterJoinWithSelect();
     QueryMethods.LeftOuterJoinWithGroupJoinAndSelectMany();
     QueryMethods.LeftOuterJoinWithSelectAndSelectMany();
     QueryMethods.LeftOuterJoinWithAssociation();
     QueryMethods.CrossJoinWithSelectMany();
     QueryMethods.CrossJoinWithJoin();
     QueryMethods.SelfJoin();
 }

コード例 #3

 public void JoinTest()
 {
     QueryMethods.InnerJoinWithJoin(new AdventureWorks());
     QueryMethods.InnerJoinWithSelect(new AdventureWorks());
     QueryMethods.InnerJoinWithSelectMany(new AdventureWorks());
     QueryMethods.InnerJoinWithSelectAndRelationship(new AdventureWorks());
     QueryMethods.InnerJoinWithSelectManyAndRelationship(new AdventureWorks());
     QueryMethods.InnerJoinWithMultipleKeys(new AdventureWorks());
     QueryMethods.MultipleInnerJoinsWithRelationship(new AdventureWorks());
     QueryMethods.InnerJoinWithGroupJoinAndSelectMany(new AdventureWorks());
     QueryMethods.LeftOuterJoinWithGroupJoin(new AdventureWorks());
     QueryMethods.LeftOuterJoinWithGroupJoinAndSelectMany(new AdventureWorks());
     QueryMethods.LeftOuterJoinWithSelect(new AdventureWorks());
     QueryMethods.LeftOuterJoinWithSelectMany(new AdventureWorks());
     QueryMethods.LeftOuterJoinWithSelectAndRelationship(new AdventureWorks());
     QueryMethods.LeftOuterJoinWithSelectManyAndRelationship(new AdventureWorks());
     QueryMethods.CrossJoinWithSelectMany(new AdventureWorks());
     QueryMethods.CrossJoinWithJoin(new AdventureWorks());
     QueryMethods.SelfJoin(new AdventureWorks());
 }