Execute the sql server script using nonexecutequery

Question

0.00/5 (No votes)

See more:

Hi,

I have one SQL server script file. I want to execute this script file through C#.

I used the following code.

C#

SqlConnection conn = new SqlConnection();
                conn = new SqlConnection(SQLConnection);
                Server server = new Server(new ServerConnection("ConnectionString"));
                server.ConnectionContext.ExecuteNonQuery(Script);

For this I loaded the dll from "C:\\ProgramFiles\\MicrosoftSqlServer\\100\\SDK\\Asseblies".

But I am getting error like mixed mode .net version 'v2.0.02527' to .net version 'v4.0'.

So how to execute the script file using ExecuteNonQuery or some other way?

Please help me

Thank you

Posted 25-Nov-11 4:10am

Member 7684075

Updated 25-Nov-11 4:12am

RaisKazi

v2

Add a Solution

Comments

Timberbird 25-Nov-11 10:35am

Why loading the DLL manually? Try to demove it from project and add standard Systed.Data assembly (from the "Add Reference" dialog, ".NET" tab)

Member 7684075 26-Nov-11 7:28am

The Server and ServerConnection class i am using Microsoft.Management.Common. The normat Syste.Data dont have Server and ServerConnection class. That is the reason i added the dll from C:\\ProgramFiles\\MicrosoftSqlServer\\100\\SDK\\Asseblies. I am find this reference from .net tab.

And one more thing this is i am using in windows application. So if i execute this page it will work fine.

The same form i ll include with installer (web setup project installer). When installer is starting i ll call windows application. This situation only not working.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Mehdi Gholam · Answer 1 · 2011-11-25T04:44:00

Solution 1

SqlConnection are built into .net so all you need is the System.Data reference in your project.

You do not need to reference SQL specific assemblies.

Posted 25-Nov-11 4:44am

Mehdi Gholam

Rob Philpott · Answer 2 · 2011-11-25T04:48:00

Few things here. Firstly as Timerbird says, that's not the way to add a reference. Just add System.Data from .NET in references. If you're using .NET4 make sure your not using the Client Profile, as that probably won't have it. Doesn't seem to have anything of any use.

I don't believe you can run a whole script as a single command like that. A script is usually a sequence of commands individually invoked by the keyword 'go'. Think you'll have issues if running multiple commands. Either shell out to osql to do it, or split the script on gos and submit each command individually.

EDIT: Yes, as pointed out above, you don't need to add any reference thinking about it. It's already there....