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

[paulnamroud]

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

[x-ice]

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

[CVMichael]

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

[gep13]

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