I've got a small database with a single table and with a view. The view is coming from a different database (i.e, it does select * from db.dbo.someTable). I can select from the view fine using a query. When I try to add the view using "Update Model from Database", the wizard opens, I check my view under the views branch of the tree and click finish. The wizard goes away but the view is never added.
If I update again, I can still see the view under the "Add" portion of the wizard (not under refresh). No matter how many times I add it, it never actually adds and no errors pop up.
Also, as an interesting side note... if I close my EDMX window I cannot open it back up from the solution explorer. Double clicking on it simply expands the node. I have to restart studio to get it to work again.
Anyone seen this? The user who is adding the view is pretty restricted - the only thing it can do is select * from the view. Are there special permissions the user needs to use the model designer?