"The given ColumnMapping does not match up with any column in the source or destination." about efcore.bulkextensions HOT 8 CLOSED

I don't see why it should take too long to find difference between columns of one table compared to one Entity.
Still I think this could be added.
That exception is being thrown on sqlBulkCopy.WriteToServer(reader) in Insert method but it gives no more info so specific column could not be read from there.
What could be done is that additional function be added into catch segment which will check what column is missing. For this CreateTableCopy could be used since that function will return specific info like this:

Invalid column name 'MissingColumnName'.

I will see to implement it with next version.

from efcore.bulkextensions.

Awesome thanks! I agree its not a super big deal but when the table has 50+ columns and I'm not even aware that a migration was created (I didn't do it) then this could be very helpful again in the future.

from efcore.bulkextensions.

Improvement added with Nuget 2.1.8

from efcore.bulkextensions.

I just ran into this issue and found that there was a fix for it... which is great! However, I updated the package and now I don't get any error, but it also doesn't actually insert any records into the table. Any thoughts on this?

from efcore.bulkextensions.

After investigating, there were some columns that did not have the same case... but I was anticipating that I would still receive an error, just a more friendly one that would let me know which column/s were the offenders. Is that not the case?

from efcore.bulkextensions.

Try now with 2.1.9 version.

from efcore.bulkextensions.

@borisdj - I updated to 2.1.9 and am getting the exception now (as expected), but I was under the impression that the enhancement talked about here was going to tell me which column/s are the offenders. Did I misunderstand something?

from efcore.bulkextensions.

It seems that you have some different situation where specific exception in not being catch.
Write more info on how to reproduce it and try debugging with library source.

from efcore.bulkextensions.