从SQL Server批量获取记录的最佳方法是什么

Scenario: we are fetching rows from SQL Server to C#.Net console application and doing action on the retrieved data from SQL Server through stored procedure; after the action is performed the new data is stored into the MongoDB using C#-MongoDB-Driver.: we are fetching rows from SQL Server