edmx generation with ConcurrencyMode = Fixed by default RRS feed

  • Question

  • I have an edmx with approx 150 tables, and want to set the ConcurrencyMode="Fixed" for the Version Timestamp column on all the tables. 

    I can do it one by one but for the life of me, there has to be a better way. Also, the problem is that edmx does not sync columns (add/remove) properly with  the database. So we are in the habit of always deleting all tables and recreating them.. 

    Many Thanks..! Before i take on a long journey of modify one by one..

    • Edited by bobragland Friday, October 12, 2012 9:31 AM
    Friday, October 12, 2012 9:31 AM


  • Hi bobragland,

    Welcome to MSDN Forum.

    The default value by design is 'None', EF knows nothing about which column we want to set the 'Concurrency Mode' as 'Fixed', so we have to set one by one. But your suggestion is really sensible, if we can set all the rowversion columns' ConcurrencyMode as Fixed by default, it will save us more time. I suggest you to submit a new suggestion here. : )

    Best Regards

    Allen Li [MSFT]
    MSDN Community Support | Feedback to us

    • Marked as answer by Allen_MSDN Friday, October 19, 2012 2:54 AM
    Monday, October 15, 2012 2:58 AM