Is there any option that allows to ignore sys tables when updating model from database? In my case I always have sysdiagram entity and related objectset.
thanks in advance.
+1
A:
Just deselect the tables you don't want to add/update in the dialog:
Yakimych
2010-08-28 21:46:44
It's when you are creating. I already have the model and I need option to exclude entity from the model. In my case it's sysdiagram that shows up each time I do updating from database model. I mean that each time you run "update from database model" it would grab all tables into entities. I don't need them all. I need the specific entity generation. I don't need entity generation for each table in database. Is there any way to mark them?
AndrewG
2010-08-30 19:47:00
If you delete the `sysdiagrams` entity in the designer and then click `Update model from database` don't you get a dialog similar to the one in the picture? It should be called `Update wizard`. If you do, make sure the `sysdiagrams` table is deselected and see what happens.
Yakimych
2010-09-01 21:51:29
That is the point, I have no such dialog. Sound like it's possible only on creating first time
AndrewG
2010-09-02 11:35:49
That's weird. Are you using VS 2010, btw? Have you tried deleting and re-creating the model? Then you can deselect the table when creating the model.
Yakimych
2010-09-02 11:56:46