Refreshing tableadapters when column name changed. RRS feed

  • Question

  • Hi all,

    i m using strongly typed tableadapters, now whenever i chang a column name in database, and if the application is running it throws "Failed to enable constraints error" until i change the column name in my table adapter, now i need to do this everytime i change a column name in database, is there any solution to refresh the tableadapter automatically when every we change column name in database.

    please help!

    Thanks Vinit
    Monday, July 7, 2008 7:47 AM

All replies

  • No, you would need to regenerate TableAdapter from the designer, because it is not a run-time thing only, but TableAdapter requires new re-generated code. If you want to avoid this situation, then you would need to use DataSet/DataTable directly from your code and do not rely on TableAdapter.


    Monday, July 7, 2008 9:52 AM