in

@Prog! - ASP.NET(C#) AJAX -

ASP.NET(C#) 2.0 & ASP.NET Ajax (ATLAS) のメモ書き

LINQ 2つの収得した結果を結合する(UNION ALL)

最新の投稿は、投稿日時: 2008/01/02 10:40 投稿者: ASANO です。スレッドには 1 件の返答があります。
ページ 1 / 1 (2 アイテム)
投稿の並べ替え: 前へ 次へ
  • 2008/01/02 10:40

    LINQ 2つの収得した結果を結合する(UNION ALL)

    using System;
    using System.Linq;
    using System.IO;

    namespace ConsoleApplication1
    {
        class Program
        {
            static void Main(string[ args)
            {
                using (DataClasses1DataContext dataContext = new DataClasses1DataContext())
                {
                    StreamWriter sw = new StreamWriter(@"d:\log.txt");
                    sw.AutoFlush = true;
                    TextWriter tw = TextWriter.Synchronized(sw);

                    dataContext.Log = tw;

                    var rs = (
                                from t1 in dataContext.Table_1 select t1
                            ).Concat(
                                from t2 in dataContext.Table_1 select t2
                            ).OrderBy(t => t.ID);

                    foreach (var r in rs)
                        Console.WriteLine("{0}:{1}", r.ID, r.Number);
                }

                Console.ReadLine();
            }
        }
    }

    タグ: , ,
  • 2008/01/02 10:40 回答元:

    Re: LINQ 2つの収得した結果を結合する(UNION ALL)

    SELECT [t3].[ID], [t3].[Number]
    FROM (
        SELECT [t2].[ID], [t2].[Number]
        FROM (
            SELECT [t0].[ID], [t0].[Number]
            FROM [dbo].[Table_1] AS [t0]
            UNION ALL
            SELECT [t1].[ID], [t1].[Number]
            FROM [dbo].[Table_1] AS [t1]
            ) AS [t2]
        ) AS [t3]
    ORDER BY [t3].[ID]
    -- Context: SqlProvider(Sql2005) Model: AttributedMetaModel Build: 3.5.21022.8

ページ 1 / 1 (2 アイテム)