I believe the best way to accomplish it is to perform it in EF code first, using either attributes or fluent api:...mapping of a foreign key to a non-primary key in Entity Framework 6.1.3...Is it feasible to convert an Entity Framework 5.0 composite foreign key to a non-primary key?...First mapping in Entity Framework Code without a foreign key...H...
I had to come up with my own remedy, which I did as follows:.../// <summary>
/// A helper class for managing custom behaviors of Mockable database contexts
public static partial class EFSaveChangesBehaviors
/// Enable auto-incrementing of primary key values upon SaveChanges/SaveChangesAsync