EF6 Code First

[christian_bertram]

Hi, i dont know if this is a task of the Entity Framework or the dotConnect Provider:

I have a problem with Generating my Oracle tables via code first.
Referenced tables are generated correctly with the Add-Migration functionality. (Initial Migration)
Non-Referenced tables are missing in the generated Migration. I always have to make a reference to another table. But of course there are control tables without any reference, so any idea what is the solution here ?

Thanks.

[christian_bertram]

Ok i still dont know if this is based on a dotconnect bug or entityframework but i could solve it by adding an extra line with the fluent api to the OnModelCreating method

Code: Select all

modelBuilder.Entity<TABLENAME>().ToTable("TABLENAME");

it was not possible to force the generation with data annotation

Code: Select all

[Table("TABLENAME")]

[Shalex]

This code creates the TABLENAME table in the database:

Code: Select all

namespace ConsoleApplication {
    class Program {
        static void Main(string[] args) {

            var monitor = new Devart.Data.Oracle.OracleMonitor() { IsActive = true };

            using (var context = new MyDbContext()) {

                context.Database.Initialize(false);
            }
        }
    }

    class MyDbContext : DbContext {

        public MyDbContext()
            : base(new Devart.Data.Oracle.OracleConnection("server=***;uid=***;pwd=***;"), true) { }

        static MyDbContext() {
          DbConfiguration.SetConfiguration(new Devart.Data.Oracle.Entity.OracleEntityProviderServicesConfiguration());
        }

        DbSet<MyClass> myClasses { get; set; }
    }

    [System.ComponentModel.DataAnnotations.Schema.Table("TABLENAME")]
    class MyClass {
        public int Id { get; set; }
        public string data { get; set; }
    }
}

If this doesn't help to fix the problem, please send us a small test project for reproducing the issue you have encountered.

[christian_bertram]

I tried the "Table"-tag but it didn´t work.

[Shalex]

Have you tried running our code (without changes, except connection string) in the brand new test project? Notify us about the result.