{"id":1983,"date":"2011-02-04T11:16:33","date_gmt":"2011-02-03T17:16:33","guid":{"rendered":"http:\/\/www.moonmile.net\/blog\/archives\/1983"},"modified":"2011-02-04T11:18:19","modified_gmt":"2011-02-04T02:18:19","slug":"linq-to-entities-%e3%81%ae%e5%ae%9f%e8%a1%8c%e3%82%af%e3%82%a8%e3%83%aa%e3%82%92%e8%a1%a8%e7%a4%ba%e3%81%99%e3%82%8b","status":"publish","type":"post","link":"http:\/\/www.moonmile.net\/blog\/archives\/1983","title":{"rendered":"LINQ to Entities \u306e\u5b9f\u884c\u30af\u30a8\u30ea\u3092\u8868\u793a\u3059\u308b"},"content":{"rendered":"

\nLINQ to SQL \u306e\u5834\u5408\u306f Log \u30d7\u30ed\u30d1\u30c6\u30a3\u3092\u4f7f\u3046\n<\/p>\n

\nLINQ to SQL\u306e\u30ed\u30b0\u51fa\u529b\u3092Visual Studio\u306e\uff3b\u51fa\u529b\uff3d\u30a6\u30a3\u30f3\u30c9\u30a6\u306b\u51fa\u529b\u3059\u308b\u306b\u306f\uff1f\uff3b3.5\u3001C#\u3001VB\uff3d \uff0d \uff20IT
\nhttp:\/\/www.atmarkit.co.jp\/fdotnet\/dotnettips\/801linqoutput\/linqoutput.html<\/a>\n<\/p>\n

\n\u3063\u3066\u3053\u3068\u3067\u826f\u3044\u306e\u3067\u3059\u304c\u3001LINQ to Entities \u306e\u5834\u5408\u306f\u3001ObjectQuery \u30af\u30e9\u30b9\u306b\u30ad\u30e3\u30b9\u30c8\u3057\u3066 ToTraceString \u3092\u4f7f\u3046\u3063\u3066\u306e\u304c\u5e38\u5957\u624b\u6bb5\u3089\u3057\u3044\u3067\u3059\u3002\n<\/p>\n

\n[C#]LINQ to Entities\u3067\u767a\u884c\u3055\u308c\u3066\u3044\u308bSQL\u6587\u3092\u898b\u305f\u3044
\nhttp:\/\/blogs.wankuma.com\/kazuki\/archive\/2009\/06\/01\/173926.aspx<\/a>\n<\/p>\n

\n\u4e0a\u3067\u793a\u3055\u308c\u3066\u3044\u308b\u3088\u3046\u306a\u30e1\u30bd\u30c3\u30c9\u3092\u4f5c\u308c\u3070\u3088\u3044\u306e\u3067\u3001ASP.NET MVC \u3067 CakePHP \u98a8\u306a\u5b9f\u884c\u30af\u30a8\u30ea\u3092\u8868\u793a\u3059\u308b\u3088\u3046\u306b\u3057\u3066\u307f\u307e\u3059\u3002\u30af\u30a8\u30ea\u3092\u8868\u793a\u3055\u305b\u308b\u3068 SQL Server Management Studio \u306a\u3069\u3067\u5b9f\u884c\u3067\u304d\u308b\u306e\u3067\u78ba\u8a8d\u304c\u697d\u306a\u3093\u3067\u3059\u3088\u306d\u3002\u5f8c\u3001\u5909\u306a\u30af\u30a8\u30ea\u3092\u3057\u3066\u3044\u306a\u3044\u304b\u3092\u78ba\u8a8d\u3067\u304d\u307e\u3059\u3002\n<\/p>\n

\r\nusing System.Data.Objects;\r\n\r\npublic static class DebugSQL\r\n{\r\n    private static string _sql;\r\n    public static string SQL\r\n    {\r\n        get\r\n        {\r\n            return _sql;\r\n        }\r\n    }\r\n    public static void ToTraceString<T>(IQueryable<T> query)\r\n    {\r\n        var objectQuery = query as ObjectQuery;\r\n        if (objectQuery != null)\r\n        {\r\n            _sql = objectQuery.ToTraceString();\r\n        }\r\n        else\r\n        {\r\n            _sql = &quot;no sql;&quot;;\r\n        }\r\n    }\r\n}\r\n<\/pre>\n
\n\u3053\u3093\u306a\u5f62\u3067\u3001static class \u3092\u5b9a\u7fa9\u3057\u3066\u304a\u304d\u307e\u3059\u3002\u3053\u308c\u3060\u30681\u56de\u306e\u30af\u30a8\u30ea\u3057\u304b\u4fdd\u5b58\u3067\u304d\u306a\u3044\u306e\u3067\u3001\u8907\u6570\u56de\u306e\u30af\u30a8\u30ea\u3082\u4fdd\u5b58\u3057\u305f\u3044\u3067\u3059\u306d\u3002\u3053\u308c\u306f\u5f8c\u7a0b\u4fee\u6b63\u3057\u307e\u3059\u3002\n<\/p>\n
\n\u305d\u3057\u3066\u30b3\u30f3\u30c8\u30ed\u30fc\u30e9\u30fc\u4e2d\u3067\u3001\n<\/p>\n
\r\n            var items = from t in ent.wp_terms\r\n                        where t.wp_term_taxonomy.FirstOrDefault().taxonomy == "category"\r\n                        select t;\r\n            DebugSQL.ToTraceString(items);\r\n<\/pre>\n
\n\u306e\u3088\u3046\u306b LINQ \u3092\u5b9f\u884c\u3057\u305f\u5f8c\u306b\u3001DebugSQL.ToTraceString \u3067 SQL \u3092\u4fdd\u5b58\u3057\u3066\u304a\u304d\u307e\u3059\u3002\n<\/p>\n
\n\u3053\u308c\u3092\u753b\u9762\u306b\u8868\u793a\u3059\u308b\u6642\u306b\u306f\u3001CakePHP \u306e\u3088\u3046\u306b\u30de\u30b9\u30bf\u30fc\u30da\u30fc\u30b8\u3092\u4f7f\u3044\u305f\u3044\u306e\u3067\u3001Site.Master \u3092\u5909\u66f4\u3057\u307e\u3059\u3002\n<\/p>\n
\r\n        <div id=&quot;main&quot;>\r\n            <asp:ContentPlaceHolder ID=&quot;MainContent&quot; runat=&quot;server&quot; \/>\r\n            <div id=&quot;debug&quot;>\r\n                <h2>\u5b9f\u884c\u30af\u30a8\u30ea<\/h2>\r\n                <%: ViewData[&quot;SQL&quot;] %>\r\n            <\/div>\r\n            <div id=&quot;footer&quot;>\r\n            <\/div>\r\n        <\/div>\r\n<\/pre>\n
\n\u3053\u3093\u306a\u98a8\u306b ViewData \u3092\u4f7f\u3048\u3070\u3044\u3044\u3067\u3059\u3002\n<\/p>\n
\n\u3053\u308c\u3092\u8a2d\u5b9a\u3059\u308b\u305f\u3081\u306b\u3001\u30b3\u30f3\u30c8\u30ed\u30fc\u30e9\u30fc\u3067 ViewData \u3092\u6307\u5b9a\u3057\u307e\u3059\u3002\n<\/p>\n
\r\npublic ActionResult Index()\r\n{\r\n    Models.CategoryModel cate = new Models.CategoryModel();\r\n    var model = cate.GetCategories();\r\n    ViewData["SQL"] = Models.DebugSQL.SQL;\r\n    return View(model);\r\n}\r\n<\/pre>\n
\nCakePHP \u3067\u306f\u30ec\u30a4\u30a2\u30a6\u30c8\u306e\u30da\u30fc\u30b8\u3067\u5b9f\u884cSQL\u3092\u8868\u793a\u3057\u3066\u3044\u308b\u306e\u3067\u3001\u3053\u306e\u624b\u306e\u30c7\u30d0\u30c3\u30b0\u60c5\u5831\u306f\u30b3\u30f3\u30c8\u30ed\u30fc\u30e9\u30fc\u3084\u30e2\u30c7\u30eb\u306b\u306f\u66f8\u304d\u305f\u304f\u306a\u3044\u3068\u3053\u308d\u3067\u3059\u3088\u306d\u3002\u3002\u3002\u3061\u3087\u3063\u3068\u5de5\u592b\u3057\u305f\u3044\u3068\u3053\u308d\u3067\u3059\u3002\n<\/p>\n
\n\u307e\u3041\u3001\u305d\u308c\u3067\u3082\u4e00\u5fdc\u3001\u5b9f\u884c\u3059\u308b\u3068\u3046\u307e\u304f\u30af\u30a8\u30ea\u304c\u53d6\u308c\u307e\u3059\u3002\n<\/p>\n
<\/a><\/p>\n
\n\u3053\u306e\u30af\u30a8\u30ea\u3092 SQL Serve Management Studio \u3067\u5b9f\u884c\u3059\u308b\u3068\u3053\u3093\u306a\u611f\u3058\u3002\n<\/p>\n
<\/a><\/p>\n
\n\u5b9f\u306f\u3001Visual Studio 2010 \u4e0a\u3067\u3082\u30af\u30a8\u30ea\u304c\u5b9f\u884c\u3067\u304d\u3066\u3001\u30b5\u30fc\u30d0\u30fc\u30a8\u30af\u30b9\u30d7\u30ed\u30fc\u30e9\u30fc\u304b\u3089\u300c\u65b0\u3057\u3044\u30af\u30a8\u30ea\u300d\u3067\u30da\u30a4\u30f3\u3092\u958b\u3051\u307e\u3059\u3002\n<\/p>\n
<\/a><\/p>\n
\n\u4f59\u5206\u306a\u30a6\u30a3\u30f3\u30c9\u30a6\u3092\u6d88\u3057\u3066\u3001\u30af\u30a8\u30ea\u3092\u5b9f\u884c\u3059\u308b\u3068(\u4f59\u8a08\u306a\u3053\u3068\u306b)\u30af\u30a8\u30ea\u6587\u3092\u6574\u5f62\u3057\u3066\u304f\u308c\u307e\u3059\u3002\n<\/p>\n
<\/a><\/p>\n
\n\u5143\u306e\u30af\u30a8\u30ea\u6587\u304c\u6b8b\u3089\u306a\u3044\u306e\u3067\u3061\u3087\u3063\u3068\u4e0d\u5b89\u306a\u306e\u3067\u3059\u304c\u3001\u3046\u307e\u304f\u30b5\u30d6\u30af\u30a8\u30ea\u306b\u306a\u3063\u3066\u3044\u308b(\u7b11)\u3053\u3068\u304c\u308f\u304b\u308a\u307e\u3059\u3002\n<\/p>\n
\n\u51fa\u529b\u3055\u308c\u305f\u7d50\u679c\u304c\u5fae\u5999\u306a\u30b5\u30d6\u30af\u30a8\u30ea\u306b\u306a\u3063\u3066\u3044\u308b\u3068\u3053\u308d\u304c\u4e0d\u5b89\u3092\u91b8\u3057\u51fa\u3057\u307e\u3059\u3002\u30a2\u30bd\u30b7\u30a8\u30fc\u30b7\u30e7\u30f3\u7d4c\u7531\u3067\u30af\u30a8\u30ea\u3092\u639b\u3051\u308b\u3068\u3053\u3093\u306a\u611f\u3058\u306b\u306a\u308b\u3093\u3067\u3059\u306d\u3047\u3002\u308f\u3056\u308f\u3056 TOP \u3092\u4f7f\u3063\u3066\u30b5\u30d6\u30af\u30a8\u30ea\u306b\u306a\u3063\u3066\u3044\u308b\u306e\u306f FirstOrDefault \u30e1\u30bd\u30c3\u30c9\u3092\u4f7f\u3063\u3066\u3044\u308b\u304b\u3089\u306a\u306e\u3067\u3001\u3053\u306e\u3042\u305f\u308a\u306f EDM \u306e \u30a2\u30bd\u30b7\u30a8\u30fc\u30b7\u30e7\u30f3\u3092 1\u5bfe1 \u306b\u3059\u308c\u3070\u76f4\u308b\u306e\u304b\u3082\u3057\u308c\u307e\u305b\u3093\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
LINQ to SQL \u306e\u5834\u5408\u306f Log \u30d7\u30ed\u30d1\u30c6\u30a3\u3092\u4f7f\u3046 LINQ to SQL\u306e\u30ed\u30b0\u51fa\u529b\u3092Visual Studio\u306e\uff3b\u51fa\u529b\uff3d\u30a6\u30a3\u30f3\u30c9\u30a6\u306b\u51fa\u529b\u3059\u308b\u306b\u306f\uff1f\uff3b3.5\u3001C#\u3001VB\uff3d \uff0d \uff20IT http:\/\/www.atm … \u7d9a\u304d\u3092\u8aad\u3080 →<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[3,19],"tags":[],"class_list":["post-1983","post","type-post","status-publish","format-standard","hentry","category-dev","category-asp-net"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.moonmile.net\/blog\/wp-json\/wp\/v2\/posts\/1983","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.moonmile.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.moonmile.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.moonmile.net\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/www.moonmile.net\/blog\/wp-json\/wp\/v2\/comments?post=1983"}],"version-history":[{"count":1,"href":"http:\/\/www.moonmile.net\/blog\/wp-json\/wp\/v2\/posts\/1983\/revisions"}],"predecessor-version":[{"id":1984,"href":"http:\/\/www.moonmile.net\/blog\/wp-json\/wp\/v2\/posts\/1983\/revisions\/1984"}],"wp:attachment":[{"href":"http:\/\/www.moonmile.net\/blog\/wp-json\/wp\/v2\/media?parent=1983"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.moonmile.net\/blog\/wp-json\/wp\/v2\/categories?post=1983"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.moonmile.net\/blog\/wp-json\/wp\/v2\/tags?post=1983"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}