C#C
C#•4y ago
.eax

Have to call .ToList() on DbSets for .First() or .Single() to work. Sqlite

I have a simple dependency on a database, the schema contains 2 entities and I'm having some simple problems with making it work. I have to call ToList on the DbSets of the entities to make Single/First match elements. Anyone got any idea on whats wrong?
I add the context in Program.cs like this:
builder.Services.AddDbContext<SibusyContext>();


Context looks like this:
public class SibusyContext : DbContext
{
    private string DbPath { get; }

    public DbSet<Pipeline> Pipelines { get; set; }
    public DbSet<Job> Jobs { get; set; }

    public SibusyContext()
    {
        var folder = Environment.SpecialFolder.LocalApplicationData;
        var path = Environment.GetFolderPath(folder);
        Console.WriteLine(path);
        DbPath = Path.Join(path, "sibusy.db");
    }

    protected override void OnConfiguring(DbContextOptionsBuilder options)
    {
        options.UseSqlite($"Data Source={DbPath}");
    }
}

And I use it in a service like this:
public interface IJobService
{
    Task<string> ParseJob(CollectInput input, Guid pipelineId, CancellationToken ct);
}

public sealed class JobService : IJobService
{
    private readonly SibusyContext _sibusyContext;
    private readonly IMapper _mapper;

    public JobService(SibusyContext sibusyContext, IMapper mapper)
    {
        _sibusyContext = sibusyContext;
        _mapper = mapper;
    }
    
    
    public async Task<string> ParseJob(JobInput input, Guid pipelineId, CancellationToken cancellationToken)
    {
        var first = _sibusyContext.Pipelines.First();
        var isTrue = first.Id == pipelineId; // this is true
        var pipeline = _sibusyContext.Pipelines.FirstOrDefault(x => x.Id == pipelineId); // this is null
        var works = _sibusyContext.Pipelines.ToList().FirstOrDefault(x => x.Id == pipelineId); // this works
        if (pipeline is null)
            return "TODO";

        var job = _mapper.Map<Job>(input);

        job.PipelineId = pipelineId;
        await _sibusyContext.AddAsync(job, cancellationToken);
        await _sibusyContext.SaveChangesAsync(cancellationToken);

        return "TODO";
    }
}
Was this page helpful?