Devart Forums

Code: Select all

    public class Parent
    {
        public int Id { get; set; }
        public virtual Child Child { get; set; }
        public int ChildId { get; set; }
    }

    public class Child
    {
        public int Id { get; set; }
    }

    public class SubChild : Child
    {}

    public class TestDbContext : DbContext
    {
        public IDbSet<Parent> Parents
        {
            get { return Set<Parent>(); }
        }

        protected override void OnModelCreating(DbModelBuilder modelBuilder)
        {
            modelBuilder.Conventions.Remove<ColumnTypeCasingConvention>();
            modelBuilder.Conventions.Remove<IncludeMetadataConvention>();

            var parentConfig = modelBuilder.Entity<Parent>();
            parentConfig.HasKey(p => p.Id);
            parentConfig.HasRequired(p => p.Child)
                        .WithMany()
                        .HasForeignKey(p => p.ChildId);
            parentConfig.Property(p => p.ChildId)
                        .HasColumnName("ChildId");
            modelBuilder.Entity<Child>()
                        .HasKey(c => c.Id);
            var subChildConfig = modelBuilder.Entity<SubChild>();
            subChildConfig.HasKey(s => s.Id);
            subChildConfig.ToTable("SubChildren");
        }
    }

    class Program
    {
        private static void Main(string[] args)
        {
            new Devart.Data.Oracle.OracleMonitor {IsActive = true};

            int parentId;

            using (var context = new TestDbContext())
            {
                var parent = new Parent
                    {
                        Child = new Child()
                    };
                context.Parents.Add(parent);
                context.SaveChanges();
                parentId = parent.Id;
            }

            using (var context = new TestDbContext())
            {
                var parent = context.Parents
                                    .Include(p => p.Child)
                                    .Single(p => p.Id == parentId);

                Console.WriteLine("Child is a " + parent.Child.GetType());
                Console.ReadKey();
            }
        }
    }

Code: Select all

SELECT
"Limit1"."Id",
"Limit1"."ChildId",
"Limit1".C1,
"Limit1"."Id1"
FROM ( SELECT
	"Extent1"."Id",
	"Extent1"."ChildId",
	"Join1"."Id1",
	CASE WHEN "Join1"."Id1" IS NULL THEN TO_CHAR(NULL) WHEN  NOT (("Join1".C1 = 1) AND ("Join1".C1 IS NOT NULL)) THEN '2X' ELSE '2X0X' END AS C1
	FROM  "Parents" "Extent1"
	LEFT OUTER JOIN  (SELECT
		"Extent2"."Id" AS "Id1",
		"Project1"."Id" AS "Id2",
		"Project1".C1
		FROM  "Children" "Extent2"
		LEFT OUTER JOIN  (SELECT
			"Extent3"."Id",
			1 AS C1
			FROM "SubChildren" "Extent3" ) "Project1" ON "Extent2"."Id" = "Project1"."Id" ) "Join1" ON "Extent1"."ChildId" = "Join1"."Id1"
	WHERE ("Extent1"."Id" = 1) AND ROWNUM <= 2
)  "Limit1"