I am currently testing an application which is developed using C#. The application connects to DB to fetch email and few other informations. Then it puts that fetched informations to an Excel file and send that excel file to fetched email IDs using SMTP server.
Now, I would like to automate negative scenario by mocking data retirval and SMTP server (if possible).
Can you help me with list of libraries which can help me execute an application in isolated environment so that I can mock inputs?