Database support

From MonoDevelop

Installation

as of monodevelop beta 1, the database support is added in the main repository, to enabled it, add the "--enable-database" flag when running "./configure"

[edit]

Database specific features

Sqlite (Mono.Data.Sqlite)

the Create table command is implemented, but disabled by default due to a bug in the sqlite database provider (https://bugzilla.novell.com/show_bug.cgi?id=324934), the feature will be enabled by default when the bugfix hits a mainstream mono version (probably mono 1.2.5.1 or 1.2.6)

Supported operations:

  Create: database, view
  Alter: view
  Rename: table
  Drop: database, table, view

MySql (MySql.Data)

Supported operations:

  Create: database, table, view, procedure, trigger
  Alter: view, procedure
  Rename: database, table, view
  Drop: database, table, view, procedure, trigger

PostgreSQL (Npgsql)

the npgsql provider distributed with mono 1.2.4 lacks supports for GetSchema ("Datatypes"), this breaks the Create Table feature

Supported operations:

  Create: database, view, trigger
  Alter: database, view, trigger
  Rename: database, table, view, trigger
  Drop: database, table, view, trigger

Sql Server (System.Data.SqlClient) (not yet tested)

Supported operations:

  Create: database, table, view, procedure, trigger
  Alter: database, view, procedure, trigger
  Rename: database, table, view, procedure, trigger
  Drop: database, table, view, procedure, trigger

[edit]