Devart Forums

Code: Select all

public class RootItem
{
    [Key]
    [DatabaseGenerated(DatabaseGeneratedOption.Identity)]
    public int Id { get; set; }

    public DateTimeOffset Time { get; set; }
}

Code: Select all

public class MyDbContext : DbContext
{

    protected override void OnModelCreating(DbModelBuilder modelBuilder)
    {
        modelBuilder.Conventions.Remove();

        modelBuilder.Conventions.Remove();
    }

    public DbSet RootItems { get; set; }
}

Code: Select all

class Program
{

    static void Main(string[] args)
    {

        var monitor = new OracleMonitor() { IsActive = true };

        var config = OracleEntityProviderConfig.Instance;

        config.Workarounds.IgnoreSchemaName = true;

        config.DatabaseScript.Schema.DeleteDatabaseBehaviour = DeleteDatabaseBehaviour.ModelObjectsOnly;

        System.Data.Entity.Database.SetInitializer(new DropCreateDatabaseAlways());

        var now = DateTimeOffset.Now;

        using (MyDbContext context = new MyDbContext())
        {
            var query = (from p in context.RootItems
                            where p.Time < now
                            select p).ToList();
        }
    }

}