Entity Framework 4.1

Code First: What is that EdmMetadata table?

This is one of those posts that may only be useful for a short time since we already have a group of people working on migrations support for Code First. That being said I've been asked twice in the corridors of Building 18 recently how to manually create the model hash that Code First stores in the EdmMetadata table so I thought a few words about that strange EdmMetadata thing might be generally useful.

The EdmMetadata table is a simple way for Code First to tell if the model used to create a database is the same model that is now being used to access the database. As of EF 4.1 the only thing stored in the table is a single row containing a hash of the SSDL part of the model used to create the database.

(Geek details: when you look in an EDMX file, the SSDL is the part of that file that represents the database (store) schema. This means that the EdmMetadata model hash only changes if the database schema that would be generated changes; changes to the conceptual model (CSDL) or the mapping between the conceptual model and the database (MSL) will not affect the hash.)

Checking if the model hash matches

You might want to write your own database initializer that checks whether or not the hash stored in the database matches that of the current model. The easiest way to do this is to use the CompatibleWithModel method on Database. For example, you could do something similar to DropCreateDatabaseIfModelChanges with code like this:

public void InitializeDatabase(TContext context)
{
    if (context.Database.Exists())
    {
        if (context.Database.CompatibleWithModel(throwIfNoMetadata: true))
        {
            return;
        }

        context.Database.Delete();
    }

    // Database didn't exist or we deleted it, so we now create it again.
    context.Database.Create();

    Seed(context);
    context.SaveChanges();
}

Note that by default the model hash is written to the database any time that Database.Create() is called.

Reading the raw hash value

When the EdmMetadata table is in use it is mapped to the EdmMetadata class in your Code First model. This means that you can query for the value in the table using something like this:

public static class EdmMetadataExtensions
{
    public static string QueryForModelHash(this DbContext context)
    {
        return context.Set<EdmMetadata>().AsNoTracking().Single().ModelHash;
    }
}

This code assumes that the table exists and contains data; if this might not be the case then you should add some more checking that the query succeeds and returns valid data.

Of course, you could instead write raw SQL (using Database.SqlQuery) to access this data if you wanted to.

Getting the hash of the current model

Sometimes you might want more control over the model hash than Database.CompatibleWithModel or Database.Create gives you. For example, you might want to write the model hash into a database that was created or modified by some means other than the Database.Create method. You could do this using code something like this:

    public static void SaveModelHashToDatabase(this DbContext context)
    {
        // Create an EdmMetadata entity containing the model hash for
        // the given context.
        var edmMetadata = new EdmMetadata
        {
            ModelHash = EdmMetadata.TryGetModelHash(context)
        };
        
        // Insert the model hash into the database.
        context.Set<EdmMetadata>().Add(edmMetadata);
        context.SaveChanges();
    }
}

This code uses the static TryGetModelHash method on the EdmMetadata type to get the model hash of the given context. (Note that you can only get a model hash for a context that has been created using Code First; getting a hash is currently not supported for Database First or Model First contexts, although you could create an SHA-256 hash of the SSDL in the EDMX file yourself if you really wanted it.)

The code above then sets the model hash into an EdmMetadata object and this object is saved to the database. Depending on what you then want to do with the context you might want to detach the EdmMetadata entity from the context; if you're using this code in a database initializer this is probably not necessary since the initializer effectively does this for you.

Again, you could choose to save the data to the table using raw SQL instead of the mapped EdmMetadata entity type.

But I don't want EdmMetadata at all!

In the CTP4 versions of what is now EF 4.1 the mapping of the EdmMetadata table by default could be quite problematic, especially when using Code First against an existing database. Since CTP5 this has been much less of a problem, but there may be times when you still don't want this entity added to your model. You can prevent DbContext from adding it by removing IncludeMetadataConvention in your OnModelCreating method. For example:

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

So there you are, probably more details on EdmMetadata than you ever wanted. Hope some people find it useful.


This page is up-to-date as of April 3rd, 2011. Some things change. Some things stay the same. Use your noggin.