private static void AddEventSource(IEventSource eventSource, SqlTransaction transaction)
{
using (var command = new SqlCommand(InsertNewProviderQuery, transaction.Connection))
{
command.Transaction = transaction;
command.Parameters.AddWithValue("Id", eventSource.EventSourceId);
command.Parameters.AddWithValue("Type", eventSource.GetType().ToString());
command.Parameters.AddWithValue("Version", eventSource.Version);
command.ExecuteNonQuery();
}
}