Error in DELIMITER while Executing procedure.sql

[gautamksr]

Hi,

I have tried with all possible syntax for DELIMITER // , DELIMITER $$ and DELIMITER ;
But there is error throw while execute the stored procedure.sql (which has many procedure). could any one help me to shorted out this issues

Details of error:

Error running MySQL scripts: Exception calling "Fill" with "1" argument(s): "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DELIMITER //
CREATE PROCEDURE test ()
BEGIN
select * from organisation;
' at line 1"

[zivillian]

I hit the same bug. After some research, I found that DELIMITER ist not an SQL command, but is interpreted by the mysql command line client to split the query text in statements.
The mysql .net library contains a MySqlScript class, which uses a tokenizer to split the query and also respects the DELIMITER.

[gautamksr]

Thanks zivillian. can i have this changes?

[zivillian]

My changes are available in #5