Our production db is SQL Server, it’s a legacy system and makes heavy use of stored procedures. Until now we’ve been executing our unit tests against a local SQL Server db. We’d like use an in-memory db instead.
Once we switched the dialect to SqliteDialect we’ve run into a problem when calling SqlProc, it throws a NotSupportedException. I realise that SqlLite doesn’t support stored procedures, but I just want a way of stubbing them. I was hoping to use an ExecFilter for this, but it doesn’t get that far.
What is the recommend way of mocking sprocs in tests when using SqlProc?