how to write test cases for repositories method that was connected to sql server using dapper.

sai krishna - Aug 29 - - Dev Community

public async Task> ListAsync(AssetCategory category, CancellationToken cancellationToken = default)
{
var parameters = new DynamicParameters();
parameters.Add("@category", category);

return await _context.Connection.QueryAsync<Tag>(
   _databaseSettings.StoredProcedures.TagCategoryListRead,
   param: parameters,
   commandType: CommandType.StoredProcedure,
   transaction: _context.Transaction
   );
Enter fullscreen mode Exit fullscreen mode

}

System.NotSupportedException : Unsupported expression: conn => conn.QueryAsync(It.IsAny(), It.IsAny(), null, null, (CommandType?)CommandType.StoredProcedure)
Extension methods (here: SqlMapper.QueryAsync) may not be used in setup / verification expressions.

.
Terabox Video Player