in

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

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

LINQ 内部結合(JOIN)

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

    LINQ 内部結合(JOIN)

    using System;
    using System.Linq;
    using System.Collections.Generic;
    using System.IO;

    namespace ConsoleApplication5
    {
        class Program
        {
            static void Main(string[ args)
            {
                using (Test1 db = new Test1(Settings1.Default.ConnectionString))
                {
                    StreamWriter sw = new StreamWriter(@"d:\log.txt");
                    sw.AutoFlush = true;
                    TextWriter tw = TextWriter.Synchronized(sw);

                    db.Log = tw;

                    var rs = from t1 in db.Table_1
                             join t3 in db.Table_3
                             on new { t1.ID } equals new { t3.ID }
                             select new { t1.ID, t3.FirstName, t3.LastName };

                    foreach (var r in rs) Console.WriteLine(r);
                }

                Console.Read();
            }
        }
    }

    タグ: ,
  • 2007/12/23 12:16 回答元:

    Re: LINQ 内部結合(JOIN)

    SELECT [t0].[ID], [t1].[FirstName], [t1].[LastName]
    FROM [dbo].[Table_1] AS [t0]
    INNER JOIN [dbo].[Table_3] AS [t1] ON [t0].[ID] = [t1].[ID]
    -- Context: SqlProvider(Sql2005) Model: AttributedMetaModel Build: 3.5.21022.8

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