Hi Dynamicweb,
We have a solution with many order contexts and we experiende a lot of activity between Dynamicweb and the database. If the order id is not set it would be great not to try to get a nonexisting order.
DECLARE @OrderID NVARCHAR(4000) = N''
SELECT * FROM EcomOrders WHERE OrderID = @OrderID
Best regards, Anders