Asp.net mvc creates a csv file in memory without creating a physical file and sending email as an attachment

Question

I am working on developing asp.net mvc web applications where I need to create a CSV file in memory and send as an email attachment.

I reviewed this solution below: Exporting a C # list to a Csv file

Unfortunately, this solution returns the result of the file and does not meet my requirement.

Any help would be greatly appreciated.