Search code examples
entity-frameworkentity-framework-4

"Update Model from Database" does not see a type change

I have several columns that I changed from Int to BigInt.

I opened up my EF model and did an 'Update Model from Database' and expected to see those columns now be Int64s. But they are still Int32s.

(I ran it several times just to be sure.)

I double checked my database and the columns are definitely BigInts.

So... does 'Update Model from Database' not work for a change of data type? Does it need to be manually applied?

Solution

  • Unfortunately, you'll need to delete the items from your model and then add them back in - at least that's the only thing I have managed to get working.

    There is at least one third-party tool that is supposed to help with this, but have not tried it personally.