Entity framework code first - create table and insert data from existing table into newly created one,
<p>I'm using EF code first and I want to create a new table and insert values from an existing table into it.</p>

<pre><code>public override void Up()
        {
            CreateTable(
                "dbo.UserCulture",
                c =&gt; new
                {
                    UserCultureId = c.Int(false, true),
                    Id = c.Int(false),
                    IsSelected = c.Boolean(false),
                    Culture = c.String(false, 10),
                    UserLevel = c.Int(false),
                    CurrentScore = c.Int(false),
                    TimelinePercentage = c.String(false, 3),
                    NumberOfGamesPlayed = c.Int(false)

                })
                .PrimaryKey(k =&gt; k.UserCultureId)
                .ForeignKey("dbo.AskUser", k =&gt; k.Id)
                .Index(t =&gt; t.Id);

            Sql("INSERT INTO UserCulture(UserCultureId, Id, IsSelected, Culture, UserLevel, CurrentScore, TimelinePercentage, NumberOfGamesPlayed)" +
                "SELECT newid(), UserId, 1, CreatedCulture, UserLevel, CurrentScore, TimelinePercentage, NumberOfGamesPlayed FROM AskUser");

        }
</code></pre>

<p>When I ran this migration it created the table but it was empty. Does anyone know what I should do?</p>