Support for delimiter statement

[sl2man]

Is there any way to execute statements that require changing of default delimiter? For example, how to execute script that creates function that uses ";" in it's code?
Simple usage of MySqlCommand with text like "delimiter $$" throws an exception.

[bgrainger]

DELIMITER $$ is unnecessary with MySqlConnector because it doesn't try to break SQL strings into individual statements and execute them separately. That directive is only for clients who need to parse SQL in a naive way.

It should "just work" to create a MySqlCommand with your entire script and then call ExecuteNonQuery(). For example, see the tests here, that demonstrate creating a function that contains ; in the code:

MySqlConnector/tests/SideBySide/StoredProcedureFixture.cs

Lines 17 to 24 in ffb45f3

	Connection.Execute(@"DROP FUNCTION IF EXISTS failing_function;
	CREATE FUNCTION failing_function()
	RETURNS INT
	BEGIN
	DECLARE v1 INT;
	SELECT c1 FROM table_that_does_not_exist INTO v1;
	RETURN v1;
	END");

(That uses Execute from Dapper but the principle is the same.)

[LeonardoDaLuz]

Yes, it is necessary, if I want to run a .sql to assemble the entire schema I can't.

[bgrainger]

It should "just work" to create a MySqlCommand with your entire script and then call ExecuteNonQuery().

Can you use this recommendation from the comment above?