{"id":1945,"date":"2011-02-02T16:44:30","date_gmt":"2011-02-02T07:44:30","guid":{"rendered":"http:\/\/www.moonmile.net\/blog\/archives\/1945"},"modified":"2011-02-02T16:47:29","modified_gmt":"2011-02-02T07:47:29","slug":"asp-net-mvc-%e3%81%8b%e3%82%89-wordpress-%e3%81%ae%e3%83%87%e3%83%bc%e3%82%bf%e3%82%92%e6%89%b1%e3%81%863","status":"publish","type":"post","link":"http:\/\/www.moonmile.net\/blog\/archives\/1945","title":{"rendered":"ASP.NET MVC \u304b\u3089 wordpress \u306e\u30c7\u30fc\u30bf\u3092\u6271\u3046(3)"},"content":{"rendered":"

\n\u5b9f\u306fEDM(Entity Data Model)\u3067\u306f\u3001\u3042\u3089\u304b\u3058\u3081\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3067\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u3092\u8a2d\u5b9a\u3057\u3066\u304a\u304f\u3068\u3001\u30e2\u30c7\u30eb\u306e\u307b\u3046\u3067\u30a2\u30bd\u30b7\u30a8\u30fc\u30b7\u30e7\u30f3\u304c\u8a2d\u5b9a\u3055\u308c\u307e\u3059…\u3063\u3066\u3001\u306a\u3093\u3060\u304b\u5206\u304b\u308a\u307e\u305b\u3093\u306d(\u6c57)\n<\/p>\n

\n\u8981\u306f\u3001\u3053\u3093\u306a\u611f\u3058\u3067\u3059\u3002
\n\u6700\u521d\u306e SQL Server 2008 R2 \u4e0a\u3067\u3001\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u3092\u8a2d\u5b9a\u3057\u307e\u3059\u3002\n<\/p>\n

<\/a><\/p>\n

\n\u30c0\u30a4\u30a2\u30b0\u30e9\u30e0\u3067\u306f\u3053\u3093\u306a\u98a8\u3002\n<\/p>\n

<\/a><\/p>\n

\n\u3053\u306e\u3042\u305f\u308a\u3001.NET \u30e9\u30dc\u306e\u52c9\u5f37\u4f1a\u3067\u8a71\u3057\u305f\u306e\u3067\u3059\u304c\u3001SQL Server Management Studio \u306f\u305d\u308c\u306a\u308a\u306b\u65b0\u3057\u304f\u306a\u3063\u3066\u3044\u304f\u306e\u306b\u3001\u3053\u306e\u30c0\u30a4\u30a2\u30b0\u30e9\u30e0\u306f SQL Server 7.0 \u306e\u9803\u3068\u5909\u308f\u308a\u6620\u3048\u3057\u307e\u305b\u3093\u3002\u6642\u4ee3\u9045\u308c\u306a\u306e\u304b\u3001\u8ab0\u3082\u4f7f\u3063\u3066\u3044\u306a\u3044\u306e\u304b\u3068\u3044\u3046\u3068\u3053\u308d\u3067\u3059\u304c\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u4e0a\u306e\u5916\u90e8\u30ad\u30fc\u3063\u3066\u5927\u5207\u306a\u3093\u3067\u3059\u3051\u3069\u306d\u3047\u3002\n<\/p>\n

\n\u3053\u308c\u3092 Visual Studio \u306e EDM \u3092\u66f4\u65b0\u3059\u308b\u3068\u3001\u3053\u3093\u306a\u98a8\u306b\u30a2\u30bd\u30b7\u30a8\u30fc\u30b7\u30e7\u30f3\u304c\u8a2d\u5b9a\u3055\u308c\u307e\u3059\u3002\n<\/p>\n

<\/a><\/p>\n

\n\u3061\u306a\u307f\u306b\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u4e0a\u3067\u306f\u300c\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u300d\u3068\u304b\u300c\u5916\u90e8\u30ad\u30fc\u300d\u3068\u8a00\u308f\u308c\u308b\u3093\u3067\u3059\u304c\u3001\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u6307\u5411\u306e\u65b9(CakePHP\u3068\u304b\u3082)\u306e O\/R \u30de\u30c3\u30d4\u30f3\u30b0\u306e\u4e16\u754c\u3067\u306f\u300c\u30a2\u30bd\u30b7\u30a8\u30fc\u30b7\u30e7\u30f3\u300d\u3063\u3066\u8a00\u3063\u3066\u3044\u308b\u3088\u3046\u3067\u3059\u3002\u3069\u3061\u3089\u3067\u3082\u3044\u3044\u3093\u3067\u3059\u304c\u3001\u7d71\u4e00\u3057\u3066\u307b\u3057\u3044\u3088\u3046\u306a\u6c17\u304c(\u6a5f\u80fd\u304c\u9055\u3046\u304b\u3089\u3063\u3066\u3044\u3046\u610f\u5473\u3082\u3042\u308b\u3067\u3057\u3087\u3046\u304c)\u3002\n<\/p>\n

\n\u3053\u3046\u3044\u3046\u98a8\u306b\u3057\u3066\u304a\u304f\u3068\u3001wp_posts \u30e2\u30c7\u30eb\u306e\u4e2d\u306b wp_users \u3068\u3044\u3046\u30d7\u30ed\u30d1\u30c6\u30a3(\u30ca\u30d3\u30b2\u30fc\u30b7\u30e7\u30f3)\u304c\u51fa\u6765\u304d\u307e\u3059\u3002\u9006\u5411\u304d\u306e wp_users \u30e2\u30c7\u30eb\u306e\u4e2d\u306b\u3082\u3067\u304d\u307e\u3059\u306d\u3002
\n\u3053\u308c\u306e\u30ca\u30d3\u30b2\u30fc\u30b7\u30e7\u30f3\u3092\u4f7f\u3046\u3068\u3001wp_posts.wp_users.display_name \u3068\u3044\u3046\u3088\u3046\u306b\u3001\u95a2\u4fc2\u3059\u308b\u30c6\u30fc\u30d6\u30eb\u306e\u5217\u540d\u3092\u8868\u793a\u3055\u305b\u308b\u3053\u3068\u304c\u3067\u304d\u308b\u306e\u3067\u3059\u3002\n<\/p>\n

\n\u3053\u306e\u6a5f\u80fd\u3092\u3046\u307e\u304f\u4f7f\u3046\u3068\u3001\u30d3\u30e5\u30fc\u304c\u7c21\u5358\u306b\u306a\u308a\u307e\u3059\u3002\n<\/p>\n

\n\u25a0\u30d3\u30e5\u30fc\u3092\u4f5c\u308b\n<\/p>\n

\n<%@ Page Title=&quot;&quot; Language=&quot;C#&quot; MasterPageFile=&quot;~\/Views\/Shared\/Site.Master&quot; Inherits=&quot;System.Web.Mvc.ViewPage<IEnumerable<MvcWordpress.wp_posts>>&quot; %>\n\n<asp:Content ID=&quot;Content1&quot; ContentPlaceHolderID=&quot;TitleContent&quot; runat=&quot;server&quot;>\n\tRecent\n<\/asp:Content>\n\n<asp:Content ID=&quot;Content2&quot; ContentPlaceHolderID=&quot;MainContent&quot; runat=&quot;server&quot;>\n\n    <h2>\u6700\u8fd1\u6295\u7a3f\u3057\u305f\u8a18\u4e8b<\/h2>\n    <table>\n        <tr>\n            <th>ID<\/th>\n            <th>post_date<\/th>\n            <th>post_title<\/th>\n            <th>post_author<\/th>\n            <th>User.display_name<\/th>\n            <th>guid<\/th>\n        <\/tr>\n        <% foreach (var item in Model) { %>\n            <tr>\n                <td><%: item.ID %><\/td> \n                <td><%: item.post_title %><\/td>\n                <td><%: item.post_date %><\/td>\n                <td><%: item.post_author %><\/td>\n                <td><%: item.wp_users.display_name %><\/td>\n                <td><%: item.guid %><\/td>\n            <\/tr>\n        <% } %>\n    <\/table>\n    <h2>\u6700\u8fd1\u6295\u7a3f\u3057\u305f\u8a18\u4e8b(\u30ea\u30f3\u30af\u7248)<\/h2>\n    <ul>\n        <% foreach (var item in Model) { %>\n        <li>\n            <a href=&quot;<%: item.guid %>&quot;><%: item.post_title %><\/a>\n            by <%: item.wp_users.display_name %>\n            at <%: item.post_date %>\n        <\/li>\n        <% } %>\n    <\/ul>\n<\/asp:Content>\n<\/pre>\n
\n\u6e21\u3055\u308c\u308b\u30e2\u30c7\u30eb\u306f\u3001wp_posts \u306e\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u3068\u3044\u3046\u3053\u3068\u3067\u3001IEnumerable \u3068\u6307\u5b9a\u3057\u76f4\u3057\u307e\u3059\u3002\u3053\u3046\u3059\u308b\u3068\u3001wp_posts \u306e\u5217\u540d\u306f\u305d\u306e\u307e\u307e\u4f7f\u3048\u308b\u3057\u3001\u95a2\u9023\u3059\u308b wp_users \u306e\u30c6\u30fc\u30d6\u30eb\u3082\u300c<%: item.wp_users.display_name %>\u300d\u306e\u3088\u3046\u306b\u7c21\u5358\u306b\u53c2\u7167\u3067\u304d\u307e\u3059\u3002\n<\/p>\n
\n\u25a0\u30b3\u30f3\u30c8\u30ed\u30fc\u30e9\u30fc\u3092\u76f4\u3059\n<\/p>\n
\n\u30b3\u30f3\u30c8\u30ed\u30fc\u30e9\u30fc\u306e\u307b\u3046\u306f\u3001LINQ to Entities \u306b\u76f4\u3057\u3066\u3001wp_posts \u30c6\u30fc\u30d6\u30eb\u3060\u3051\u3092\u53c2\u7167\u3059\u308b\u3088\u3046\u306b\u3057\u307e\u3059\u3002\u53c2\u7167\u5148\u306e\u30c6\u30fc\u30d6\u30eb\u306f\u3001\u81ea\u52d5\u7684\u306b\u8aad\u307f\u8fbc\u307e\u308c\u308b\u306e\u3067 LINQ \u81ea\u4f53\u3082\u7c21\u5358\u306b\u306a\u308a\u307e\u3059\u3002\n<\/p>\n
\npublic ActionResult Recent()\n{\n    int max = 5;\n    wordpressEntities ent = new wordpressEntities();\n    var model = (from p in ent.wp_posts\n                 where p.post_status == "publish"\n                 orderby p.post_date descending\n                 select p).Take(max);\n\n    return View(model);\n}\n<\/pre>\n
\n\u3053\u306e\u3042\u305f\u308a\u3001CakePHP \u306e Model::$belongsTo \u3068\u540c\u3058\u3088\u3046\u306a\u4f7f\u3044\u65b9\u304c\u3067\u304d\u307e\u3059\u3002\u3068\u3044\u3046\u304b\u3001\u540c\u3058\u3088\u3046\u306b\u3059\u308b\u305f\u3081\u306b\u5916\u90e8\u30ad\u30fc\/\u30a2\u30bd\u30b7\u30a8\u30fc\u30b7\u30e7\u30f3\/\u30ca\u30d3\u30b2\u30fc\u30b7\u30e7\u30f3<\/b>\u3092\u5229\u7528\u3059\u308b\u8a33\u3067\u3059\u3002\n<\/p>\n
\n\u5b9f\u884c\u3059\u308b\u3068\u3059\u3093\u306a\u308a\u52d5\u304d\u307e\u3059\u3002\n<\/p>\n
<\/a><\/p>\n
\n\u3053\u3093\u306a\u8a33\u3067\u30011\u6bb5\u968e\u306e\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u306f\u7c21\u5358\u306b\u3067\u304d\u308b\u306e\u3067\u3059\u304c\u3001\u3055\u3066\u30014\u3064\u306e\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u306e\u5834\u5408\u306f\u3069\u3046\u3059\u308b\u3093\u3067\u3057\u3087\u3046\u306d\u3048\uff1f<\/p>\n","protected":false},"excerpt":{"rendered":"
\u5b9f\u306fEDM(Entity Data Model)\u3067\u306f\u3001\u3042\u3089\u304b\u3058\u3081\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3067\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u3092\u8a2d\u5b9a\u3057\u3066\u304a\u304f\u3068\u3001\u30e2\u30c7\u30eb\u306e\u307b\u3046\u3067\u30a2\u30bd\u30b7\u30a8\u30fc\u30b7\u30e7\u30f3\u304c\u8a2d\u5b9a\u3055\u308c\u307e\u3059…\u3063\u3066\u3001\u306a\u3093\u3060\u304b\u5206\u304b\u308a\u307e\u305b\u3093\u306d(\u6c57) \u8981\u306f\u3001\u3053\u3093\u306a\u611f\u3058\u3067 … \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":[19,13],"tags":[],"class_list":["post-1945","post","type-post","status-publish","format-standard","hentry","category-asp-net","category-wordpress"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.moonmile.net\/blog\/wp-json\/wp\/v2\/posts\/1945","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=1945"}],"version-history":[{"count":1,"href":"http:\/\/www.moonmile.net\/blog\/wp-json\/wp\/v2\/posts\/1945\/revisions"}],"predecessor-version":[{"id":1946,"href":"http:\/\/www.moonmile.net\/blog\/wp-json\/wp\/v2\/posts\/1945\/revisions\/1946"}],"wp:attachment":[{"href":"http:\/\/www.moonmile.net\/blog\/wp-json\/wp\/v2\/media?parent=1945"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.moonmile.net\/blog\/wp-json\/wp\/v2\/categories?post=1945"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.moonmile.net\/blog\/wp-json\/wp\/v2\/tags?post=1945"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}