How to Create MySQL Compact Database?

Question

I want to use MySQL like SQL Compact Edition! In other words, I want to create a local database (compact database file) by MySQL csharp drivers in from Connector/Net .

In my project we need first to install MySql.Data.dll in the GAC and my Data Source is a file path like: D:\MyDatabase\database.myd

Now my codes must be like this:

 using System;
 using System.Data;
 using MySql.Data.MySqlClient;

 public class Test
 {
    public static void Main(string[] args)
    {
       string strConnection = "CREATE DATABASE TestDatabase;";

       MySqlConnection conDatabase = new MySqlConnection("Data Source=D:\MyDatabase\database.myd;Persist Security Info=yes");

       MySqlCommand cmdDatabase = new MySqlCommand(strConnection, conDatabase);

       conDatabase.Open();
       cmdDatabase.ExecuteNonQuery();
       conDatabase.Close();
    }
 }

Can I do it ?

Why you don't use Sqlite? – Siamak Ferdos May 30 '15 at 10:53 — Siamak Ferdos, May 30 '15 at 10:53
I offer to use **Firebird** instead – Hamed Zakery Miab May 30 '15 at 10:55 — Hamed Zakery Miab, May 30 '15 at 10:55
Ok, I decide to use Sqlite! Thanks every one for answering – Behzad May 30 '15 at 11:06 — Behzad, May 30 '15 at 11:06

score 0 · Accepted Answer · edited Sep 21 '15 at 08:05

0

I did research on the internet and realized that MySQL can not be compact and I use Sqlite instead of MySQL.

Some compact databases:

Firebird
SQL Server CE
Sqlite

edited Sep 21 '15 at 08:05

marc_s

732,580
175
1,330
1,459

answered Jul 12 '15 at 17:44

Behzad

3,502
4
36
63

How to Create MySQL Compact Database?

1 Answers1