How do i read and Execute a bunch of .Sql at the same time using C#
C#
2
Posts
2
Posters
0
Views
1
Watching
-
Dear All, How do i read and Execute a bunch of .Sql at the same time using C# Send me sample code for that GreatRegards, Sivakumar Lakshmanan.
I am not sure what exactly you are trying to do with the .Sql but may I suggest that you look at the Database Application Block from Microsoft. The Application Block abstracts much of the database work into a series of static methods that are very useful. Not withstanding the application block I would suggest that you explore the Data namespace and use the SqlCommand object. You will have to set the commandtext then execute the command. As a side note I would strongly suggest that you use stored procedures if you have a "bunch" of scripts to run. Hope it helps