The types of the properties specified for the foreign key
 {'Departmentid' : short} on entity type 'Employeedepartmenthistory
(Dictionary<string, object>)' do not match the types of the properties
in the principal key {'Departmentid' : int} on entity type 'Department
(Dictionary<string, object>)'. Provide properties that use the same
 types in the same order.

…xt-ef-generation

Fix Adventureworks Scaffold-DbContext generation

* this database has been harder to maintain due to being a zipfile. Data is cheap, lets keep it unzipped.

…cialOfferProduct-import

Fix adventureworks SpecialOfferProduct CSV import

remove manual inserts in Adventureworks install.sql