locked
Dynamic Data Wizard Broken with VS 2008 Std ? RRS feed

  • Question

  • User-889870728 posted

    I have Visual Studio 2008 (Standard) and Framework 3.5 SP1  Running on Vista Ultimate

     I have an existing SQL Server 2005 Express database which has had all the relationships carefully tuned to allow the wizard to work.

     Some Issues:

    1/. When running the wizard, I have an existing DB Connection defined which appears in the list as the default item in the drop down that says
    "Create a new data model from this database".  I know that the listed item contains correct connectiuoin details because it also appears in Server Exp[lorer and I am able to browse the database.
    If I click 'Next' on this dialog the 'Which database items do you want to add to the model' box says 'connecting', the Data Contect Namespace is blank, and so is the Data Contexct Class Name.  Eventually 'Not responding' appears on the wizard dialog.

    If I try to close the dialog, then Visual Studio crashes.
    Looks like a bug to me, when will this be fixed ?  Has this already been fixed, perhaps I have an old version ?
    The work around is for me to redefine the connection parameters by clicking on the 'New connection' button.  This is hardly intuitive !!

     2/. Moving on.  If I redefine the connection then the  'Which database items do you want to add to the model'  dialog populates itself correctly, and it has all Tables, Views, Stored Procedures and Functions ticked by default.
    If I leave Views, Stored procedures and functions ticked, it does not seem to make any difference to the final product, so I am wondering why they are ticked by default ?
    So, I turn them off, leaving just Tables Ticked.

    I expend the listing and de-select tables that I KNOW are going to make life difficult for the wizard.

    I hit 'next' to continue because I want to create bespoke pages for each table edit.  The default views are really crappy in their layout.

    On the next screen I hit 'Add All'.

    The next screen that appears is the 'customize website' screen.
    This has a 'Properties' > 'Layout' area which is disabled because the only choice is 'Tabular'.  << So when will there be other choices available, because the tabular layout is what I mean when I say the screen layout produced by the wizard is crappy.  There are content options on this screen that change when I select different items in the website pane, but the only real choice is 'inline'  or a specified file name.  It is possible to select fields for editing / display...

     3/. So, when I hit 'Finish' on this screen I hit the real problem: I get a whole series of error dialogs that always say

    'Could not reformat the document.  The original format was restored' and when I click OK on that one, 'Could not complete the function'.
    This pair of error dialogs seems to appear one for every bespoke form page generated by the wizard !!
    There seems to be no way to get out of the wizard when this starts to occur, and I have to hit eneter several million times to get the wizard to complete.

    Surely I cannot be the only person seeing these issues ?  They seem to be really basic problems that surely the developers would have noticed and fixed by now ?
    Have I got the right version of the wizard installed ?  Do I have something unique in my environment ?

    Cheers,

    Bryn

     

    Friday, August 29, 2008 4:42 AM

All replies

  • User-1069526884 posted

    Hi bryn.parrott,

    It sounds to me like you aren't running VS2008 SP1 (a requirement for the 08/06 release), which you can get here: http://www.microsoft.com/downloads/details.aspx?FamilyId=FBEE1648-7106-44A7-9649-6D9F6D58056E&displaylang=en.  This will address the problem you describe in #3.  I have not seen the issue you describe in #1.  If it is not fixed by upgrading to SP1, please give us more details on the database so that we can investigate.  It may be related to the fact that this is an express database, so I will discuss this with our testers.

    We are aware that the default layout won't suit everyone.  I cannot give you a date as to when other layout choices will be available, but can tell you we have many ideas around ways to change the markup and code that is generated.  Please note that the wizard is in an early state; we are providing it as a preview to users to gauge interest, get feedback, etc.  In the current release (and likely in many future ones) there are many bugs, some of them major, and this is simply because it is not complete.

    Friday, August 29, 2008 2:30 PM