in

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

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

LINQ nullable への条件指定

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

    LINQ nullable への条件指定

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

    namespace ConsoleApplication5
    {
        class Program
        {
            static void Main(string[ args)
            {
                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;

                int? num = null;

                var rs = from t in db.Table_1 where t.Number == (num ?? t.Number) select t;

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

                Console.Read();
            }
        }
    }

    タグ: , ,
  • 2007/12/28 10:56 回答元:

    Re: LINQ nullable への条件指定

    SELECT [t0].[ID], [t0].[Number]
    FROM [dbo].[Table_1] AS [t0]
    WHERE [t0].[Number] = (COALESCE(@p0,[t0].[Number]))
    -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [Null]
    -- Context: SqlProvider(Sql2005) Model: AttributedMetaModel Build: 3.5.21022.8

  • 2007/12/28 10:57 回答元:

    Re: LINQ nullable への条件指定

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

    namespace ConsoleApplication5
    {
        class Program
        {
            static void Main(string[ args)
            {
                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;

                int? num = 1111;

                var rs = from t in db.Table_1 where t.Number == (num ?? t.Number) select t;

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

                Console.Read();
            }
        }
    }

  • 2007/12/28 10:58 回答元:

    Re: LINQ nullable への条件指定

    SELECT [t0].[ID], [t0].[Number]
    FROM [dbo].[Table_1] AS [t0]
    WHERE [t0].[Number] = (COALESCE(@p0,[t0].[Number]))
    -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [1111]
    -- Context: SqlProvider(Sql2005) Model: AttributedMetaModel Build: 3.5.21022.8
    タグ:
ページ 1 / 1 (4 アイテム)