locked
adding a column / property RRS feed

  • Question

  • I realize this is a pretty simple question, but how do I add a column to my database table and have that column show up in the output? 

     

    Wally

    Friday, September 21, 2007 7:28 PM

Answers

  • First add the column to the database, either from the Visual Studio database tools (e.g. from the "server explorer" side bar in VS) or from the database tool itself.

     

    Then re-run the EDM wizard to create a new model. In a future iteration of the EDM schema designer we're considering supporting a "refresh store schema" feature to make it easy to refresh the schema and then manually map any new columns.

     

    Pablo Castro

    Technical Lead

    Microsoft Corporation

    http://blogs.msdn.com/pablo

     

     

    Friday, September 21, 2007 7:32 PM
    Moderator

All replies

  • First add the column to the database, either from the Visual Studio database tools (e.g. from the "server explorer" side bar in VS) or from the database tool itself.

     

    Then re-run the EDM wizard to create a new model. In a future iteration of the EDM schema designer we're considering supporting a "refresh store schema" feature to make it easy to refresh the schema and then manually map any new columns.

     

    Pablo Castro

    Technical Lead

    Microsoft Corporation

    http://blogs.msdn.com/pablo

     

     

    Friday, September 21, 2007 7:32 PM
    Moderator
  • Thanks Pablo.  Julie Lerman showed me that I could manually edit and get the changes necessary in the edmx file.

    Wally
    Friday, September 21, 2007 7:47 PM