Re: BulkLoad with Composite Primary Key

[Joseph Lawler]

I got it to work. To be honest, not sure what changed. Too many tools being used.

I'm using native MySqlBulkLoader to load the table from CSV (Simple LoadAsync).
- I changed the class definition for the table to put the keys up front. That automatically re-arranged the columns in the infeed file to reflect the Composite Key (put them up front in correct order).
- I verified that the Primary Key(s) were first in the table in MySQL
Seems it should have worked. But nope it didn't.

Here's where I think something was wrong: I'm using Entity Framework for many of the simple queries. Out of laziness, I am also using EF to actually create the table (recreated before every load test). I looked there.

It started working once I also changed the EF modelBuilder definition for the table so that the modelBuilder columns reflected the Primary Composite Keys were listed first.

I've since reset the ModelBuilder definition (primary key columns no longer up front) and the data still loads. The table layout is the same either way (reflects the class definition).

Nothing else changed from before.

Oh well.
Thanks for offering to help!