Running database scripts in C #

Question

How to run database scripts (mysql db scripts) in C #.

Thanks, sirni.

Answer 1

Run the child process and execute the command line client mysqlusing the script input.

The puzzle is to try to read the script as a file and execute the SQL commands inside it one by one, but there are many statements in the SQL script that cannot be executed this way.

Thus, you will need to duplicate the mysql client code anyway in order to run the SQL script. Do yourself a favor and use a program that is already designed for this purpose.

Answer 2

, ExecuteNonQuery ( - ) Execute.... CommandText script .

: http://database-programming.suite101.com/article.cfm/how_to_add_records_to_mysql_with_c

Answer 3

mysql # odbc:

http://dev.mysql.com/doc/refman/5.0/fr/odbc-net-op-c-sharp-cp.html

Answer 4

MySQL .NET:

http://dev.mysql.com/downloads/connector/net/