0

I want to save user profile picture to asp.net_profile table in Sqlserver, please help me how to do that?

thanks

ZKF3340320
  • 171
  • 2
  • 9

1 Answers1

1

You shouldn't save images directly to the database, it's bad for performance and will eat up a lot of space. Instead, save it to a filesystem or cloud storage (S3, Azure Blob Storage) and store a reference/url to the image inside the profile.

You can then leverage something like a CDN to serve up the picture, and save a great deal on bandwidth.

See this discussion for more in depth reasons.

Community
  • 1
  • 1
mfanto
  • 14,168
  • 6
  • 51
  • 61
  • I accept your suggestion, but i have only 3-4 user profile pictures to store in DB please let me know how to do that to store in Asp.net Membership (aspnet_Profile) table? – ZKF3340320 Mar 12 '14 at 18:48
  • Actually, there is a field name PropertyValueBinary with data time Image in Aspnet_profile table, i want to save my userprofile picture there. – ZKF3340320 Mar 12 '14 at 18:58