SQL PLUS COMMAN .SQL FILE .NET

hoffmandirt

I have a lot of *.sql files that have sql scripts in them. Some of these files are consisting of scripts that call other sql files using the @filename option. I am using oracle and the files are made to be run in SQL Plus(the @filename). I am wondering if there is a way in .NET to use these files. As of right now I am reading the files and executing them query by query using the semi colon as a delimter. So really I am looking for a way that .net can use the @filename option to load sql files. All help appreciated.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

hoffmandirt22y ago
I know how to read files and add files. I am curious if there is a way to use the commands in .NET that you can use in SQL PLus like the @ symbol to load files.
p.jones22y ago
I think in visual studio project->add you can pull in files to the project but from their i do not know how you would use them.