By StarkMike - 3/14/2007
Lets say I have a text file full of names of stored procedures and I'd like to do a 'Find In Files' type search using this text file. How would I do this?
Is there any software out there that would do this?
Searching this way would save me from entering each stored procedure name one at a time in the IDE.
Thanks
|
By StrataFrame Team - 3/14/2007
If your list gets really big (say >10,000 sprocs or so), you'll want to go with a tool that is designed for searching within text. However, if it's small, you won't notice any lag if you use the methods on the System.IO.File class such as ReadAllLines() which will return a string array of all of the lines in the file, and if you're file is formatted right, each of the entries in the array will be a sproc name. Then, you can just do an Array.Contains() or even put them in a System.Collections.Generic.List<string> and use the Find() methods to search case-insensitively.
|
By StarkMike - 3/14/2007
Thanks! Do you know of a tool designed for this type of thing?
|
By StrataFrame Team - 3/14/2007
Hrm... not off the top of my head, sorry.
|
|