How to save an image in a database?

Question

I am working on Linq To Sql, WPF, and I have a database, now I need to save some image in the database, but I do not know what the correct data type is for saving the image database (this database will connect from 10 users at the same time ) Can you show me the right way to overcome this step? If I’m not mistaken, don’t save photos in the database, but if you can advise me on the best method, I will apply it. Thanks so much for your time.

Yours faithfully

Answer 1

'varbinary (MAX)' 'image'. Linq2Sql , . [].

myObject.Image = new Binary(imageByteArray);

Answer 2

blob, , , , byte []. , .

Answer 3

varbinary (max) , max- , [] .

Answer 4

, , , , .

, SQL-, , db. , .

, .

:

- :

public partial class LinqClass
{
    public string ImagePath { get; set; }

    public System.Drawing.Image Picture
    {
        get
        {
            return System.Drawing.Image.FromFile(ImagePath);
        }
    }
}

ImagePath - db, . (- File.Save(ImagePath) .., .

Answer 5

I never did this with Linq, but we used the b64 conversion for the image and then the clob data type. Then change the b64 value when you want to view the image.