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

Cannot access destination table

Feb 29, 2016 at 5:38 PM
I just discovered this extension and my first test of it has failed with the following error:
Cannot access destination table '[].[WorkTable]'.
Why is the owner empty? It should be "dbo". For reference, I'm using EF 6.1.3. What am I missing? I'm pretty new to EF, so I'm sure I've slipped up somewhere.
Feb 29, 2016 at 11:52 PM
Looks like there's a bug in efmappingapi that returns null for the schema when the table being probed does not have a primary key. (I had no need for a primary key on this work table, so I didn't make one.) Once I determined this was the problem, I added a dummy identity column and made it the PK. The insert worked fine after that.