A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Your target project 'SadBot.Core' doesn't match your migrations assembly 'SadBot.Migrations'. Either change your target project or change your migrations assembly.
Change your migrations assembly by using DbContextOptionsBuilder. E.g. options.UseSqlServer(connection, b => b.MigrationsAssembly("SadBot.Core")). By default, the migrations assembly is the assembly containing the DbContext.
Change your target project to the migrations project by using the Package Manager Console's Default project drop-down list, or by executing "dotnet ef" from the directory containing the migrations project

Your target project 'SadBot.Core' doesn't match your migrations assembly 'SadBot.Migrations'. Either change your target project or change your migrations assembly.
Change your migrations assembly by using DbContextOptionsBuilder. E.g. options.UseSqlServer(connection, b => b.MigrationsAssembly("SadBot.Core")). By default, the migrations assembly is the assembly containing the DbContext.
Change your target project to the migrations project by using the Package Manager Console's Default project drop-down list, or by executing "dotnet ef" from the directory containing the migrations project

namespace SadMemerBot
{
    public class Program
    {
        private DiscordSocketClient _client;

        private Program()
        {
            _client = new DiscordSocketClient(); // commented out for abbrevity
        }

        public static Task Main(string[] args) => new Program().MainAsync(args);

        public async Task MainAsync(string[] args)
        {
            var host = Host.CreateApplicationBuilder(args);
          

            //Add any other services here
              // services .....
            var sqlDbConn = host.Configuration.GetConnectionString("SqlConnection");
            host.Services.AddDbContext<RPGContext>(options =>
            {
                options.UseSqlServer(sqlDbConn, x => x.MigrationsAssembly("SadBot.Migrations"));
            });

            var runner = host.Build();
            await runner.RunAsync();
        }

namespace SadMemerBot
{
    public class Program
    {
        private DiscordSocketClient _client;

        private Program()
        {
            _client = new DiscordSocketClient(); // commented out for abbrevity
        }

        public static Task Main(string[] args) => new Program().MainAsync(args);

        public async Task MainAsync(string[] args)
        {
            var host = Host.CreateApplicationBuilder(args);
          

            //Add any other services here
              // services .....
            var sqlDbConn = host.Configuration.GetConnectionString("SqlConnection");
            host.Services.AddDbContext<RPGContext>(options =>
            {
                options.UseSqlServer(sqlDbConn, x => x.MigrationsAssembly("SadBot.Migrations"));
            });

            var runner = host.Build();
            await runner.RunAsync();
        }

using Microsoft.EntityFrameworkCore;
using SadBot.Core.Database.Models.Items;

namespace SadBot.Core.Database
{
    public class RPGContext : DbContext
    {
        public RPGContext(DbContextOptions<RPGContext> options) : base(options) { }
        public DbSet<Item> Items { get; set; }
    }
}

using Microsoft.EntityFrameworkCore;
using SadBot.Core.Database.Models.Items;

namespace SadBot.Core.Database
{
    public class RPGContext : DbContext
    {
        public RPGContext(DbContextOptions<RPGContext> options) : base(options) { }
        public DbSet<Item> Items { get; set; }
    }
}

var host = Host.CreateDefaultBuilder()
.ConfigureDiscordHost((context, config) =>

var host = Host.CreateDefaultBuilder()
.ConfigureDiscordHost((context, config) =>