using System;

using System.Linq;

using Microsoft.EntityFrameworkCore;

public class Program

{

    public static void Main()

    {

        using var context = new Context();

        var query = context.Items.Where(i => !i.Time.IsBetween(i.StartTime, i.EndTime));

        Console.WriteLine(query.ToQueryString());

    }

}

​

public class Item

{

    public int Id { get; set; }

    public TimeOnly Time { get; set; }

    public TimeOnly StartTime { get; set; }

    public TimeOnly EndTime { get; set; }

}

​

public class Context : DbContext

{

    public DbSet<Item> Items { get; set; }

​

    protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)

    {

        optionsBuilder.UseMySql("server=localhost", MySqlServerVersion.LatestSupportedServerVersion);

    }

}

​