We help IT Professionals succeed at work.
Get Started

How do I execute several lines of SQL commands using C#?

Epitel0920
Epitel0920 asked
on
1,200 Views
Last Modified: 2011-09-20
Hello,
  I would like to execute several lines of SQL commands through the C# program. I have the complete text of the commands stored in a string s. However I can not just use:
SqlCommand command = connection.CreateCommand();
command.CommandText = s;
command.ExecuteNonQuery();
since the command text contains several "GO" statements and these statements have to be executed in order. Hence one statement have to finish executing before the other one starts.
One way is to break up s into several statements using "GO" as a delimeter... however that seems painful, especially since "GO" can be followed by "\n" for ex, or "GO" can be part of the variable name.
Is there any better build in way to do this?
Thank you
Peter
Comment
Watch Question
Billing Engineer
CERTIFIED EXPERT
Most Valuable Expert 2014
Top Expert 2009
Commented:
This problem has been solved!
Unlock 1 Answer and 4 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE