CODEWITHSUNDEEP
c#databasescripting
srinivas
srinivas

Reputation: 1411

Running Database scripts in C#

How to run database scripts(MySql db scripts) in c#.

Thanks, sirni.

Upvotes: 1

Views: 2875

Answers (4)

Jim Schubert
Jim Schubert

Reputation: 20357

MySQL Connector for .NET:

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

Upvotes: 1

Oliver Friedrich
Oliver Friedrich

Reputation: 9240

You can connect to mysql with c# via odbc:

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

Upvotes: 1

Bill Karwin
Bill Karwin

Reputation: 562330

Fork a child process and execute the mysql command-line client, using the script as input.

It's tempting to try to read the script as a file and execute the SQL commands within it one by one, but there are numerous statements in an SQL script that can't be executed that way.

So you'd have to duplicate the code of the mysql client anyway in order to run an SQL script. Do yourself a favor and use the program that is already designed for that purpose.

Upvotes: 0

rslite
rslite

Reputation: 84683

You need to open a connection to the database then create a command object and use the ExecuteNonQuery method (if you don't expect any result) or one of the other Execute... commands. Set the CommandText of the command object to the content of the script to execute.

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

Upvotes: 1

Related Questions