Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 882
  • Last Modified:

Do we need 'commit' statement to run sql queries using C#?

Hi,
I am writing a program to read a sql file containing multiple queries and executing it in my C# program.
I wanted to know what would be the best way of doing this. I am currently separating queries using semi colon and then executing them using Execute.NonQuery();

I also wanted to confirm if i need to commit these queries separately since it seems to be doing it itself.

Thanks
0
ravi424
Asked:
ravi424
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
no commit needed, unless you started a explicit transaction.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now