How can i run sql server script with c#?

Question

I'm write this code for run sql server script:

string sqlConnectionString = "Data Source=.;Initial Catalog=behzad;Integrated Security=True";
//string sqlConnectionString = "Data Source=(local);Initial Catalog=AdventureWorks;Integrated Security=True";
FileInfo file = new FileInfo("d:\\behzadBULK.sql");
string script = file.OpenText().ReadToEnd();
SqlConnection conn = new SqlConnection(sqlConnectionString);
Microsoft.SqlServer.Server server = new Microsoft.SqlServer.Server(new ServerConnection(conn));
server.ConnectionContext.ExecuteNonQuery(script);

but this line :

Microsoft.SqlServer.Server server = new Microsoft.SqlServer.Server(new ServerConnection(conn));

i get this error:

 Are you missing reference?

what reference should be add to the project?

Just install the reference to Microsoft.SqlServer.Server in your project, if its not present now. And add a namespace for it in your code this should do it — Dhrumil
– Dhrumil, Commented May 23, 2015 at 6:02

Dhrumil · Accepted Answer · 2015-05-23 06:20:10Z

3

Your problem here is that a reference to the assembly Microsoft.SqlServer.Server is missing and that's why that error is popping up.

You can resolve it by just adding a reference to your project for that particular assembly by right clicking your project and clicking on add reference. That should open a window to show you all the assemblies available and from there you can choose this assembly and add it to your project.

After that, make sure you have added the namespace for it in your code and that should do it.

Hope this helps.

answered May 23, 2015 at 6:20

Dhrumil

3,2126 gold badges24 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

John Saunders · Accepted Answer · 2015-05-23 06:45:16Z

3

Try Using SQLclient Connection Not SqlServer

using System.Data;
using System.Data.SqlClient;

and Some code like this

settings = System.Configuration.ConfigurationManager.ConnectionStrings["MyTweetConnection"];
ConnectionString = settings.ConnectionString;
SQLCon = new SqlConnection(ConnectionString);

edited May 23, 2015 at 6:45

John Saunders

162k26 gold badges252 silver badges403 bronze badges

answered May 23, 2015 at 6:22

Milaaaad

3176 silver badges13 bronze badges

Collectives™ on Stack Overflow

How can i run sql server script with c#?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related