How data initialization works?

Ask Time：2013-01-01T00:01:20 Author：jnemecz

I have problem with initializing data into SQL Server Compact .sdf data file in .NET web application.

I have a data initialization class.

namespace R10491.Models
{
    public class SampleData : DropCreateDatabaseAlways<LibraryEntities>
    {
        protected override void Seed(LibraryEntities context)
        {
            var categories = new List<Category>
            {
                new Category{Id=1, Name="Sci-fi"}
            };

        }
    }
}

(for testing purposes I use DropCreateDatabaseAlways instead of DropCreateDatabaseIfModelChanges)

This initializer class I call in the Global.asax.cs file:

protected void Session_Start()
{
   System.Data.Entity.Database.SetInitializer(new R10491.Models.SampleData());
}

(again for testing purposes I call it on every session start).

My connection string definition:

  <connectionStrings>
    <add name="LibraryEntities"
     connectionString="Data Source=C:\Users\Administrator\Documents\Visual Studio 2012\Projects\2OBOP3_KU1\R10491\App_Data\R10491_library.sdf;"
     providerName="System.Data.SqlServerCe.4.0"/>
  </connectionStrings>

But the initialization doesn't work - tables defined in SampleData class are not created nor data are initialized.

Author:jnemecz，eproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article：https://stackoverflow.com/questions/14103636/how-data-initialization-works

How data initialization works?