EF Core DBContext inside Net Core Worker Windows service

Question

我试图实现的是编写一个简单的.NET Core 后台工作线程(.net Core 3.1(，其中我将数据写入SQL Server数据库(通过EF Core 3.1(，而该工作线程作为Windows服务运行。

当我从Visual Studio 2019运行以下代码时，一切正常，但是当我发布(目标win-x64(并将.exe注册为win10计算机上的服务时，我收到以下异常：

Microsoft.Data.SqlClient is not supported on this platform.

关于导致此问题的原因以及如何解决它的任何想法？

程序.cs

using Microsoft.EntityFrameworkCore;
using Microsoft.Extensions.DependencyInjection;
using Microsoft.Extensions.Hosting;
using Soteria.Common.Database;
namespace Soteria.Service
{
public class Program
{
public static void Main(string[] args)
{
CreateHostBuilder(args).Build().Run();
}
public static IHostBuilder CreateHostBuilder(string[] args)
{
var host = Host.CreateDefaultBuilder(args)
.UseWindowsService()
.ConfigureServices((hostContext, services) =>
{
var optionsBuilder = new DbContextOptionsBuilder<SoteriaDbContext>();
optionsBuilder.UseSqlServer("Server=.\SQLEXPRESS;Database=Soteria;Trusted_Connection=True;");//,
services.AddScoped<SoteriaDbContext>(s => new SoteriaDbContext(optionsBuilder.Options));
services.AddHostedService<Worker>();
});
return host;
}
}
}

工人.cs

using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Text;
using System.Threading;
using System.Threading.Tasks;
using Microsoft.EntityFrameworkCore;
using Microsoft.Extensions.DependencyInjection;
using Microsoft.Extensions.Hosting;
using Microsoft.Extensions.Logging;
using Soteria.Common.Database;
using Soteria.Common.Messaging;
using Soteria.Common.Models;
namespace Soteria.Service
{
public class Worker : BackgroundService
{
private readonly ILogger<Worker> _logger;
private readonly IServiceScopeFactory _serviceScopeFactory;
public Worker(ILogger<Worker> logger, IServiceScopeFactory serviceScopeFactory)
{
_logger = logger;
_serviceScopeFactory = serviceScopeFactory;
}
protected override async Task ExecuteAsync(CancellationToken stoppingToken)
{
while (!stoppingToken.IsCancellationRequested)
{
using var scope = _serviceScopeFactory.CreateScope();
var dbContext = scope.ServiceProvider.GetRequiredService<SoteriaDbContext>();
dbContext.Tests.Add(new Test() {Date = DateTime.Now});
dbContext.SaveChanges();
await Task.Delay(1000, stoppingToken);               
}
}  
}
}

SoteriaDbContext.cs

using Microsoft.EntityFrameworkCore;
using Soteria.Common.Models;
namespace Soteria.Common.Database
{
public class SoteriaDbContext: DbContext
{
public SoteriaDbContext(DbContextOptions<SoteriaDbContext> options)
: base(options)
{
}
public DbSet<Test> Tests { get; set; }
protected override void OnModelCreating(ModelBuilder modelBuilder)
{            
modelBuilder.Entity<Test>().ToTable("Tests");
}
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
{
optionsBuilder.EnableSensitiveDataLogging(true);
}
}
}

测试.cs

using System;
namespace Soteria.Common.Models
{
public class Test
{
public int? Id { get; set; }
public DateTime Date { get; set; }
}
}

测试.sql

CREATE TABLE [dbo].[Tests]
(
[Id] INT NOT NULL PRIMARY KEY IDENTITY, 
[Date] DATETIME NOT NULL
)

Answer 1

我必须安装 win-x64 文件夹的已发布源代码，而不是"发布"文件夹才能使其实际工作。即使我的目标运行时是 win-x64，这导致我希望发布的结果将在"发布"文件夹中。

发布文件夹结构和混乱的发布文件夹