Test.cs

using Projac;
using Projac.Testing;
using Projac.Testing.NUnit;
using NUnit.Framework;

[TestFixture]
public class PortfolioProjectionTests
{
    [Test]
    public void PhotoCountIsDecrementedWhenPhotoIsRemoved() 
    {
        new Scenario(Projections.Portfolio).
          Given(PortfolioAdded()).
          Given(PortfolioRenamed()).
          Given(PhotoAddedToPortfolio()).
          Given(PhotoAddedToPortfolio()).
          When(PhotoRemovedFromPortfolio()).
          ExpectNonEmptyResultSet(
            TSql.Query("SELECT * FROM [Portfolio] WHERE [Id] = {0} AND [PhotoCount] = {1}", 
                       TSql.Int(PortfolioId), 
                       TSql.Int(1))).
          Assert();
    }
}