EFSpecs

EFSpecs is a library to assist in testing your entity framework model mapping. It will create an entity with the values you provide it with, then send that entity off to the database, then pull it from the database to verify the values were saved correctly. And being the good citizen that it is, the whole thing is wrapped in a transaction so it all gets rolled back.

[Test]
public void VerifyContactsMappings()
{
  new PersistenceSpecification<Person>(() => new Context())
    .CheckProperty(x => x.Name, "Zaphod Beeblebrox")
    .CheckProperty(x => x.NumberOfHeads, 2)
    .CheckProperty(x => x.NumberOfArms, 3)
    .CheckReference(x => x.DistantCousins, new Person { Name = "Ford Prefect" })
    .VerifyMappings();
}

You may notice that this resembles Fluent NHibernates persistance specifications. That's because I went from a Fluent NHibernate project to one that uses Entity Framework and really missed this simple mapping test.

Todo

I still have a few more things to accomplish with this library before I unleash it to the wild:

• Create more integration tests
• Refactor to be unit tested
• Add specific exceptions for known SQL errors such as invalid column, invalid object (table), etc
• Add better error messages

License

EFSpecs is released under the MIT License.