Create Mysql Stored Procedure using in vb .NET

How do I create a stored procedure for mysql using VB .NET programmatically?

EDIT:

Apologize to be so brief. I have tried using ExecuteNonQuery provided by MySQL .NET Connector. It prompts me error. Maybe it's because I put "Delimiter $$"?

I know I can create using script (batch file) if I want to send it to my client (as commented below). But my objective is to keep MySQL password safe. So script开发者_如何学C is not the way.

---

1. Connect to the database.
2. Run the create procedure SQL command using ExecuteNonQuery