在SQL Server存储图像使用C#

问题描述:

我要存储我的员工的图像与在SQL Server数据库SQL他们的个人资料的细节,但我有下列保留:

I want to store images of my employees with their profile details in SQL in a SQL Server database, but I have following reservations:

我应该融为一体preSS图像或没有,如果有,请能为社会各界提供样品我code或直接我可以帮助我这个指南。

Should I compress images or not and if yes, please can the community provide me sample code or direct me to a guide that can assist me with this.

我应该如何有效地检索图像?我怕asp.net应用程序性能问题。我认为,与成千上万的员工记录时,系统可能会停止或减慢。

How should I retrieve images efficiently? I am afraid of asp.net application performance issues. I think with thousands of employee records, the system may halt or slow down.

我会建议存储在SQL表中的图像的路径,实际上是图像存储在一个安全的文件夹中。这工作对我来说非常完美。

I would suggest storing the path of the images on your sql table, and actually store the image in a secure folder. This has worked for me perfectly.