a Sample implementation of write SQL scripts using the task monitor


ICSSoft.Services.ChangesToSqlBTMonitor is a kind task monitor, which allows you to record SQL-scripts change the data.

the service Connection

To connect this service, you need in the configuration file to write:

    <add key="BusinessTaskMonitorType" value="ICSSoft.Services.ChangesToSqlBTMonitor, ChangesToSqlBTMonitor, Version=, Culture=neutral, PublicKeyToken=e5ad39f116a43e0b"/>

use of the service

Example handlers for menu items:

private void RecorderClearClick(object sender, EventArgs e)

private void RecorderSaveClick(object sender, EventArgs e)
	if (saveFileDialog.ShowDialog(this) == DialogResult.OK)
		string fileName = saveFileDialog.FileName;

		StreamWriter writer = new StreamWriter(fileName, false, Encoding.UTF8);

		// Have the writer write strings to the store. 


So in the output script to avoid unnecessary queries, you can configure a filter on the table names in the configuration file

    <add key="ChangesToSqlExcept" value="AuditSystem,STORMSETTINGS,Audiopiracy,Auditionee"/>