Creating a file from a stringbuilder
StreamWriter uses an underlying instance of the StringBuilder object.
But in my application i am iterating through a collection of data coming from the data base with a foreach loop and creating the contents of my file. Some times i need to do conditional logic on the data fields before writing them to the string so i decided to do a string builder and then at the end of the each loop in the for write a CRLF to the string. When i have completed processing each row of the data collection i then do a single write with the streamwriter to write to the file.
I was wondering if i would have any performance issues if i decided to not use a StringBuilder to build the entire contents of the file and just used sw.writeline for every loop.
This file is not being accessed till it is completed and even then it is sent via ftp only after it is completed.
So by creating a stringbuilder object am i in fact overdoing it?

