c# code creating accessor methods

Question

Just starting a project for a course I'm doing and to get data for the database we must create our accessor methods which I found fine but I must create these for pictures that are blobs in my database anyone know how to best do this?

these are what I have so far and the way our lecturer wants them...

namespace ClassLibrary
{
    class Advert
    {
        public String Name
        {
            get { return Name; }
            set { Name = value; }
        }

        public String Genre
        {
            get { return Genre; }
            set { Genre = value; }
        }

        public String Console
        {
            get { return Console; }
            set { Console = value; }
        }

        public String Description
        {
            get { return Description; }
            set { Description = value; }
        }

        public double Price
        {
            get { return Price; }
            set { Price = value; }
        }
    }
}

How about a byte[]? Then convert it to an image in code... Essentially what a blob is is a byte[]. — Sani Huttunen
– Sani Huttunen, Commented Nov 22, 2014 at 22:27
This is not going towork. All your properties use the same property as their backing fields. You will get a stack overflow... — Sjips
– Sjips, Commented Nov 22, 2014 at 22:29
...but for images, you can use the Bitmap type. When reading and writing to the database, you could use a memory stream. The buffer property of memory stream is an array of byte. — Sjips
– Sjips, Commented Nov 22, 2014 at 22:32

Sani Huttunen · Accepted Answer · 2014-11-22 22:31:52Z

2

Essentially what a blob is is a byte[]:

namespace ClassLibrary {
  public class Advert
  {
    public String Name { get; set; }
    public String Genre { get; set; }
    public String Console { get; set; }
    public String Description { get; set; }
    public double Price { get; set; }
    public byte[] MyImage { get; set; }
  }
}

answered Nov 22, 2014 at 22:31

Sani Huttunen

24.4k7 gold badges78 silver badges82 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user3433399 Over a year ago

thanks i was actually looking at that but since this is the first time i was using images in a database i had to ask before i got down to the hard stuff and was totally wrong so thanks for your help

Sjips Over a year ago

this link: stackoverflow.com/questions/7350679/… might help you with conversion of bitmap to/from byte[].

Collectives™ on Stack Overflow

c# code creating accessor methods

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related