CODEWITHSUNDEEP
visual-studioviewazurevisual-studio-2012azure-sql-database
b0x0rz
b0x0rz

Reputation: 3981

visual studio azure db view that allows updating

doing this - in the server explorer of visual studio 2012:

get result as a single entry!

however, it is read only, meaning - can not edit it and update directly from this view.

this used to work in previous visual studio and mssql database.

is this a bug, feature, etc? and how to have the behaviour from previous visual studio (where if you can remember there was a visual designer of a view that had this capability)? want to execute a select query, get some results that are then in-place editable and will perform an update on the database.

thnx a lot

Upvotes: 0

Views: 159

Answers (1)

Igorek
Igorek

Reputation: 15850

Editing results of a query never worked, neither from SQL Management Studio or other tools. What has worked and continues to work in VS2012 is editing data from a table:

Navigate to the desired table, right-click and choose "Show Table Data". This data is editable, provided your account has permissions.

HTH

Upvotes: 1

Related Questions