This project has moved and is read-only. For the latest updates, please go here.

Adding records with identity/computed off

Feb 12, 2015 at 6:10 PM
We have a scenario where we are trying to use Effort across multiple Databases when we are trying to load records into a table with an identity column we lose that id but that id is referenced by a data column in a table in a different database. Any ideas on how we can add records w/o treating it as an identity column ie set identity insert in T-SQL ?

Thanks
Feb 13, 2015 at 5:09 PM
I am not sure if I understand your problem, but you may try to use the db manager property exposed by the fake connection object.

Hope this helps!
Apr 2, 2015 at 3:36 PM
Problem is if we disable identity all entities get 0 as the primary key instead of the number in the key.
Apr 13, 2015 at 12:53 PM
That's because EF will still threat the field as identity field. You may able to work around this by disabling the database generation option as well.