Added Sql Server EF6 models and diagrams and created the database with it. Properties still need to be added to all the entities, but the PKs and FKs are all correctly mapped.