Поддерживает ли Visual Studio Server Explorer настраиваемые поставщики баз данных?

Обозреватель сервера должен поддерживать любую систему баз данных, которая предоставляет драйвер ODBC. В случае Oracle есть встроенный драйвер с Visual Studio.

В диалоговом окне добавления подключения нажмите кнопку изменения в источнике данных, после чего вы должны получить список поставщиков, для которых у вас есть драйверы.

Вот инструкции, как подключиться к базе данных MySQL из Visual Studio:

To make the connection in server explorer you need to do the following:

• first of all you need to install the MyODBC connector 3.51 (or latest) on the development machine (NB. you can find this at http://www.mysql.com/products/connector/odbc/ )

• Create a datasource in Control Panel/Administrative Tools with a connection to your database. This data source is going to be used purely for Server Manager and you dont need to worry about creating the same data source on your clients PC when you have made your VS.NET application (Unless you want to) - I dont want to cover this in this answer, too long. For the purpose of this explanation I will pretend that you created a MyODBC data source called 'AADSN' to database 'noddy' on mysqlserver 'SERVER01' and have a root password of 'fred'. The server can be either the Computer Name (found in Control Panel/System/Computer Name), or alternatively it can be the IP Address. NB. Make sure that you test this connection before continuing with this explanation.

• open your VS.NET project

• go to server explorer

• right-click on 'Data Connections'

• select 'Add Connection'

• In DataLink Properties, go to the provider tab and select "Microsoft OLE DB Provider For ODBC drivers"

• Click Next

• If you previously created an ODBC data source then you could just select that. The disadvantage of this is that when you install your project application on the client machine, the same data source needs to be there. I prefer to use a connection string. This should look something like:

DSN=AADSN;DESC=MySQL ODBC 3.51 Driver DSN;DATABASE=noddy;SERVER=SERVER01;UID=root;PASSWORD=fred;PORT=3306;SOCKET=;OPTION=11;STMT=;

If you omit the password from the connection string then you must make sure that the datasource you created (AADSN) contains a password. I am not going to describe what these mean, you can look in the documentation for myodbc for that, just ensure that you get a "Connection Succeeded" message when you test the datasource.

Я обнаружил это во время исследования Sqlite. Однако у меня не было возможности использовать его. Сообщите нам, работает ли это для вас.

http://sqlite.phxsoftware.com/

System.Data.SQLite System.Data.SQLite is the original SQLite database engine and a complete ADO.NET 2.0 provider all rolled into a single mixed mode assembly.

...

Visual Studio 2005/2008 Design-Time Support

You can add a SQLite connection to the Server Explorer, create queries with the query designer, drag-and-drop tables onto a Typed DataSet and more!

SQLite's designer works on full editions of Visual Studio 2005/2008, including VS2005 Express Editions.

NEW You can create/edit views, tables, indexes, foreign keys, constraints and triggers interactively within the Visual Studio Server Explorer!

Oracle имеет набор инструментов, который интегрируется с Visual Studio. Он упакован с их библиотеками доступа к данным.

http://www.oracle.com/technology/software/tech/windows/odpnet/index.html