从Server Explorer拖放到DataSet和DBML Designer不工作 [英] Drag and Drop From Server Explorer to DataSet and DBML Designer NOT Working

问题描述

我今天早上通过设计器从Linq到SQL DBML文件中删除了一个表。进行了几次更改后，我尝试将表添加回DBML设计器表面，Visual Studio不执行任何操作。当我尝试从服务器资源管理器中的列表拖动表时，我没有得到指示它正在尝试拖放操作的箭头。我已经尝试从服务器浏览器拖动几个其他表到设计器无效。我没有收到错误。

我还尝试在同一个解决方案中的另一个项目中更新DataSet，并获得相同的结果。 Visual Studio 2010不让我将服务器资源管理器的表从XSD或DBML文件的设计器表面拖动。

  1）关闭VS 
中的所有窗口2）重新启动VS 
 3）重新启动PC 
 4）还原DBML到早期版本
  

任何建议？这个星期五工作正常，我在框架中没有任何重大变化。

刚刚尝试了以下两件事情：删除用户选项文件并重新启动VS并创建新项目与DataSet并尝试从服务器浏览器拖动表。两个都失败了。

解决方案

好的，我终于解决了这个问题。

< >这个问题似乎是在Visual Database Tools DLL中。

这个DLL文件由VS 2010安装安装，但在SQL Server 2012安装过程中升级到SQL 2012版本的工具。此后，卸载并重新安装SQL或VS将不会删除此较新的DLL，以便允许安装旧版本，因此会导致此烦人的问题。

我如何修复这是我设置了一个干净的虚拟机并安装了VS 2010，然后从我的虚拟机拿起了这个原始的DLL，并覆盖了我的直播机上的DLL。

我认为删除此DLL文件，然后执行VS 2010修复或卸载/重新安装也会解决问题。

DLL（在X64机器上）的目录和文件名是：C：\Program Files（x86）\Common Files\microsoft shared \Visual Database Tools\ dsref80.dll

我希望这有助于拯救别人的痛苦！

I removed a table from a Linq to SQL DBML file via the designer this morning. After making several changes, I attempted to add the table back to the DBML designer surface and Visual Studio does nothing. When I try to drag the table from the list in Server Explorer, I do not get the arrow indicating that it is attempting a drag and drop operation. I have tried to drag several other tables from server explorer to the designer to no avail. I do not get an error.

I also tried updating a DataSet in another project that resides in the same solution and I get the same result. Visual Studio 2010 is not letting me drag tables from the server explorer to my designer surface for XSD or DBML files.

I have tried the following things so far

1) Close all windows in VS
2) Restart VS
3) Restart PC
4) Revert DBML to earlier versions

Any suggestions? This was working fine on Friday and I have not changed anything significant in the framework.

Just tried the following two things as well: Delete user option files and restart VS and create new project with DataSet and try to drag table from server explorer. Both failed.

解决方案

Okay, I finally solved this problem.

The problem seems to be with the Visual Database Tools DLL.

This DLL file is installed by the VS 2010 installation, but during a SQL Server 2012 installation, it will be upgraded to the SQL 2012 version of the tools. Thereafter, uninstalling and reinstalling SQL or VS will not remove this newer DLL in order to allow the older version to be installed, and hence leave this annoying issue.

How I fixed it was I set up a clean virtual machine and installed VS 2010, then took this original DLL from my virtual machine and overwrote the DLL on my live machine. Simple as that.

I would assume though that deleting this DLL file and then doing a VS 2010 repair or uninstall/reinstall would also fix the problem.

The directory and file name of the DLL (on an X64 machine) is: C:\Program Files (x86)\Common Files\microsoft shared\Visual Database Tools\dsref80.dll

I hope this helps save someone else hours of pain!

这篇关于从Server Explorer拖放到DataSet和DBML Designer不工作的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！