rubidge96 rubidge96 - 1 year ago 102
SQL Question

Updating an EDMX database with new columns

I'm using an edmx database to place data onto a map which until this point has been working absolutely fine. Problem is, I realised I needed another column. So I went into SQL Server Management Studio and added that column. After some looking into, i thought that going into the edmx and 'refreshing' the tables would enable to get data from the new columns. However, if i try and do that, even just try and show the value in an alert, my map ceases to exist... this is kind of a problem. Am i doing something wrong???

Answer Source

You can Update your EDMX no need to delete and re-adding EDMX :

-> Right Click on EDMX
-> Select Click Open
-> Right Click On Page
-> Select Update Model From Database EDMX
-> Save your changes

Hope This will hell you !!
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download