String.Split or Regex

[=?ISO-8859-15?Q?C=E9dric?=]

Hi all,

I want to import a SQL script (SQLite) executing each queries separately.
- I read the SQL file
- I split the read string with the separator ";"
- I execute each query

string query = File.ReadAllText("C:\\script.sql");
string[] str = query.Split(';');
for (int i = 0; i < str.Length; i++) {
try {
SQLiteCommand cmd = mDbConnect.CreateCommand();
cmd.CommandText = str[i];
if (cmd.CommandText != string.Empty)
cmd.ExecuteNonQuery();
}
catch (Exception ex) {
Console.WriteLine(str[i] + ex.ToString());
}
}
 

BUT

In the SQL script, the ";" ends not systematically a query. A sample
(two ";" for one query):

CREATE TRIGGER agent_commune
BEFORE INSERT ON agent
FOR EACH ROW BEGIN
SELECT RAISE(ABORT, 'Impossible de trouver l''enregistrement lié')
WHERE (SELECT Num FROM Commune WHERE Num = NEW.Localite) IS NULL;
END;
 

I've tried using Regex with the following code but it seems wrong.

string[] str = Regex.Split(query, "[^(END;)?];");
 

Someone can help me?

Regards.

Cédric.