LocationID is an identity field, so good, i can get rid of that.

Re the Db - I have now brought it within the project, as you suggested above.