How To Create Window Service In .Net Core

IUserRepository.cs Interface

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace User_Status_Update.Repository
{
    public interface IUserRepository
    {
        void UserStatusUpdate();
    }
}

UserRepository.cs Class

using DataLayer.Data;
using Microsoft.EntityFrameworkCore;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace User_Status_Update.Repository
{
    public class UserRepository : IUserRepository
    {
        private readonly EcommerceContext _context;

        public UserRepository(EcommerceContext _context)
        {
            this._context = _context;
        }

        public void UserStatusUpdate()
        {
            this._context.Database.ExecuteSqlRaw("EXEC UserStatusUpdate");
        }
    }
}

Program.cs class

using DataLayer.Data;
using Microsoft.EntityFrameworkCore;
using User_Status_Update;
using User_Status_Update.Repository;

var configuration = new ConfigurationBuilder()
    .AddJsonFile("appsettings.json").Build();

IHost host = Host.CreateDefaultBuilder(args)
    .UseWindowsService()
    .ConfigureServices(services =>
    {
        services.AddDbContext<EcommerceContext>(opt=>
        {
            opt.UseSqlServer(configuration.GetConnectionString("Db"));
        });
        services.AddScoped<IUserRepository, UserRepository>();
        services.AddHostedService<UserService>();
    })
    .Build();

await host.RunAsync();

UserService.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using User_Status_Update.Repository;

namespace User_Status_Update
{
    public class UserService : BackgroundService
    {
        private readonly IUserRepository userRepository;

        public UserService(IUserRepository userRepository)
        {
            this.userRepository = userRepository;
        }

        protected override async Task ExecuteAsync(CancellationToken stoppingToken)
        {
            while (!stoppingToken.IsCancellationRequested)
            {

                await Task.Run(() =>
                {
                    Thread.Sleep(1000 * 60);
                    this.userRepository.UserStatusUpdate();
                });
            }            
        }
        public override Task StartAsync(CancellationToken cancellationToken)
        {
            return base.StartAsync(cancellationToken);
        }
        public override Task StopAsync(CancellationToken cancellationToken)
        {
            return base.StopAsync(cancellationToken);
        }
    }
}

Step 11. Let's Right click on Project and select publish and from the publish target list choose the target method as file system and click on Save.

Next, we will Publish the project as User Status Update.exe file path.

Step 12. Open the command prompt as an administrator, write the command look below.

Step 13. Here you go, TestUserService Installed successfully.

Step 14. Select TestUserService and click start to start service; go to TestUserService.exe after every minute to update the User Status.

To Change Status with 2.