HRCenter/Diligent.WebAPI.Tests/Helpers.cs

using Diligent.WebAPI.Data;
using Diligent.WebAPI.Data.Entities;
using Microsoft.EntityFrameworkCore;

namespace Diligent.WebAPI.Tests
{
    public static class Helpers
    {
        public static async Task<DatabaseContext> GetDatabaseContext(List<Applicant> applicants)
        {
            var options = new DbContextOptionsBuilder<DatabaseContext>()
                .UseInMemoryDatabase(databaseName: Guid.NewGuid().ToString())
                .Options;
            var databaseContext = new DatabaseContext(options);
            databaseContext.Database.EnsureCreated();
            if (!await databaseContext.Applicants.AnyAsync())
            {
                await databaseContext.Applicants.AddRangeAsync(applicants);
                await databaseContext.SaveChangesAsync();
            }
            return databaseContext;
        }
    }
}