none
LINQ to SQL Classes not updating after sproc add RRS feed

  • Question

  •  Hello everyone,

     I have run into an annoying issue with LINQ to SQL .dbml updating.  After the initial save any changes that I make like the addition of a sproc to the methods pane is not showing up in the intellisense pick list or being recognized as an object. So when I try and reference the newly added sproc I get the error:

     type: spInsert_T_E_R_CategoryResult is not defined.

     Does anyone know why this is happening.  I have been searching through the forums for a couple days now without any success.

    Currently I am able to get around the problem by recreating the .dbml from scratch when I need to add a sproc.

    Thanks for taking a look,

    Pat


    Applications Programmer / Developer
    Tuesday, February 10, 2009 5:32 PM

Answers

  • Sorry that's how it is. The Linq to SQL dbml has no "refresh" functionality.

    I think there are some products out there that do this.. try http://www.huagati.com/dbmltools/

    I wrote my own by using SQLmetal.exe to write a new full dbml and then doing a merge between that and the new one.

    Howard
    Wednesday, February 11, 2009 12:53 PM
    Answerer

All replies

  • Sorry that's how it is. The Linq to SQL dbml has no "refresh" functionality.

    I think there are some products out there that do this.. try http://www.huagati.com/dbmltools/

    I wrote my own by using SQLmetal.exe to write a new full dbml and then doing a merge between that and the new one.

    Howard
    Wednesday, February 11, 2009 12:53 PM
    Answerer
  • I was facing the same problem...

    Since I open the DBML file in design mode and (in the properties tab) set the connection to "(none)", it got refreshed...

    regards,

    Victor
    Sunday, April 19, 2009 7:27 PM