Hello,
I’m trying to create my NServiceBus endpoint using NServiceBus.Persistence.Sql ( it was previously using RavenDB Persistence. The problem is i have the need to use a custom saga finder and we are on SqlServer 2012 without built-in json query capabilities. How can i do this in an efficient way? I’m trying to replace the following query
public Task<MySagaData> FindBy(ILineItemCancelled message, SynchronizedStorageSession storageSession, ReadOnlyContextBag context)
{
return context.Get<SynchronizedStorageSession>().RavenSession().Query<MySagaData>()
.SingleOrDefaultAsync(x => x.LineItems.Any(guid => guid.Equals(message.LineItemId)));
}