saga-finder.md

title	component	related	reviewed	versions
Saga Finder	SqlPersistence	samples/saga/sql-sagafinder	2024-09-13	[2,)

The SQL Persistence exposes an API to enable the creation of Saga Finders.

Usage

The API is exposed as an extension method on SynchronizedStorageSession and can be called as follows:

Microsoft SQL Server

include: sql-saga-finder-warning

snippet: SagaFinder-sqlServer

MySql

snippet: SagaFinder-MySql

partial: postgresql

Parameters

context

Used to ensure the concurrency metadata is stored in the current session.

whereClause

This text will be appended to a standard Saga select statement:

snippet: MsSqlServer_SagaSelectSql

appendParameters

appendParameters allows DbParameters to be appended to the underlying DbCommand that will perform the query.

builder: calls through to DbCommand.CreateParameter to allow construction on a DbParameter.

append: calls through to DbParameterCollection.Add to add the parameter to the underlying DbCommand.

IContainSagaData Construction

Converting the returned information into an IContainSagaData will then be performed by the SQL Persister.

See also SQL Persistence Saga Finder Sample.