Drag Drop DLink Designer Bug

When I drag a table from the server explorer onto the DLink Designer window the entity isn't displayed there nor is it created in the class. I did find that this is a known issue here: http://msdn.microsoft.com/netframework/future/linqissues/

However, when I apply the workaround, that does not solve the problem. The workaround suggests that my database isn't using the default schema and instructs me to drop a class from the toolbox onto the designer, then, change the table name to mySchema.TableName. My attempt at this fix has proved unsuccessful. I'm assuming this fix is supposed to automatically generate the code (properties/fieldnames) from the table but it doesn't.

Does anyone have any other ideas I have taken one table and manually added all of the properties to the class and that is VERY time consuming. We are not using SQL Server 2005 as of yet. Is that the problem We are using the second latest SQL Server (I believe 2003).

I am plagued with wanting to use these new tools but often times don't because the initial releases are so finicky it keeps me from being productive.

Thank you.
Brian.


Answer this question

Drag Drop DLink Designer Bug

  • orokulus

    I found the answer after speaking with a couple of guys from Microsoft.

    Although I have ownership rights to the database, I have somewhat restricted rights to the sql server itself. My manager temporarily gave me sa (administrator) rights to the sql server and that worked great.

  • Drag Drop DLink Designer Bug