ADO.NET BUG Entity Data Model

Question

I have a project in visual studio final 2010 (MVVM) and a database in SQLITE.

Everything worked fine, but now I have a problem with the ADO.NET Entity Data Model.

I searched for information about this and did not find much. Every time I want to open a master, it just closes.

I think I should reinstall Visual Studio, but before doing this, if someone had this error before and knew that maybe I would be grateful.

Answer 1

I found that this could be an error when third-party data adapters remain in strange states. Open View > Server Explorer and delete third-party data connections. Then try opening the wizard again.

Answer 2

I had this problem with VS 2013 (Entity Model disappeared). I solved this by first removing MySQL.NET/Connector (I had 6.8.3), and installed it back, and then tried the wizard again. The wizard completes and I can select tables, etc.

Answer 3

Try deleting the following file

C:. \ Users \ MyUserName \ AppData \ Roaming \ Microsoft \ VisualStudio \ 10.0 \ SeverExplorer \ DefaultView.SEView

Answer 4

If you are creating a web application, for example, via MVC, check the AttachDBFilename in web.config for characters such as |.

I had the same problem and could not fix it by deleting the connections from Server Explorer.

I hooked up a visual studio debugger to visual studios.

CLI exceptions are turned on, and only my code is turned off.

Then I saw a hidden exception.

The wizard threw an exception with the message " Invalid Character in Path " in System.IO.Path.CheckInvalidPathChars(string path, bool checkAdditional).

The path value is "|DataDirectory|\\aspnet-Mvs4Dummy1-20140402113853.mdf".

I realized that this was a database that visual studios automatically created with my MVC application and that the offensive character was probably the '|' character .

So, I searched for Grep in my directory and found that it was stored in my web.config in this apparently unsupported format.

I changed the entry to the full local path and the wizard stops disappearing.

Answer 5

Open VS, View-> Server Explorer and delete the connections in the data connection files. I already had this error, and I decided to do it as follows.

Answer 6

My solution for VS2015 was:

Install MySQL.NET Connector 6.9.8 to replace 6.9.5.

I already installed MySQL for Visual Studio 1.2.6 and got the appropriate MySQL NuGet packages (MySQL.Data, MySQL.Data.Entity.EF6, MySQL.Web).

Answer 7

I solved the problem by following these steps: 1 / Open the Server Explorer window in Visual Studio 2 / Delete all connections in the Data Connections sections 3 / Then add the ADO.net entity data model as usual