DbConnection执行多个SQL脚本.

问题描述

我想使用DbConnection执行长的SQL脚本(通常来自文件).这些脚本可能包含多个INSERT，UPDATE，CREATE语句.数据库可能会有所不同.这就是为什么我使用DbConnection.有可能吗?

谢谢.

Hi,

I want to execute long SQL scripts (usually coming from files) using DbConnection. The scripts may contain multiple INSERT, UPDATE, CREATE statements. The database may vary. That''s why I''m using DbConnection. Is it possible?

Thanks.

推荐答案

 string sqlConnectionString = @"Integrated Security=true Info=False;Initial Catalog=mydb;Data Source=SUMMAT";

FileInfo file = new FileInfo(@"C\Script.sql");

 string script = file.OpenText().ReadToEnd();

 SqlConnection conn = new SqlConnection(sqlConnectionString);

 Server server = new Server(new ServerConnection(conn));

 server.ConnectionContext.ExecuteNonQuery(script);
 file.OpenText().Close();

这篇关于DbConnection执行多个SQL脚本.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！