I'm writing a server for a client that I do not control. I'm using HasData to seed the database with static information that the client refers to by ID. The client uses 1-based numbering for almost everything, but there is one entity that uses 0-based numbering.
My working solution is to add a ClientId column to the table. But I wonder if there's a way to configure NO_AUTO_VALUE_ON_ZERO or something, using EF attributes or fluent config, and only for that one table, so that HasData can insert 0.
The solution was obvious in retrospect. An ID value of 0 is only disallowed because it normally represents auto-assign. I simply added [DatabaseGenerated(DatabaseGeneratedOption.None)] to the entity's ID property. As I mentioned, this data is static so there won't be any inserts to worry about.