Send email with ASP.net application or MS SQL Server ?

Hello,

I'm building an application with asp.net. And I need to send emails to selected customers.

What is the best way to send email ? Is it by using System.Net Class or to send it by using MS Sql Server ?


Thank you
Paul

I'd use System.Net.Mail instead of SQL Server to send emails

I do both...

I made a CLR function that uses System.Net.Mail to send mail.
So when writing a query like "select sendemail(email) from my_table" will actually send email to everyone in the table  LOL

Hello,

System.Net.Mail would be my choice as well. You can find lots of information about this here:

http://www.systemnetmail.com/

Bear in mind, classes within this namespace assume that you already have an SMTP Server that you can relay messages through.

Gary