Comment Feed for Storing in Database problem (TechOff on Channel 9)

Re: Storing in Database problem

littleguru — Sat, 04 Nov 2006 17:30:38 GMT

I tried this and it worked without problems.

[Serializable]
public class Foo
{
private int _prop1;
private string _prop2;

    public string Prop2
    {
        get { return _prop2; }
        set { _prop2 = value; }
    }

    public int Prop1
    {
        get { return _prop1; }
        set { _prop1 = value; }
    }
}

class Program
{
    static void Main(string[] args)
    {
        Foo f = new Foo();
        f.Prop1 = 1;
        f.Prop2 = "test";

        MemoryStream stream = new MemoryStream();
        BinaryFormatter formatter = new BinaryFormatter();
        formatter.Serialize(stream, f);

// Holds the result of the serialization.
byte[] bytes = stream.ToArray();

        // Deserialize the bytes array.
        f = (Foo)formatter.Deserialize(new MemoryStream(bytes));
    }
}

Re: Storing in Database problem

littleguru — Sat, 04 Nov 2006 17:23:50 GMT

You should post a little bit of your code :) Makes it easier to understand what you actually trying to do.

Re: Storing in Database problem

Shmuelpro — Sat, 04 Nov 2006 17:13:50 GMT

No i am serializing it using the Binary formatter.
I might not have explained myself correctly.
what i am basicly trying to do is turn my class into a series of bytes inorder for them to be stored in the database.

The Memory stream NEEDS the bytes so i am kinda in a pickle.

Thanks for the quick reply

Re: Storing in Database problem

littleguru — Sat, 04 Nov 2006 16:39:20 GMT

I'm guessing that you are using XmlSerializer to serialize the class. You could a MemoryStream as the stream where to store the XML to. You could use that MemoryStream then to store the bytes to the database :)

I hope this helps.