Search code examples
databaseentity-frameworkvisual-studio-2010ado.netentity-framework-4

Update model from database erases all customizations to SSDL file EF4


I've made some changes to the SSDL inside the .edmx mainly for custom stored procs but whenever I do an update model from database it erases all my customization's, is there a workaround or a setting that would make it not erase my changes? example: I'll put this inside the ssdl

  <Function Name="InsertUpdateStoredProc" IsComposable="false">
    <CommandText>
      EXEC TWO.dbo.InsertUpdateProduct
      @Address = @Code,
      @CustomerNumber = @CustomerNumber,
      @EquipmentID = @EquipmentID,
      @ManufacturerID = @ManufacturerID,
      @EquipmentType = @EquipmentType,

    </CommandText>

Then once I do an update it's overwritten


Solution

  • You are obliged to delete your model and than create again