How to check if database schema matches Entity Framework schema?

entity-framework ef-code-first database-schema initializer
Eduardo Brites picture Eduardo Brites · Oct 26, 2012 · Viewed 16.4k times · Source

For my surprise, using the CreateDatabaseIfNotExists context initializer, the line

context.Database.Initialize(true)

doesn't throw an exception if the schema does not match my code first schema.

Is there a way to validate if the current database matches our schema before, for instance, we try to access a entity, whose table doesn't exist on the database anymore, and an exception is thrown by EF?

Answer

AxdorphCoder picture AxdorphCoder · Aug 22, 2014

You can call CompatibleWithModel to determine if the database matches the model. If you set the parameter to true it will throw an exception if no model data is found in the database.

bool isCompatible = context.Database.CompatibleWithModel(true);

Related questions

Updating database schema with Entity Framework Code First

Entity Framework Code First is a great framework for developing new projects. But what about extending an existing database? For instance what if I simply want to add an additional property to an existing data entity? Is there any "code …

Read More
Code-first vs Model/Database-first

What are the pros & cons of using Entity Framework 4.1 Code-first over Model/Database-first with EDMX diagram? I'm trying to fully understand all the approaches to building data access layer using EF 4.1. I'm using Repository pattern and IoC. I know …

Read More
Entity Framework 6 Code first Default value

is there "elegant" way to give specific property a default value ? Maybe by DataAnnotations, something like : [DefaultValue("true")] public bool Active { get; set; } Thank you.

Read More