Reputation: 181
I want to save user profile picture to asp.net_profile table in Sqlserver, please help me how to do that?
thanks
Upvotes: 0
Views: 899
Reputation: 14438
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.
Upvotes: 1