{"id":10689,"date":"2022-07-11T11:23:40","date_gmt":"2022-07-11T02:23:40","guid":{"rendered":"https:\/\/www.moonmile.net\/blog\/?p=10689"},"modified":"2022-07-11T11:32:27","modified_gmt":"2022-07-11T02:32:27","slug":"net-framework-4-7-%e3%81%8b%e3%82%89-net6-%e3%81%b8%e3%81%ae%e7%a7%bb%e8%a1%8c%e3%83%9d%e3%82%a4%e3%83%b3%e3%83%88","status":"publish","type":"post","link":"https:\/\/www.moonmile.net\/blog\/archives\/10689","title":{"rendered":".NET Framework 4.7 \u304b\u3089 .NET6 \u3078\u306e\u79fb\u884c\u30dd\u30a4\u30f3\u30c8"},"content":{"rendered":"\n<p>Windows \u4e0a\u306e .NET Framework \u304b\u3089 .NET 6 \u3078\u79fb\u884c\u3059\u308b\u3068\u304d\u306b\u3001\u969c\u5bb3\u3068\u306a\u308a\u305d\u3046\u306a\u30dd\u30a4\u30f3\u30c8\u3092\u6319\u3052\u3066\u304a\u304d\u307e\u3059\u3002\u3061\u3087\u3063\u3068\u3057\u305f Windows \u30d5\u30a9\u30fc\u30e0\u3084 WPF \u30a2\u30d7\u30ea\u306a\u3089\u3070\u3059\u3093\u306a\u308a\u4ee5\u964d\u3067\u304d\u308b\u306e\u3067\u3059\u304c\u3001\u305d\u308c\u306a\u308a\u306e\u5927\u304d\u3055\u306e C\/S \u65b9\u5f0f\u3067 Entity Framework \u3092\u4f7f\u3063\u3066\u3044\u308b\u3068\uff08\u4f7f\u3063\u3066\u3044\u308b\u3093\u3060\u304c\uff09\u3001\u79fb\u884c\u6642\u306b\u8e93\u304d\u304c\u3042\u308a\u305d\u3046\u3067\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u79fb\u884c\u5bfe\u8c61<\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li>WPF \u30a2\u30d7\u30ea\u3067\u7d0470\u753b\u9762\u3042\u308b\u3002<\/li><li>\u30c6\u30fc\u30d6\u30eb\u6570\u306f\u7d0420\u30c6\u30fc\u30d6\u30eb\u3042\u308b\u3002<\/li><li>MVVM\u30d1\u30bf\u30fc\u30f3\u3092\u4f7f\u3044\u3001View \u3068 ViewModel \u3092\u5206\u96e2\u3055\u305b\u3066\u3044\u308b<\/li><li>Model \u306f .NET Framework \u306e Entity Framework \u3092\u4f7f\u3063\u3066\u3044\u308b\u3002\u30b3\u30fc\u30c9\u30d5\u30a1\u30fc\u30b9\u30c8\u4ee5\u524d\u306e\u3001*.edmx \u30d5\u30a1\u30a4\u30eb\u3092\u4f7f\u3046\u65b9\u5f0f\uff08SQL Server \u306e\u30c6\u30fc\u30d6\u30eb\u304b\u3089\u30b3\u30fc\u30c9\u3092\u81ea\u52d5\u751f\u6210\u3059\u308b\u306e\u3067\u5f53\u6642\u306f\u4fbf\u5229\u3060\u3063\u305f\uff09<\/li><li>\u30c6\u30fc\u30d6\u30eb\u691c\u7d22\u306f\u307b\u307c LINQ \u3092\u4f7f\u3063\u3066\u3044\u308b\u304c\u3001\u79fb\u884c\u524d\u306e\u8907\u96d1\u306a SQL \u3092\u4f7f\u3046\u305f\u3081 SqlQuery \u3067\u76f4\u63a5\u547c\u3073\u51fa\u3057\u3066\u3044\u308b\u90e8\u5206\u304c\u308b\u3002<\/li><li>View \u306b\u30d0\u30a4\u30f3\u30c9\u3055\u305b\u308b\u305f\u3081\u3001Entity \u30af\u30e9\u30b9\uff08*.edmx \u306b\u3088\u308b\u81ea\u52d5\u751f\u6210\uff09\u306b\u3001\u9069\u5b9c\u30d7\u30ed\u30d1\u30c6\u30a3\u3092\u306f\u3084\u3057\u3066\u3044\u308b\u3002<\/li><li>Excel \u306e\u30b3\u30f3\u30c8\u30ed\u30fc\u30eb\u3092\u57cb\u3081\u8fbc\u3080\u305f\u3081\u3001WindowsFormsHost \u3092\u4f7f\u3063\u3066\u3044\u308b<\/li><li>Excel \u306e\u5e33\u7968\u3092\u3064\u304b\u3046\u305f\u3081\u3001Microsoft.Office.Interop.Excel \u3092\u4f7f\u3063\u3066\u3044\u308b<\/li><\/ul>\n\n\n\n<p>\u30b9\u30c6\u30c3\u30d7\u6570\u306f\u6570\u3048\u3066\u306f\u3044\u307e\u305b\u3093\u304c\u3001\u5927\u4f531\u4e07\u884c\u3092\u8d85\u3048\u308b\u4f4d\u3067\u3059\u3002\u3082\u3068\u3082\u3068\u3001ACCESS \u7248\u3092 C# \u7248\u306b\u66f8\u304d\u76f4\u3057\u305f\u3082\u306e\u3067\u3001\u3053\u308c\u3092\u8a66\u3057\u306b .NET6 \u306b\u79fb\u305d\u3046\u3068\u8a66\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u5168\u4f53\u306e\u69cb\u9020<\/h2>\n\n\n\n<p>.NET Framework \u306e WPF \u3092 .NET6 \u306e WPF \u306b\u79fb\u884c\u3059\u308b\u306e\u3067\u3001\u5168\u4f53\u306e\u30d5\u30a9\u30eb\u30c0\u30fc\u69cb\u9020\u306f\u5909\u3048\u307e\u305b\u3093\u3002 \u4e2d\u306e\u30b3\u30fc\u30c9\uff08\u7279\u306b\u30ed\u30b8\u30c3\u30af\uff09\u306b\u306f\u624b\u3092\u3044\u308c\u305f\u304f\u306a\u3044\u306e\u3067\u3001namespace \u306f\u305d\u306e\u307e\u307e\u4f7f\u3046\u3088\u3046\u306b\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Entity Framework \u306e\u79fb\u884c<\/h2>\n\n\n\n<p>.NET Framework \u306e System.Data.Entity.DbContext \u3092 .NET6 \u306e Microsoft.EntityFrameworkCore. DbContext \u306b\u79fb\u884c\u3057\u307e\u3059\u3002\u540c\u3058\u300c DbContext \u300d\u3068\u306a\u3063\u3066\u3044\u307e\u3059\u304c\u3001\u4e2d\u8eab\u306f\u5225\u7269\u3067\u3059\u3002.NET6 \u306e\u307b\u3046\u306f\u3001NuGet \u3067 &#8220;Microsoft.EntityFrameworkCore.SqlServer&#8221; \u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>.NET Framework \u306e EF \u3068\u306f\u9055\u3044\u3001*.edmx \u306e\u3088\u3046\u306a\u30c6\u30fc\u30d6\u30eb\u306e\u69cb\u9020\u3092\u5b9a\u7fa9\u3057\u305f\u30d5\u30a1\u30a4\u30eb\u304c\u3042\u308a\u307e\u305b\u3093\u3002\u30b3\u30fc\u30c9\u30d5\u30a1\u30fc\u30b9\u30c8\u7684\u306b\u30af\u30e9\u30b9\u3092\u5b9a\u7fa9\u3057\u3066\u304a\u304f\u304b\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30d5\u30a1\u30fc\u30b9\u30c8\u7684\u306b SQL Server \u304b\u3089 dotnet ef \u30b3\u30de\u30f3\u30c9\u3092\u4f7f\u3044\u30c6\u30fc\u30d6\u30eb\u30af\u30e9\u30b9\u3092\u751f\u6210\u3055\u305b\u307e\u3059\u3002\u30c6\u30fc\u30d6\u30eb\u30af\u30e9\u30b9 = Entity \u30af\u30e9\u30b9\u306f\u3001\u4ee5\u524d\u306e .NET Framework \u3068\u540c\u3058\u3082\u306e\u3092\u4f7f\u3046\u306e\u3067\uff08\u30d7\u30ed\u30d1\u30c6\u30a3\u540d\u306a\u3069\u304c\u5909\u308f\u308b\u3068\u3084\u3063\u304b\u3044\uff09.NET Framework \u7248\u306e\u3082\u306e\u3092\u30b3\u30d4\u30fc\u3057\u3066 Models \u30d5\u30a9\u30eb\u30c0\u306b\u5165\u308c\u3066\u304a\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<p>DbSet \u30af\u30e9\u30b9\u306f\u3001<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>.NET Framework \u3067\u306f System.Data.Entity.DbSet<\/li><li>.NET6 \u3067\u306f Microsoft.EntityFrameworkCore.DbSet<\/li><\/ul>\n\n\n\n<p>\u3068\u306a\u308a\u540c\u3058\u300cDbSet\u300d\u3068\u3044\u3046\u540d\u524d\u306b\u306a\u3063\u3066\u3044\u307e\u3059\u304c\u3001\u4f3c\u3066\u975e\u306a\u308b\u3082\u306e\u3067\u3059\u3002<\/p>\n\n\n\n<p>SQL Server \u306b\u63a5\u7d9a\u3059\u308b\u6587\u5b57\u5217\u306f\u3001.NET6\u306e\u5834\u5408\uff08EFCore\u306e\u5834\u5408\uff09\u306f OnConfiguring \u3092 override \u3057\u3066\u8a18\u8ff0\u3057\u307e\u3059\u3002\u5834\u5408\u306b\u3088\u3063\u3066\u306f\u3001\u8907\u6570\u306e DbContext \u3092\u5207\u308a\u66ff\u3048\u308b\u5fc5\u8981\u304c\u3042\u308b\u306e\u3067\u3001\u5916\u90e8\u304b\u3089\u5207\u308a\u66ff\u3048\u304c\u3067\u304d\u308b\u3088\u3046\u306b\u3057\u3066\u304a\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-csharp\" data-lang=\"C#\"><code>public static \u4f1a\u8b70\u5ba4Entities CreateEnt(string dbname, string servername = &quot;(local)&quot;)\n{\n    var builder = new SqlConnectionStringBuilder();\n    builder.DataSource = servername;\n    builder.InitialCatalog = dbname;\n    builder.IntegratedSecurity = true;\n    var cnstr = builder.ConnectionString;\n    var context = new \u4f1a\u8b70\u5ba4Entities();\n    context.Database.SetConnectionString(cnstr);\n    return context;\n}<\/code><\/pre><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">\u4e3b\u30ad\u30fc\u3092\u4ed8\u52a0\u3059\u308b<\/h3>\n\n\n\n<p>.NET Framework \u306e EF \u304c\u51fa\u529b\u3059\u308b Entity \u30af\u30e9\u30b9\u306f\u4e3b\u30ad\u30fc\uff08Key\u5c5e\u6027\uff09\u304c\u3042\u308a\u307e\u305b\u3093\u3002\u3053\u306e\u305f\u3081\u3001\u3053\u306e Entity \u30af\u30e9\u30b9 .NET6 \u306e EFCore \u3067\u4f7f\u3046\u3068\u5b9f\u884c\u30a8\u30e9\u30fc\u304c\u767a\u751f\u3057\u307e\u3059\u3002\u691c\u7d22\u6642\u3067\u306f\u3042\u3063\u3066\u3082\u3001\u30c7\u30d5\u30a9\u30eb\u30c8\u3067\u306f\u4e3b\u30ad\u30fc\u304c\u5fc5\u8981\u306b\u306a\u3063\u3066\u3044\u308b\u305f\u3081\u3067\u3059\u3002.NET Framework \u306e\u5834\u5408\u306f\u3067\u306f\u3001*.edmx \u30d5\u30a1\u30a4\u30eb\u306b\u4e3b\u30ad\u30fc\u306a\u3069\u306e\u30c6\u30fc\u30d6\u30eb\u69cb\u9020\u306e\u60c5\u5831\u304c\u306f\u3044\u3063\u3066\u3044\u308b\u305f\u3081\u3001Entity \u30d5\u30a1\u30a4\u30eb\u306b\u306f Key\u5c5e\u6027\u7b49\u304c\u3064\u3044\u3066\u3044\u307e\u305b\u3093\u3002<\/p>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-csharp\" data-lang=\"C#\"><code>public partial class \u4f1a\u793e\u57fa\u672c\u60c5\u5831\n{\n    public int id { get; set; }\n    public string \u4f1a\u793e\u540d { get; set; }\n    public string \u80a9\u66f8\u304d { get; set; }\n    public string TEL { get; set; }\n    public string FAX { get; set; }\n    public string \u90f5\u4fbf\u756a\u53f7 { get; set; }\n    public string \u4f4f\u62401 { get; set; }\n    public string \u4f4f\u62402 { get; set; }\n    public string \u671f\u540d\u524d { get; set; }\n    public Nullable&lt;double&gt; \u6d88\u8cbb\u7a0e { get; set; }\n    public Nullable&lt;int&gt; \u7aef\u6570\u51e6\u7406\u30b3\u30fc\u30c9 { get; set; }\n    public Nullable&lt;int&gt; \u5e74 { get; set; }\n    public Nullable&lt;System.DateTime&gt; \u671f\u9996\u65e5 { get; set; }\n    public Nullable&lt;System.DateTime&gt; \u671f\u672b\u65e5 { get; set; }\n    public string \u632f\u8fbc\u5148A { get; set; }\n    public string \u632f\u8fbc\u5148B { get; set; }\n    public string FA { get; set; }\n    public string FB { get; set; }\n    public string GA { get; set; }\n    public string GB { get; set; }\n    public string HA { get; set; }\n    public string HB { get; set; }\n}<\/code><\/pre><\/div>\n\n\n\n<p>\u3053\u3053\u306e id \u90e8\u5206\u306b Key\u5c5e\u6027\u3092\u3064\u3051\u3066\u3082\u3088\u3044\u306e\u3067\u3059\u304c\u3001\u3053\u306e\u30d5\u30a1\u30a4\u30eb\u81ea\u4f53\u306f\u3055\u308f\u308a\u305f\u304f\u306a\u3044\u306e\u3067\u3001DbContext \u306e OnModelCreating \u30e1\u30bd\u30c3\u30c9\u3067\u8abf\u7bc0\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-csharp\" data-lang=\"C#\"><code>    protected override void OnModelCreating(ModelBuilder modelBuilder)\n    {\n        base.OnModelCreating(modelBuilder);\n        modelBuilder.Entity&lt;\u30db\u30fc\u30e0\u30da\u30fc\u30b8&gt;().HasKey(x =&gt; x.ID);\n        modelBuilder.Entity&lt;\u78ba\u8a8d&gt;().HasKey(x =&gt; x.\u65e5\u4ed8);\n        modelBuilder.Entity&lt;\u671f\u9996&gt;().HasKey(x =&gt; x.ID);\n        modelBuilder.Entity&lt;\u770c&gt;().HasKey(x =&gt; x.ID);\n        modelBuilder.Entity&lt;\u9867\u5ba2&gt;().HasKey(x =&gt; x.ID);\n        modelBuilder.Entity&lt;\u9867\u5ba2SUB&gt;().HasKey(x =&gt; x.ID);\n        modelBuilder.Entity&lt;\u4e88\u7d04&gt;().HasKey(x =&gt; x.ID);\n        modelBuilder.Entity&lt;\u4e88\u7d04SUB&gt;().HasKey(x =&gt; x.ID);\n        modelBuilder.Entity&lt;\u4e88\u7d04\u78ba\u8a8d&gt;().HasKey(x =&gt; x.ID);\n        modelBuilder.Entity&lt;\u4e88\u7d04\u72b6\u6cc1&gt;().HasKey(x =&gt; x.ID);\n        modelBuilder.Entity&lt;\u4f1a\u793e\u57fa\u672c\u60c5\u5831&gt;().HasKey(x =&gt; x.id);\n<\/code><\/pre><\/div>\n\n\n\n<p>\u307e\u3081\u306b HasKey \u3067\u4e3b\u30ad\u30fc\u3092\u8a2d\u5b9a\u3057\u3066\u3084\u308c\u3070 ok \u3067\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u751f SQL \u3092\u547c\u3073\u51fa\u3057\u305f\u3068\u304d\u306e\u623b\u308a\u5024\u306e\u30af\u30e9\u30b9\u3067\u306f\u3001\u4e3b\u30ad\u30fc\u304c\u306a\u3044\u3053\u3068\u3092\u8a2d\u5b9a\u3059\u308b<\/h3>\n\n\n\n<p>\u5b9f\u30c6\u30fc\u30d6\u30eb\u3092\u53c2\u7167\u3059\u308b\u5834\u5408\u306b\u306f\u4e3b\u30ad\u30fc\u304c\u3042\u308b\u306e\u3067\u3059\u304c\u3001\u751f SQL \u3092\u4f7f\u3063\u3066\u691c\u7d22\u7d50\u679c\u3092\u8fd4\u3059\u3068\u304d\u306b\u306f\u4e3b\u30ad\u30fc\u306f\u3042\u308a\u307e\u305b\u3093\u3002\u306a\u306e\u3067\u3001.NET6 \u306e EFCore \u3067\u306f\u3001HasNoKey \u3092\u4f7f\u3063\u3066\u660e\u793a\u7684\u306b\u8a2d\u5b9a\u3057\u306a\u3044\u3068\u3044\u3051\u307e\u305b\u3093\u3002<\/p>\n\n\n\n<p>\u5168\u3066 LINQ \u3067\u6e08\u3081\u3070\u3088\u3044\u306e\u3067\u3059\u304c\u3001\u8907\u96d1\u306a join \u304c\u767a\u751f\u3059\u308b\u5834\u5408\u3001\u751f SQL \u3092\u4f7f\u3063\u305f\u3088\u3046\u304c\u826f\u3044\u5834\u5408\u304c\u3042\u308a\u307e\u3059\u3002\u4f8b\u3048\u3070\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306a SQL \u3092 LINQ \u306b\u66f8\u304d\u76f4\u3059\u306e\u306f\u304b\u306a\u308a\u56f0\u96e3\u3067\u3059\u3057\u3001\u79fb\u884c\u6642\u306b\u9593\u9055\u3044\u304c\u767a\u751f\u3057\u307e\u3059\u3002\u306a\u306e\u3067\u3001\u305d\u306e\u307e\u307e SQL \u3092\u4f7f\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-csharp\" data-lang=\"C#\"><code>        var SQL = $@&quot;\nselect\n\u4e88\u7d04.ID,\n\u9867\u5ba2.\u4f1a\u793e\u540d,\n\u4e88\u7d04.\u65e5\u4ed8,\n\u90e8\u5c4b.\u540d\u79f0 as \u4f1a\u8b70\u5ba4,\n\u4e88\u7d04\u72b6\u6cc1.\u958b\u59cb\u6642\u523b as \u958b\u59cb,\n\u4e88\u7d04\u72b6\u6cc1.\u7d42\u4e86\u6642\u523b as \u7d42\u4e86,\n\u9867\u5ba2sub.\u90e8\u7f72\u540d as \u90e8\u7f72\u540d,\n\u9867\u5ba2sub.\u62c5\u5f53\u8005A as \u62c5\u5f53\u8005,\n\u9867\u5ba2sub.TEL as TEL,\n\u9867\u5ba2sub.FAX as FAX,\n\u4e88\u7d04.\u4e88\u7d04 as \u72b6\u614b,\n\u4e88\u7d04.\u5951\u7d04\u65e5 as \u5951\u7d04\u65e5,\n\u4e88\u7d04.\u78ba\u8a8d\u7968\u6700\u7d42\u51e6\u7406\u65e5 as \u78ba\u8a8d\u65e5,\n\u8acb\u6c42.\u65e5\u4ed8 as \u8acb\u6c42\u65e5,\nX.\u5229\u7528\u6599,\nisnull(\u5165\u91d1.\u5165\u91d1\u984d,0) as \u5165\u91d1\u984d,\n\u4e88\u7d04.\u5099\u8003B as \u6ce8\u610f\u4e8b\u9805,\n\u4e88\u7d04.\u6848\u5185\u540d\u79f0 as \u6848\u5185\u677f\u540d\u79f0\nfrom \n( \nselect\n\u4e88\u7d04.ID as ID,\ncast(ISNULL(sum(\u4e88\u7d04sub.\u5358\u4fa1*\u4e88\u7d04sub.\u6570\u91cf),0) as money) as \u5229\u7528\u6599\nfrom \u4e88\u7d04\nleft join \u4e88\u7d04sub on \u4e88\u7d04sub.\u4e88\u7d04ID = \u4e88\u7d04.id\nwhere \u4e88\u7d04.\u9867\u5ba2id = {\u9867\u5ba2ID}\ngroup by \n\u4e88\u7d04.ID \n) X\ninner join \u4e88\u7d04 on \u4e88\u7d04.id = X.ID\ninner join \u9867\u5ba2 on \u9867\u5ba2.ID = \u4e88\u7d04.\u9867\u5ba2ID\ninner join \u9867\u5ba2sub on \u9867\u5ba2sub.ID = \u4e88\u7d04.\u9867\u5ba2SUBID\nleft join \u8acb\u6c42 on \u8acb\u6c42.id = \u4e88\u7d04.\u8acbNO\nleft join \u5165\u91d1 on \u5165\u91d1.\u8acb\u6c42ID = \u8acb\u6c42.ID\ninner join \u90e8\u5c4b on \u90e8\u5c4b.id = \u4e88\u7d04.\u4f1a\u8b70\u5ba4\ninner join \u4e88\u7d04\u72b6\u6cc1 on \u4e88\u7d04\u72b6\u6cc1.\u4e88\u7d04ID = \u4e88\u7d04.ID\norder by \u4e88\u7d04.\u65e5\u4ed8 desc \n&quot;;\nthis.Items = App.ent.Database.SqlQuery&lt;\u7d50\u679c&gt;(SQL).ToList();\n<\/code><\/pre><\/div>\n\n\n\n<p>\u3053\u306e\u6642\u3001\u623b\u308a\u5024\u3068\u3057\u3066\u4f7f\u3063\u3066\u3044\u308b\u300c\u7d50\u679c\u300d\u30af\u30e9\u30b9\u306f\u3001.NET Framework \u306e\u5834\u5408\u306f\u9069\u5f53\u306b\u5024\u30af\u30e9\u30b9\u3092\u4f5c\u3063\u3066\u691c\u7d22\u7d50\u679c\u3092\u53d7\u3051\u53d6\u308c\u3070\u3044\u3044\u306e\u3067\u3059\uff08\u3044\u3061\u3044\u3061\u5024\u3092\u30af\u30e9\u30b9\u3092\u4f5c\u308b\u306e\u304c\u9762\u5012\u3067\u306f\u3042\u308b\u306e\u3067\u3059\u304c\uff09\u3002<\/p>\n\n\n\n<p>\u3057\u304b\u3057\u3001.NET6 \u306e EFCore \u306b\u306f Database.SqlQuery \u306b\u76f8\u5f53\u3059\u308b\u3082\u306e\u304c\u306a\u304f\u3001DbSet&lt;T&gt;.FromSqlRaw \u3092\u4f7f\u3046\u3053\u3068\u306b\u306a\u3063\u3066\u3044\u307e\u3059\u3002\u4f7f\u3044\u65b9\u306f\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u3044\u3063\u305f\u3093 DbContext \u306b\u300c\u7d50\u679c\u300d\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u3092\u306f\u3084\u3059\u3053\u3068\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-plain\"><code>            var SQL = $@&quot;\nselect\n...\n&quot;;\nthis.Items = App.ent.\u7d50\u679c.FromSqlRaw(SQL).ToList();\n<\/code><\/pre><\/div>\n\n\n\n<p>\u3053\u308c\u306b\u4f34\u3044\u3001DbContext \u30af\u30e9\u30b9\u306b\u306f\u3001\u623b\u308a\u5024\u306e\u30af\u30e9\u30b9\u3082 DbSet&lt;T&gt; \u3067\u5b9a\u7fa9\u3057\u306a\u3044\u3068\u3044\u3051\u307e\u305b\u3093\u3002<\/p>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-csharp\" data-lang=\"C#\"><code>        \/\/ \u623b\u308a\u5024\u7528\n        public virtual DbSet&lt;ViewModels.VM\u8acb\u6c42\u4e00\u89a7.\u8acb\u6c42\u4e00\u89a7&gt; \u8acb\u6c42\u4e00\u89a7 { get; set; }\n        public virtual DbSet&lt;ViewModels.VM\u9867\u5ba2\u5c65\u6b74.\u7d50\u679c&gt; \u7d50\u679c { get; set; }\n        public virtual DbSet&lt;ViewModels.VM\u4e88\u7d04\u4e00\u89a7.Data&gt; \u4e88\u7d04\u4e00\u89a7Data { get; set; }\n        public virtual DbSet&lt;ViewModels.VM\u4e88\u7d04\u8a73\u7d30\u5165\u529b.\u5f15\u5408&gt; \u4e88\u7d04\u8a73\u7d30\u5165\u529b\u5f15\u5408 { get; set; }\n        public virtual DbSet&lt;ViewModels.VM\u5c5e\u6027\u5225\u96c6\u8a08.\u5c5e\u6027&gt; \u5c5e\u6027\u5225\u96c6\u8a08\u5c5e\u6027 { get; set; }\n        public virtual DbSet&lt;ViewModels.VM\u5e74\u9593\u30b0\u30e9\u30d5.\u5e74\u9593\u58f2\u4e0a&gt; \u5e74\u9593\u58f2\u4e0a { get; set; }\n        public virtual DbSet&lt;ViewModels.VM\u6708\u5225\u58f2\u4e0a.\u6708\u5225\u58f2\u4e0a&gt; \u6708\u5225\u58f2\u4e0a { get; set; }\n        public virtual DbSet&lt;ViewModels.VM\u8acb\u6c42\u96c6\u8a08.\u8acb\u6c42&gt; \u8acb\u6c42\u96c6\u8a08\u8acb\u6c42 { get; set; }\n        public virtual DbSet&lt;ViewModels.VM\u904e\u53bb\u4e88\u7d04\u72b6\u6cc1.\u7d50\u679c&gt; \u904e\u53bb\u4e88\u7d04\u72b6\u6cc1\u7d50\u679c { get; set; }\n        public virtual DbSet&lt;ViewModels.VM\u9867\u5ba2\u5225\u5229\u7528\u72b6\u6cc1\u96c6\u8a08.\u7d50\u679c&gt; \u9867\u5ba2\u5225\u5229\u7528\u72b6\u6cc1\u96c6\u8a08\u7d50\u679c { get; set; }\n        public virtual DbSet&lt;ViewModels.VM\u9867\u5ba2\u5229\u7528\u56de\u6570\u4e00\u89a7.\u5229\u7528\u56de\u6570&gt; \u9867\u5ba2\u5229\u7528\u56de\u6570\u4e00\u89a7\u5229\u7528\u56de\u6570 { get; set; }\n        public virtual DbSet&lt;ViewModels.VM\u9867\u5ba2\u5229\u7528\u72b6\u6cc1.\u5229\u7528\u660e\u7d30&gt; \u9867\u5ba2\u5229\u7528\u72b6\u6cc1\u5229\u7528\u660e\u7d30 { get; set; }\n<\/code><\/pre><\/div>\n\n\n\n<p>\u5b9f\u306f\u3001\u623b\u308a\u5024\u30af\u30e9\u30b9\u306f\u305d\u308c\u305e\u308c\u306e ViewModel \u30af\u30e9\u30b9\u5185\u3067\u3057\u304b\u4f7f\u308f\u306a\u3044\u306e\u3067 private \u306b\u306a\u3063\u3066\u3044\u308b\u306e\u3067\u3059\u304c\u3001.NET6 \u306e\u5834\u5408\u306b\u306f DbContext \u304b\u3089\u53c2\u7167\u3067\u304d\u308b\u3088\u3046\u306b public\uff08\u3042\u308b\u3044\u306finternal\uff09\u306e\u5909\u66f4\u304c\u5fc5\u8981\u306b\u306a\u308a\u307e\u3059\u3002\u306f\u3063\u304d\u308a\u8a00\u3063\u3066\u3001\u3053\u306e  FromSqlRaw \u306e\u4ed5\u7d44\u307f\u306f\u3088\u304f\u306a\u3044\u3067\u3059\u3002\u3082\u3068\u3082\u3068\u5185\u90e8\u30af\u30e9\u30b9\u306b\u306a\u308b\u306e\u3067\u3001\u540d\u524d\u306e\u91cd\u8907\u304c\u6fc0\u3057\u304f\u306a\u3063\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u3053\u306e\u623b\u308a\u5024\u5c02\u7528\u306e\u30af\u30e9\u30b9\u306f\u3001\u4e3b\u30ad\u30fc\u304c\u3042\u308a\u307e\u305b\u3093\u3002\u3053\u308c\u3092\u660e\u793a\u7684\u306b\u793a\u3059\u305f\u3081\u306b OnModelCreating \u5185\u3067 HasNoKey \u3092\u6307\u5b9a\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-csharp\" data-lang=\"C#\"><code>            modelBuilder.Entity&lt;ViewModels.VM\u8acb\u6c42\u4e00\u89a7.\u8acb\u6c42\u4e00\u89a7&gt;().HasNoKey();\n            modelBuilder.Entity&lt;ViewModels.VM\u9867\u5ba2\u5c65\u6b74.\u7d50\u679c&gt;().HasNoKey();\n            modelBuilder.Entity&lt;ViewModels.VM\u4e88\u7d04\u4e00\u89a7.Data&gt;().HasNoKey();\n            modelBuilder.Entity&lt;ViewModels.VM\u4e88\u7d04\u8a73\u7d30\u5165\u529b.\u5f15\u5408&gt;().HasNoKey();\n            modelBuilder.Entity&lt;ViewModels.VM\u5c5e\u6027\u5225\u96c6\u8a08.\u5c5e\u6027&gt;().HasNoKey();\n            modelBuilder.Entity&lt;ViewModels.VM\u5e74\u9593\u30b0\u30e9\u30d5.\u5e74\u9593\u58f2\u4e0a&gt;().HasNoKey();\n            modelBuilder.Entity&lt;ViewModels.VM\u6708\u5225\u58f2\u4e0a.\u6708\u5225\u58f2\u4e0a&gt;().HasNoKey();\n            modelBuilder.Entity&lt;ViewModels.VM\u8acb\u6c42\u96c6\u8a08.\u8acb\u6c42&gt;().HasNoKey();\n            modelBuilder.Entity&lt;ViewModels.VM\u904e\u53bb\u4e88\u7d04\u72b6\u6cc1.\u7d50\u679c&gt;().HasNoKey();\n            modelBuilder.Entity&lt;ViewModels.VM\u9867\u5ba2\u5225\u5229\u7528\u72b6\u6cc1\u96c6\u8a08.\u7d50\u679c&gt;().HasNoKey();\n            modelBuilder.Entity&lt;ViewModels.VM\u9867\u5ba2\u5229\u7528\u56de\u6570\u4e00\u89a7.\u5229\u7528\u56de\u6570&gt;().HasNoKey();\n            modelBuilder.Entity&lt;ViewModels.VM\u9867\u5ba2\u5229\u7528\u72b6\u6cc1.\u5229\u7528\u660e\u7d30&gt;().HasNoKey();<\/code><\/pre><\/div>\n\n\n\n<p>Entity \u30af\u30e9\u30b9\u306b NoKey \u5c5e\u6027\u306e\u3088\u3046\u306a\u3082\u306e\u304c\u3042\u308c\u3070\u3088\u3044\u306e\u3067\u3059\u304c\u3001\u3069\u3046\u3082\u7121\u3044\u307f\u305f\u3044\u3067\u3059\u306d\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u4e0a\u306e\u30ab\u30e9\u30e0\u540d\u3068\u4e00\u81f4\u3055\u305b\u308b<\/h3>\n\n\n\n<p>.NET6 \u306e EFCore \u3067\u306f\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u4e0a\u3082\u30ab\u30e9\u30e0\u540d\u3068 Entity \u30af\u30e9\u30b9\u306e\u30ab\u30e9\u30e0\u540d\u304c\u5b8c\u5168\u306b\u4e00\u5b9a\u3057\u3066\u3044\u306a\u3044\u3068\u3044\u3051\u307e\u305b\u3093\u3002\u3088\u3063\u3066\u3001\u6b21\u306e\u3088\u3046\u306a\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u4e0a\u3067\u306f\u3001\u6b63\u5f0f\u306a\u540d\u524d\u306e\u5834\u5408\u3001\u3061\u3087\u3063\u3068\u56f0\u308b\u3053\u3068\u304c\u304a\u3053\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u3053\u308c\u306f\u524d\u56de\u306e\u79fb\u690d\u4e0a\u3001\u4e88\u7d04\u30c6\u30fc\u30d6\u30eb\u306b\u300c\u4e88\u7d04\u300d\u3068\u3044\u3046\u540d\u524d\u306e\u30ab\u30e9\u30e0\u304c\u3064\u3044\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.moonmile.net\/blog\/wp-content\/uploads\/2022\/07\/image.png\"><img loading=\"lazy\" decoding=\"async\" width=\"654\" height=\"456\" src=\"https:\/\/www.moonmile.net\/blog\/wp-content\/uploads\/2022\/07\/image.png\" alt=\"\" class=\"wp-image-10693\" srcset=\"https:\/\/www.moonmile.net\/blog\/wp-content\/uploads\/2022\/07\/image.png 654w, https:\/\/www.moonmile.net\/blog\/wp-content\/uploads\/2022\/07\/image-300x209.png 300w\" sizes=\"auto, (max-width: 654px) 100vw, 654px\" \/><\/a><\/figure>\n\n\n\n<p>\u5b9f\u306f\u3001Entity Framework \u3067\u306f\u3001\u30c6\u30fc\u30d6\u30eb\u540d\u3068\u30ab\u30e9\u30e0\u540d\u304c\u540c\u3058\u306e\u306f\u4f7f\u3048\u307e\u305b\u3093\u3002\u4ee5\u524d\u304b\u3089\u554f\u984c\u3060\u3068\u601d\u3063\u3066\u3044\u308b\u306e\u3067\u3059\u304c\u3001\u30c6\u30fc\u30d6\u30eb\u540d\u3082\u30ab\u30e9\u30e0\u540d\u3082\u540c\u3058\u540d\u524d\u7a7a\u9593\u3067\u6df7\u5728\u3055\u305b\u3066\u3057\u307e\u3063\u3066\u3044\u308b\u304b\u3089\u306a\u306e\u3067\u3059\u3002<\/p>\n\n\n\n<p>\u306a\u306e\u3067\u3001.NET Framework \u306e EF \u3067\u306f\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u300c\u4e88\u7d041\u300d\u3068\u3044\u3046\u540d\u524d\u304c\u52dd\u624b\u306b\u632f\u3089\u308c\u307e\u3059\u3002<\/p>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-csharp\" data-lang=\"C#\"><code>    public partial class \u4e88\u7d04\n    {\n        public int ID { get; set; }\n        public int \u9867\u5ba2ID { get; set; }\n        public int \u9867\u5ba2SUBID { get; set; }\n        public Nullable&lt;int&gt; \u4e88\u7d04\u8005 { get; set; }\n        public string \u4e88\u7d04\u4f1a\u793e { get; set; }\n        public string \u4e88\u7d04\u62c5\u5f53 { get; set; }\n        public string \u4e88\u7d04TEL { get; set; }\n        public int \u62c5\u5f53\u8005ID { get; set; }\n        public Nullable&lt;System.DateTime&gt; \u65e5\u4ed8 { get; set; }\n        public Nullable&lt;System.DateTime&gt; \u8a18\u9332\u65e5 { get; set; }\n        public Nullable&lt;System.DateTime&gt; \u5951\u7d04\u65e5 { get; set; }\n        public Nullable&lt;System.DateTime&gt; M\u671f\u9650 { get; set; }\n        public Nullable&lt;System.DateTime&gt; K\u671f\u9650 { get; set; }\n        public Nullable&lt;int&gt; \u4e88\u7d041 { get; set; }\n        public Nullable&lt;int&gt; \u4f1a\u8b70\u5ba4 { get; set; }\n        public Nullable&lt;int&gt; TF { get; set; }\n        public Nullable&lt;int&gt; TE { get; set; }\n<\/code><\/pre><\/div>\n\n\n\n<p>\u3068\u3053\u308d\u304c\u3001.NET6 \u306e EFCore \u3067\u306f\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u30ab\u30e9\u30e0\u540d\u3068 Entity \u30af\u30e9\u30b9\u306e\u30d7\u30ed\u30d1\u30c6\u30a3\u540d\u306f\u540c\u4e00\u3067\u3042\u308b\u3068\u3044\u3046\u524d\u63d0\u304c\u3042\u308b\u306e\u3067\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306b Column \u5c5e\u6027\u3067\u5909\u66f4\u3057\u3066\u304a\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-csharp\" data-lang=\"C#\"><code>    public partial class \u4e88\u7d04\n    {\n        public int ID { get; set; }\n        public int \u9867\u5ba2ID { get; set; }\n        public int \u9867\u5ba2SUBID { get; set; }\n        public Nullable&lt;int&gt; \u4e88\u7d04\u8005 { get; set; }\n        public string \u4e88\u7d04\u4f1a\u793e { get; set; }\n        public string \u4e88\u7d04\u62c5\u5f53 { get; set; }\n        public string \u4e88\u7d04TEL { get; set; }\n        public int \u62c5\u5f53\u8005ID { get; set; }\n        public Nullable&lt;System.DateTime&gt; \u65e5\u4ed8 { get; set; }\n        public Nullable&lt;System.DateTime&gt; \u8a18\u9332\u65e5 { get; set; }\n        public Nullable&lt;System.DateTime&gt; \u5951\u7d04\u65e5 { get; set; }\n        public Nullable&lt;System.DateTime&gt; M\u671f\u9650 { get; set; }\n        public Nullable&lt;System.DateTime&gt; K\u671f\u9650 { get; set; }\n        [Column(&quot;\u4e88\u7d04&quot;)]\n        public Nullable&lt;int&gt; \u4e88\u7d041 { get; set; }\n        public Nullable&lt;int&gt; \u4f1a\u8b70\u5ba4 { get; set; }<\/code><\/pre><\/div>\n\n\n\n<p>\u3053\u306e\u90e8\u5206\u306f\u3001\u5b9f\u306f\u300c\u4e88\u7d04\u300d\u30d7\u30ed\u30d1\u30c6\u30a3\u306b\u5909\u66f4\u3057\u3066\u3082\u3088\u3044\u306e\u3067\u3059\u304c\u3001\u65e2\u306b\u5404\u7a2e\u306e\u30b3\u30fc\u30c9\u304b\u3089\u300c\u4e88\u7d041\u300d\u3067\u53c2\u7167\u3057\u3066\u3044\u308b\u306e\u3067\u3001\u53c2\u7167\u5148\u306e\u30b3\u30fc\u30c9\u306f\u5909\u66f4\u3057\u305f\u304f\u3042\u308a\u307e\u305b\u3093\u3002\u3088\u3063\u3066\u3001Column \u5c5e\u6027\u3067\u306e\u304c\u308c\u3066\u304a\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u62e1\u5f35\u3057\u305f\u30d7\u30ed\u30d1\u30c6\u30a3\u3092 DbSet \u306b\u7121\u8996\u3055\u305b\u308b<\/h3>\n\n\n\n<p>.NET Framework \u306e Entity \u30af\u30e9\u30b9\u3092 MVVM \u30d1\u30bf\u30fc\u30f3\u3067 View \u306b\u30d0\u30a4\u30f3\u30c9\u3055\u305b\u308b\u5834\u5408\u3001\u8868\u793a\u4e0a\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u3092\u5909\u66f4\u3055\u305b\u308b\u3053\u3068\u304c\u3088\u304f\u3042\u308a\u307e\u3059\u3002Converter \u3092\u4f5c\u308b\u306e\u3082\u3088\u3044\u306e\u3067\u3059\u304c\u3001\u3069\u3046\u305b partial \u306b\u306a\u3063\u3066\u3044\u308b\u306e\u3067\u3001\u9069\u5f53\u306a\u30d7\u30ed\u30d1\u30c6\u30a3\u3092\u4f5c\u3063\u3066\u62e1\u5f35\u3055\u305b\u3066\u304a\u304f\u3068\u4fbf\u5229\u3001\u3060\u3063\u305f\u306e\u3067\u3059\u3002<\/p>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-csharp\" data-lang=\"C#\"><code>    public partial class \u5358\u767a\u30a2\u30e9\u30fc\u30e0\n    {\n        public int ID { get; set; }\n        public Nullable&lt;System.DateTime&gt; \u65e5\u6642 { get; set; }\n        public string \u5bfe\u8c61\u7a2e\u5225 { get; set; }\n        public string \u5bfe\u8c61\u540d { get; set; }\n        public string \u8868\u793a\u5185\u5bb9 { get; set; }\n        public System.DateTime CreateAt { get; set; }\n        public System.DateTime UpdateAt { get; set; }\n    }\n<\/code><\/pre><\/div>\n\n\n\n<p>\u3053\u306e\u3088\u3046\u306a\u81ea\u52d5\u751f\u6210\u3055\u308c\u305f Entity \u30af\u30e9\u30b9\u3068\u306f\u5225\u306b\u3001patial \u3067\u62e1\u5f35\u3057\u3066\u304a\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-csharp\" data-lang=\"C#\"><code>    \/\/\/ &lt;summary&gt;\n    \/\/\/ \u65e5\u6642\u3092\u5e74\u6708\u65e5\u3068\u6642\u5206\u306b\u5206\u3051\u308b\u62e1\u5f35\n    \/\/\/ &lt;\/summary&gt;\n    public partial class \u5358\u767a\u30a2\u30e9\u30fc\u30e0\n    {\n        public Nullable&lt;System.DateTime&gt; \u65e5\u6642_\u5e74\u6708\u65e5\n        {\n            get { return this.\u65e5\u6642; }\n            set\n            {\n                if ( this.\u65e5\u6642.HasValue )\n                {\n                    DateTime dt = new DateTime(\n                        value.Value.Year,\n                        value.Value.Month,\n                        value.Value.Day,\n                        \u65e5\u6642.Value.Hour,\n                        \u65e5\u6642.Value.Minute,\n                        0);\n                    this.\u65e5\u6642 = dt;\n                }\n            }\n        }\n        public Nullable&lt;System.DateTime&gt; \u65e5\u6642_\u6642\u5206\n        {\n            get { return this.\u65e5\u6642; }\n            set\n            {\n                if (this.\u65e5\u6642.HasValue)\n                {\n                    DateTime dt = new DateTime(\n                        \u65e5\u6642.Value.Year,\n                        \u65e5\u6642.Value.Month,\n                        \u65e5\u6642.Value.Day,\n                        value.Value.Hour,\n                        value.Value.Minute,\n                        0);\n                    this.\u65e5\u6642 = dt;\n                }\n            }\n        }\n    }\n<\/code><\/pre><\/div>\n\n\n\n<p>\u3053\u3053\u3067 .NET6 \u3078\u306e\u79fb\u690d\u6642\u306b\u554f\u984c\u304c\u767a\u751f\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>.NET Framework \u306e EF \u3067\u306f\u3001\u30c6\u30fc\u30d6\u30eb\u69cb\u9020\u304c *.edmx \u30d5\u30a1\u30a4\u30eb\u306b\u5206\u96e2\u3055\u308c\u3066\u3044\u308b\u306e\u3067\u3001\u62e1\u5f35\u3057\u305f\u65e5\u6642_\u5e74\u6708\u65e5\u30d7\u30ed\u30d1\u30c6\u30a3\u3084\u65e5\u6642_\u6642\u5206\u30d7\u30ed\u30d1\u30c6\u30a3\u306f\u66f4\u65b0\u6642\u306b\u7121\u8996\u3055\u308c\u308b\u306e\u3067\u3059\u304c\u3001.NET6 \u306e EFCore\u3067\u306f\u66f4\u65b0\u5bfe\u8c61\u304cEntity\u30af\u30e9\u30b9\u306e\u5168\u30d7\u30ed\u30d1\u30c6\u30a3\u3068\u306a\u308b\u305f\u3081\u3001\u3053\u306e\u62e1\u5f35\u3057\u305f\u30d7\u30ed\u30d1\u30c6\u30a3\u3092\u300c\u7121\u8996\u300d\u3055\u305b\u308b\u3088\u3046\u306b\u3057\u306a\u3051\u308c\u3070\u306a\u308a\u307e\u305b\u3093\u3002<\/p>\n\n\n\n<p>DbContext \u306e OnModelCreating \u5185\u3067\u3001<\/p>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-csharp\" data-lang=\"C#\"><code>            modelBuilder.Entity&lt;\u5358\u767a\u30a2\u30e9\u30fc\u30e0&gt;()\n                .Ignore(&quot;\u65e5\u6642_\u5e74\u6708\u65e5&quot;)\n                .Ignore(&quot;\u65e5\u6642_\u6642\u5206&quot;);\n            modelBuilder.Entity&lt;\u5468\u671f\u30a2\u30e9\u30fc\u30e0&gt;()\n                .Ignore(&quot;\u5468\u671f\u6708\u4e00\u9031&quot;)\n                .Ignore(&quot;\u5468\u671f\u6bce\u5e74&quot;)\n                .Ignore(&quot;\u5468\u671f\u6bce\u6708&quot;)\n                .Ignore(&quot;\u5468\u671f\u6bce\u9031&quot;)\n                .Ignore(&quot;\u5468\u671f\u6708\u4e00\u66dc\u65e5&quot;)\n                ;\n<\/code><\/pre><\/div>\n\n\n\n<p>\u306e\u3088\u3046\u306b\u3001\u62e1\u5f35\u3057\u305f\u30d7\u30ed\u30d1\u30c6\u30a3\u3092 ignore \u3059\u308b\u3088\u3046\u306b\u3057\u3066\u3044\u304d\u307e\u3059\u3002\u3053\u306e\u90e8\u5206\u306f\u3001\u62e1\u5f35\u3057\u305f\u30d7\u30ed\u30d1\u30c6\u30a3\u306e\u307b\u3046\u306b Ignore\u5c5e\u6027\u304c\u4ed8\u3051\u3089\u308c\u308c\u3070\u3088\u3044\u306e\u3067\u3059\u304c\u3001\u7121\u3044\u3088\u3046\u3067\u3059\u3002\u4e0d\u4fbf\u3067\u3059\u306d\u3002<\/p>\n\n\n\n<p>\u554f\u984c\u306f\u3053\u306e\u30a8\u30e9\u30fc\u306e\u767a\u751f\u306f\u3001\u30b3\u30f3\u30d1\u30a4\u30eb\u6642\u3067\u306f\u306a\u304f\u5b9f\u884c\u6642\u306b\u3057\u304b\u767a\u751f\u3057\u306a\u3044\u306e\u3067\u3001\u3044\u3061\u3044\u3061\u78ba\u304b\u3081\u306a\u3044\u3068\u3044\u3051\u307e\u305b\u3093\u3002\u5143\u306e Entity \u30af\u30e9\u30b9\u3092\u62e1\u5f35\u3057\u3066\u3044\u308b\u3068\u7d50\u69cb\u3084\u3063\u304b\u3044\u306a\u554f\u984c\u3067\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">WindowsFormsHost \u3092\u4f7f\u3046<\/h2>\n\n\n\n<p>.NET Framework \u306e WPF \u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3067\u306f WindowsFormsHost \u3092\u4f7f\u3063\u3066\u3001Windows \u30d5\u30a9\u30fc\u30e0\u306e\u5404\u7a2e\u30b3\u30f3\u30c8\u30ed\u30fc\u30eb\u3092\u57cb\u3081\u8fbc\u3080\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u3053\u308c\u306f\u5ba2\u5148\u306e\u300c\u30ab\u30ec\u30f3\u30c0\u30fc\u306e\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\/\u8272\u5408\u3044\u3092\u5f93\u6765\u306e\u3082\u306e\u3068\u540c\u3058\u306b\u3057\u3066\u307b\u3057\u3044\u300d\u3068\u3044\u3046\u8981\u671b\u3092\u5b9f\u73fe\u3057\u305f\u3082\u306e\u3067\u3059\u3002\u5f93\u6765\u306f ACCESS \u306e\u30ab\u30ec\u30f3\u30c0\u30fc\u3092\u4f7f\u3063\u3066\u3044\u308b\u306e\u3067\u3001WPF \u30ab\u30ec\u30f3\u30c0\u30fc\u306e\u3082\u306e\u306f\u4f7f\u3048\u307e\u305b\u3093\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.moonmile.net\/blog\/wp-content\/uploads\/2022\/07\/image-1.png\"><img loading=\"lazy\" decoding=\"async\" width=\"909\" height=\"579\" src=\"https:\/\/www.moonmile.net\/blog\/wp-content\/uploads\/2022\/07\/image-1.png\" alt=\"\" class=\"wp-image-10694\" srcset=\"https:\/\/www.moonmile.net\/blog\/wp-content\/uploads\/2022\/07\/image-1.png 909w, https:\/\/www.moonmile.net\/blog\/wp-content\/uploads\/2022\/07\/image-1-300x191.png 300w, https:\/\/www.moonmile.net\/blog\/wp-content\/uploads\/2022\/07\/image-1-768x489.png 768w\" sizes=\"auto, (max-width: 909px) 100vw, 909px\" \/><\/a><\/figure>\n\n\n\n<p>\u3057\u304b\u305f\u304c\u306a\u3044\u306e\u3067\u3001\u30e6\u30fc\u30b6\u30fc\u30b3\u30f3\u30c8\u30ed\u30fc\u30eb\u3092\u4f5c\u3063\u3066 WindowsFormsHost \u3067\u57cb\u3081\u8fbc\u307f\u307e\u3059\u3002\u30e6\u30fc\u30b6\u30fc\u30b3\u30f3\u30c8\u30ed\u30fc\u30eb\u306b\u3057\u305f\u306e\u306f\u3001\u3042\u3061\u3053\u3061\u306e\u753b\u9762\u3067\u3053\u306e\u30ab\u30ec\u30f3\u30c0\u30fc\u304c\u51fa\u3066\u304f\u308b\u306e\u3067\u5171\u901a\u5316\u3059\u308b\u305f\u3081\u3067\u3059\u3002<\/p>\n\n\n\n<p><\/p>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-html\" data-lang=\"HTML\"><code>&lt;Canvas Grid.Row=&quot;1&quot; Grid.Column=&quot;0&quot; x:Name=&quot;cv&quot;&gt;\n    &lt;WindowsFormsHost FontSize=&quot;20&quot; x:Name=&quot;host&quot; &gt;\n        &lt;wf:MonthCalendar \n            x:Name=&quot;cal&quot; CalendarDimensions=&quot;3,1&quot; DateSelected=&quot;MonthCalendar_DateSelected&quot; \/&gt;\n    &lt;\/WindowsFormsHost&gt;\n&lt;\/Canvas&gt;\n<\/code><\/pre><\/div>\n\n\n\n<p>\u5b9f\u306f\u3001.NET6 \u3067\u306f WindowsFormsHost \u306e\u90e8\u5206\u304c\u4f7f\u3048\u306a\u304f\u3066\u66ab\u304f\u60a9\u3093\u3067\u3044\u305f\u306e\u3067\u3059\u304c\u3001<\/p>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-html\" data-lang=\"HTML\"><code>&lt;UseWindowsForms&gt;true&lt;\/UseWindowsForms&gt;<\/code><\/pre><\/div>\n\n\n\n<p>\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u30d5\u30a1\u30a4\u30eb\u306b UseWindowsForms \u3092\u8a2d\u5b9a\u3057\u3066\u89e3\u6c7a\u3057\u307e\u3059\u3002\u304a\u305d\u3089\u304f\u3001.NET6 \u306e WPF \u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3067\u30c4\u30fc\u30eb\u30dc\u30c3\u30af\u30b9\u304b\u3089  WindowsFormsHost \u3092\u30c9\u30ed\u30c3\u30d7\u3059\u308b\u3068\u81ea\u52d5\u7684\u306b\u3001UseWindowsForms \u304c true \u306b\u306a\u308b\u306f\u305a\u3067\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">office.dll \u3078\u306e\u53c2\u7167\u3092\u8ffd\u52a0\u3059\u308b<\/h2>\n\n\n\n<p>\u304b\u306a\u308a\u60a9\u3093\u3060\u306e\u304c\u6b21\u306e\u3068\u3053\u308d\u3067\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.moonmile.net\/blog\/wp-content\/uploads\/2022\/07\/image-2.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"227\" src=\"https:\/\/www.moonmile.net\/blog\/wp-content\/uploads\/2022\/07\/image-2-1024x227.png\" alt=\"\" class=\"wp-image-10695\" srcset=\"https:\/\/www.moonmile.net\/blog\/wp-content\/uploads\/2022\/07\/image-2-1024x227.png 1024w, https:\/\/www.moonmile.net\/blog\/wp-content\/uploads\/2022\/07\/image-2-300x66.png 300w, https:\/\/www.moonmile.net\/blog\/wp-content\/uploads\/2022\/07\/image-2-768x170.png 768w, https:\/\/www.moonmile.net\/blog\/wp-content\/uploads\/2022\/07\/image-2-1536x340.png 1536w, https:\/\/www.moonmile.net\/blog\/wp-content\/uploads\/2022\/07\/image-2.png 1679w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p>MsoTriState \u304c\u5b58\u5728\u3057\u306a\u3044\u3068\u3044\u3046\u30a8\u30e9\u30fc\u304c\u3067\u3066\u3044\u307e\u3059\u3002\u3053\u308c\u306f Excel \u306e Shape \u3092\u8a2d\u5b9a\u3057\u3066\u3044\u308b\u90e8\u5206\u306a\u306e\u3067\u3059\u304c\u3001Excel COM \u3092\u53c2\u7167\u3055\u305b\u3066\u306f\u3044\u3066\u3082\u3001\u3053\u306e\u30a8\u30e9\u30fc\u306f\u53d6\u308a\u9664\u3051\u307e\u305b\u3093\u3002\u304a\u305d\u3089\u304f Excel\/Word \u306b\u5171\u901a\u5316\u3055\u308c\u3066\u3044\u308b Shape \u30af\u30e9\u30b9\u306f\u300coffice, Version=15.0.0.0\u300d\u306b\u3042\u308b\u3088\u3046\u3067\u3059\u3002<\/p>\n\n\n\n<p>\u3055\u3066\u3001 \u300coffice, Version=15.0.0.0\u300d \u306f\u4e00\u4f53\u3069\u3053\u306b\u3042\u308b\u306e\u3067\u3057\u3087\u3046\u304b\uff1f<\/p>\n\n\n\n<p>\u5b9f\u306f\u3001.NET Framework \u306e\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3092\u898b\u308b\u3068\u300c\u30a2\u30bb\u30f3\u30d6\u30ea\u300d\u306e\u30bf\u30d6\u306e\u307b\u3046\u306b\u300coffice 15.0.0.0\u300d\u3092\u53c2\u7167\u3057\u3066\u3044\u308b\u3068\u3053\u308d\u304c\u3042\u308a\u307e\u3059\u3002\u3053\u308c\u306f Office \u306e COM \u3067\u306f\u306a\u304f\u3066\u3001.NET Framework \u304c\u63d0\u4f9b\u3057\u3066\u3044\u308b\u30a2\u30bb\u30f3\u30d6\u30ea\u306e\u307b\u3046\u306a\u3093\u3067\u3059\u306d\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.moonmile.net\/blog\/wp-content\/uploads\/2022\/07\/image-4.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"686\" src=\"https:\/\/www.moonmile.net\/blog\/wp-content\/uploads\/2022\/07\/image-4-1024x686.png\" alt=\"\" class=\"wp-image-10697\" srcset=\"https:\/\/www.moonmile.net\/blog\/wp-content\/uploads\/2022\/07\/image-4-1024x686.png 1024w, https:\/\/www.moonmile.net\/blog\/wp-content\/uploads\/2022\/07\/image-4-300x201.png 300w, https:\/\/www.moonmile.net\/blog\/wp-content\/uploads\/2022\/07\/image-4-768x515.png 768w, https:\/\/www.moonmile.net\/blog\/wp-content\/uploads\/2022\/07\/image-4.png 1370w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p>.NET6 \u3067\u306f\u5404\u7a2e\u306e\u30a2\u30bb\u30f3\u30d6\u30ea\u3092\u500b\u5225\u3067\u53c2\u7167\u3059\u308b\u3053\u3068\u306f\u3067\u304d\u306a\u3044\uff08\u81ea\u52d5\u7684\u306b\u30a2\u30bb\u30f3\u30d6\u30ea\u53c2\u7167\u304c\u89e3\u6c7a\u3055\u308c\u308b\u305f\u3081\uff09\u306e\u3067\u3001\u660e\u793a\u7684\u306b office.dll \u3092\u53c2\u7167\u3055\u305b\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.moonmile.net\/blog\/wp-content\/uploads\/2022\/07\/image-5.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"707\" src=\"https:\/\/www.moonmile.net\/blog\/wp-content\/uploads\/2022\/07\/image-5-1024x707.png\" alt=\"\" class=\"wp-image-10698\" srcset=\"https:\/\/www.moonmile.net\/blog\/wp-content\/uploads\/2022\/07\/image-5-1024x707.png 1024w, https:\/\/www.moonmile.net\/blog\/wp-content\/uploads\/2022\/07\/image-5-300x207.png 300w, https:\/\/www.moonmile.net\/blog\/wp-content\/uploads\/2022\/07\/image-5-768x530.png 768w, https:\/\/www.moonmile.net\/blog\/wp-content\/uploads\/2022\/07\/image-5.png 1182w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p>\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u30d5\u30a1\u30a4\u30eb\u306b\u4ee5\u4e0b\u3092\u8a18\u8ff0\u3057\u3066\u3082 ok \u3067\u3059\u3002<\/p>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-html\" data-lang=\"HTML\"><code>  &lt;ItemGroup&gt;\n    &lt;Reference Include=&quot;office&quot;&gt;\n      &lt;HintPath&gt;c:\\Program Files (x86)\\Microsoft Visual Studio\\Shared\\Visual Studio Tools for Office\\PIA\\Office15\\Office.dll&lt;\/HintPath&gt;\n    &lt;\/Reference&gt;\n  &lt;\/ItemGroup&gt;<\/code><\/pre><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">\u305d\u306e\u4ed6<\/h2>\n\n\n\n<p>\u305d\u306e\u4ed6 Excel COM \u306e\u53c2\u7167\u3084 Newtonsoft.Json\u3001ClosedXML \u306e\u53c2\u7167\u306f\u554f\u984c\u306a\u304f\u52d5\u3044\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<p>EFCore \u306e\u62e1\u5f35\u30d7\u30ed\u30d1\u30c6\u30a3\u306e\u554f\u984c\u306f\u3001\u5b9f\u969b\u306b\u52d5\u304b\u3057\u3066\u307f\u306a\u3044\u3068\u30a8\u30e9\u30fc\u304c\u767a\u751f\u3057\u306a\u3044\u306e\u3067\u3082\u3046\u5c11\u3057\u5bfe\u51e6\u304c\u5fc5\u8981\u3067\u3059\u3002<\/p>\n\n\n\n<p>\u4f5c\u696d\u6642\u9593\u306f\u304a\u304a\u3080\u306d1\u65e5\u304c\u304b\u308a\u306a\u306e\u3067\u3001\u79fb\u884c\u3068\u3057\u3066\u306f\u5341\u5206\u53ef\u80fd\u306a\u30ec\u30d9\u30eb\u3067\u3059\u304c\u3001\u554f\u984c\u306f FromSqlRaw \u3078\u306e\u66f8\u304d\u63db\u3048\u3067\u3059\u304b\u306d\u3002\u5916\u90e8\u7d50\u5408\u3092\u4f7f\u3046\u5834\u5408\u3001LINQ \u3067\u306f\u304b\u306a\u308a\u624b\u9593\u306a\u306e\u3067\u751f SQL \u3067\u7d44\u3093\u3067\u3057\u307e\u3046\u306e\u3067\u3059\u304c\u3001\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u306b\u3088\u3063\u3066\u6570\u304c\u591a\u3044\u3068\u5927\u5909\u304b\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<p>.NET6 \u306b\u3057\u3066\u304a\u304f\u3068\u4f55\u304c\u4fbf\u5229\u304b\u3068\u8a00\u3046\u3068 TargetFramework \u3092\u300cnet6.0-windows10.0.17763.0\u300d\u306b\u3057\u3066\u304a\u3044\u3066 Windows Runtime\uff08UWP \u3084 Windows App SDK\u306e\u6a5f\u80fd\uff09\u304c\u624b\u8efd\u306b\u4f7f\u3048\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002\u307e\u3042\u3001\u696d\u52d9\u7528\u306e\u30c7\u30b9\u30af\u30c8\u30c3\u30d7\u30a2\u30d7\u30ea\u306a\u306e\u3067\u3001\u516c\u958b\u3068\u304b\u3057\u306a\u3044\u308f\u3051\u3067\u305d\u308c\u307b\u3069\u5229\u7528\u4fa1\u5024\u304c\u3042\u308b\u308f\u3051\u3067\u306f\u306a\u3044\u306e\u3067\u3059\u304c\u3002\u3075\u308a\u304c\u306a\u6a5f\u80fd\u3068\u304b\u901a\u77e5\u6a5f\u80fd\u3001\u9023\u7d61\u5e33\u306a\u3069\u304c WinRT \u306e\u307b\u3046\u306b\u5165\u3063\u3066\u3044\u305f\u308a\u3057\u307e\u3059\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Windows \u4e0a\u306e .NET Framework \u304b\u3089 .NET 6 \u3078\u79fb\u884c\u3059\u308b\u3068\u304d\u306b\u3001\u969c\u5bb3\u3068\u306a\u308a\u305d\u3046\u306a\u30dd\u30a4\u30f3\u30c8\u3092\u6319\u3052\u3066\u304a\u304d\u307e\u3059\u3002\u3061\u3087\u3063\u3068\u3057\u305f Windows \u30d5\u30a9\u30fc\u30e0\u3084 WPF \u30a2\u30d7\u30ea\u306a\u3089\u3070\u3059\u3093\u306a\u308a\u4ee5\u964d\u3067\u304d\u308b\u306e\u3067\u3059\u304c &hellip; <a href=\"https:\/\/www.moonmile.net\/blog\/archives\/10689\">\u7d9a\u304d\u3092\u8aad\u3080 <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[3],"tags":[],"class_list":["post-10689","post","type-post","status-publish","format-standard","hentry","category-dev"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.moonmile.net\/blog\/wp-json\/wp\/v2\/posts\/10689","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.moonmile.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.moonmile.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.moonmile.net\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.moonmile.net\/blog\/wp-json\/wp\/v2\/comments?post=10689"}],"version-history":[{"count":6,"href":"https:\/\/www.moonmile.net\/blog\/wp-json\/wp\/v2\/posts\/10689\/revisions"}],"predecessor-version":[{"id":10701,"href":"https:\/\/www.moonmile.net\/blog\/wp-json\/wp\/v2\/posts\/10689\/revisions\/10701"}],"wp:attachment":[{"href":"https:\/\/www.moonmile.net\/blog\/wp-json\/wp\/v2\/media?parent=10689"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.moonmile.net\/blog\/wp-json\/wp\/v2\/categories?post=10689"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.moonmile.net\/blog\/wp-json\/wp\/v2\/tags?post=10689"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}