Devart Forums

Code: Select all

CREATE TABLE T1(
  ID NUMBER PRIMARY KEY,
  NAME VARCHAR2(100)
);

CREATE MATERIALIZED VIEW T1_MV AS SELECT * FROM T1;

CREATE TABLE T2(
  ID NUMBER PRIMARY KEY,
  NAME VARCHAR2(100),
  ID_T2 NUMBER,
  CONSTRAINT T1_MV_FK FOREIGN KEY (ID_T2) REFERENCES T1_MV (ID)
);

Code: Select all

 protected override void OnModelCreating(ModelBuilder modelBuilder) { 
      modelBuilder.Entity<Region>() 
      .Property(x => x.Geometry) 
      .HasColumnType(@"SDO_GEOMETRY"); 
  }