使用MysqlScript,创建mysql存储过程代码如下:
public void AddProceduce()
{
using (var Conn = new MySqlConnection(connectMysql))
{
try
{
Conn.Open();
Console.WriteLine("Connecting to MySQL...");
string sql = "DROP PROCEDURE IF EXISTS GetAllCompany??" +
"CREATE PROCEDURE GetAllCompany() " +
"BEGIN " +
"SELECT id FROM company;" +
"END??" +
"CALL GetAllCompany()";
MySqlScript script = new MySqlScript(Conn);
script.Query = sql;
script.Delimiter = "??";
int count = scri