Does the TableAdapter have a Forward Only Read Access Object (like the DataReader)?
It seems the TableAdapter just works the best with the DataTable, which is great but it's disconnected. So if I need to run a huge query in SQL Server that will return huge amounts of data I could max out the DataTable because it has to load the entire result into the object before I can use it. I am just loading the data and outputting it to a text file (no data manipulation required) Is the TableAdapter not suited for this type of data?
Should I just forget about the TableAdapter for this use the DataReader?
It seems the TableAdapter just works the best with the DataTable, which is great but it's disconnected. So if I need to run a huge query in SQL Server that will return huge amounts of data I could max out the DataTable because it has to load the entire result into the object before I can use it. I am just loading the data and outputting it to a text file (no data manipulation required) Is the TableAdapter not suited for this type of data?
Should I just forget about the TableAdapter for this use the DataReader?