Entity Framework 7 and SQLite tables do not create

Question

I have been trying for some time to figure out how to use one DBC text to create multiple tables in Code First without any luck. I'm sure this is just my ignorance with the wireframe, but I'm not sure what I am missing. Here is a simple example with objects and DBContext.

[Table("MyEntity")]
public class MyEntity
{
    [Key, DatabaseGenerated(DatabaseGeneratedOption.Identity)]
    public Guid Id { get; set; }
    public string MyColumn { get; set; }
    public int MyNumber { get; set; }
}

[Table("MySecondEntity")]
public class MySecondEntity
{
    [Key, DatabaseGenerated(DatabaseGeneratedOption.Identity)]
    public Guid Id { get; set; }
    public string MyColumn { get; set; }
    public int MyNumber { get; set; }
}

public class MyContext : DbContext
{
    public DbSet<MyEntity> MyTable { get; set; }
    public DbSet<MySecondEntity> MyTable2 { get; set; }

    protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
    {
        var connectionStringBuilder = new SqliteConnectionStringBuilder {DataSource = "test.db"};
        var connectionString = connectionStringBuilder.ToString();
        var connection = new SqliteConnection(connectionString);

        optionsBuilder.UseSqlite(connection);
    }
}

It seems to me that this should work, but when I call it in the code below, it explodes with the exception of Sqlite exceptions in the form of a table: MyEntity when the first foreach loop hits.

static void Main(string[] args)
    {
        using (var db = new MyContext())
        {

            MyEntity testEntity1 = new MyEntity();
            MySecondEntity entity1 = new MySecondEntity();

            testEntity1.MyColumn = "Test Data 1";
            testEntity1.MyNumber = 12345;

            db.MyTable.Add(testEntity1);
            db.Database.Migrate();

            entity1.MyColumn = "New Data 1";
            entity1.MyNumber = 2;

            db.MyTable2.Add(entity1);
            db.Database.Migrate();

            Console.WriteLine("Inserting Data...");

            Console.WriteLine("Data in the Database");

            foreach (var entity in db.MyTable)
            {
                Console.WriteLine("Id: " + entity.Id);
                Console.WriteLine("Column Data: " + entity.MyColumn);
                Console.WriteLine("Number: " + entity.MyNumber);
            }

            foreach (var entity in db.MyTable2)
            {
                Console.WriteLine("Id: " + entity.Id);
                Console.WriteLine("Column Data: " + entity.MyColumn);
                Console.WriteLine("Number: " + entity.MyNumber);
            }
        }

        Console.WriteLine("Examples run finished,press Enter to continue...");
        Console.ReadLine();
    }  

- , , , , . , ​​ GitHub https://github.com/aspnet/EntityFramework/issues/2874, . , , , ?

, http://ef.readthedocs.org/en/latest/getting-started/uwp.html, @natemcmaster, , @lukas-kabrt, . , / .

Install-Package EntityFramework.Commands –Pre
Add-Migration MyFirstMigration
Update-Database

Answer 1

DbContext - , .. DbContext, , DbContext. Code-first .

ASP.NET 5 project.json

"commands": {
    "ef": "EntityFramework.Commands"
}

,

dnx ef migrations add MyFirstMigration
dnx ef database update 

.NET ( "" - " NuGet" - " " ).

Install-Package EntityFramework.Commands –Pre
Add-Migration MyFirstMigration
Update-Database

Answer 2

UWP - EF 7 . .

UWP . DB ApplicationData.Current.LocalFolder

options.UseSqlite("Data Source=" + Path.Combine(ApplicationData.Current.LocalFolder.Path, "blogging.db"))

, UWP . .

       using (var db = new BloggingContext())
        {
            db.Database.Migrate();
        }