Using a Script with variables

[Zero-G.]

Hey

I am using dotConnect for mySQL (latest v5.8 Version) with VB.NET

I use the script component to make some changes to the database.
The script is an embedded file in my project.
Is it anyhow possible to use variables in the script?

For example. My script includes changes on a Trigger. - Therefor I have to use the "user" like Definer 'user'%'@'

Instead of user, there should stay the user, which is executing the script.

Hope you understand, what I mean. - Thanks for your tips
Yours faithfully

[Shalex]

Please execute statements with parameters using the MySqlCommand class, because MySqlScript doesn't support parameters.