Unable to moq dapper when using storedprocedure in c# ?

[ankurjasoria]

Hi All.

I am currently using Dapper in my .net application but unable to make Unit Test for Dapper when I am currently using stored procedure not inline queries.

Please help me for same.

[darthmolen]

Works fine for me:

conn.SetupDapper(c => c.Query<BusinessObj>(It.IsAny(), new { Account = It.IsAny() }, null, false, null, CommandType.StoredProcedure)).Returns(new BusinessObj[] { obj });

However, you can't use something like c.QueryFirst as it will give a "not supported" error message.

[ricochetbrown]

@ankurjasoria you can use stored procedures with this just fine. You can do something like this:

connection.SetupDapperAsync(c => c.QueryAsync<T>( It.IsAny<string>(), new DynamicParameters(), null, null, CommandType.StoredProcedure )).ReturnsAsync(expected);

@darthmolen every dapper function isn't in this library yet. QueryFirst is one that isn't.

[UnoSD]

@ankurjasoria can you show us some code? does what @darthmolen and @ricochetbrown work for you?