Microsoft SQL Server

Frends.MicrosoftSQL.ExecuteQueryToFile / 2.4.0

Summary

Streams a query's results straight into a file, so the rows never accumulate in the Process's memory, and reports how many were written.

Typical use — extracts too large to hold in memory, where the plain query Task would exhaust the agent

Details

Frends version
5.5 and newer
Agent
Crossplatform
Target framework
net6.0
2.4.02026-09-07
Added
  • Added JSON output support to the ExecuteQueryToFile method, allowing SQL query results to be streamed directly to a JSON file.
2.3.02026-01-30
Fixed
  • Fixed an issue that was causing problems with Frends processes' cleanup and assembly unloading.
2.2.02026-01-22
Changed
  • Improve execution of async methods.
2.1.02024-12-16
Added
  • Added Microsoft.SqlServer.Types dependency so that SqlGeography and SqlGeometry typed objects can be handled.
2.0.02024-08-05
Changed
  • Breaking The task now uses Microsoft.Data.SqlClient instead of System.Data.SqlClient.
1.0.12024-02-12
Fixed
  • Fixed handling of null query parameters by changing the parameter value to DBNull.Value.
1.0.02024-02-07
Changed
  • Initial implementation
An unhandled error has occurred. Reload 🗙