你将如何实现通过电子邮件数据库的更新？ [英] How would you implement database updates via email?

问题描述

我要建一个公共网站拥有自己的域名，POP / SMTP邮件服务。我正在考虑让用户通过电子邮件更新其数据的选项 - 类似于在你的电子邮件职位，以一种特殊的电子邮件地址，Flickr或博客中的功能的东西。然后将电子邮件数据被处理并存储在用于网站底层数据库

I'm building a public website which has its own domain name with pop/smtp mail services. I'm considering giving users the option to update their data via email - something similar to the functionality found in Flickr or Blogger where you email posts to a special email address. The email data is then processed and stored in the underlying database for the website.

我使用ASP.NET和SQL Server，并使用一个共享的托管服务。任何想法怎么一会实现这一点，或者如果它使用共享的主机甚至有可能？

I'm using ASP.NET and SQL Server and using a shared hosting service. Any ideas how one would implement this, or if it's even possible using shared hosting?

感谢

推荐答案

有关，你需要有托管首发允许你创建一个catch-all邮箱。

For starters you need to have hosting that allows you to create a catch-all mailbox.

其次，你需要一个好的POP3或IMAP库，这是不是在.NET堆栈AFAIK包括在内。

Secondly you need a good POP3 or IMAP library, which is not included AFAIK in the .NET stack.

然后，你会写一个命令行应用程序或定期检查邮箱，翻出消息的服务，插入根据数据库内容的收件人地址（这是唯一为每个用户），然后从删除的电子邮件邮箱。

Then you would write a Command Line application or a Service that regularly checks the mailbox, pulls messages, inserts content in db based on the "To" address (which is unique for each user), and then deletes the email from the mailbox.

这是可行的，听起来很有趣。只要确保你有你开始之前，你需要的！

It's feasible and sounds like fun. Just make sure you have all you need before you start!

这篇关于你将如何实现通过电子邮件数据库的更新？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！