Nesneleri Veritabanında Saklamak (Generic List To Database)

CREATE TABLE [dbo].[Sepetler](
	[SepetID] [int] IDENTITY(1,1) NOT NULL,
	[SepeteEkleyenID] [int] NULL,
	[SepetTarihi] [datetime] NULL,
	[SepetListesi] [varbinary](max) NULL,
 CONSTRAINT [PK_TSepetler] PRIMARY KEY CLUSTERED ([SepetID] ASC)
)

public class Sepetler
{
    public int Adet { get; set; }
    public Urunler Urun { get; set; }
}

public class Urunler
{
    public int UrunID { get; set; }
    public string Urun { get; set; }
    public string Resim { get; set; }
}

Create Procedure [dbo].[GetSepetler]
	@paramsepeteekleyenid int
As
Select * From TSepetler Where SepeteEkleyenID=@paramsepeteekleyenid

SqlCommand cmd = new SqlCommand("GetSepetler", veritabani_islemleri.Baglanti);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.Add(new SqlParameter("@paramsepeteekleyenid", SepeteEkleyenId));
        cmd.Connection.Open();
        SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
        List<Sepetler> SepetListesi = new List<Sepetler>();
        while (dr.Read())
        {
            byte[] buf = (byte[])dr["SepetListesi"];
            MemoryStream memStream = new MemoryStream(buf);
            BinaryFormatter b = new BinaryFormatter();
            memStream.Position = 0;
            SepetListesi = (List<Sepetler>)b.Deserialize(memStream);            
        }
        dr.Close();

Create Procedure [dbo].[SetSepetler]
	@paramsepetlistesi varbinary(MAX),
	@paramsepeteekleyenid int	
As

	Insert Into TSepetler(SepetListesi,SepeteEkleyenID) Values (@paramsepetlistesi,@paramsepeteekleyenid)

public static int InsertSepet(List<Sepetler> SepetListesi, int SepeteEkleyenId)
    {
        SqlCommand cmd = new SqlCommand("SetSepetler", veritabani_islemleri.Baglanti);
        cmd.CommandType = CommandType.StoredProcedure;
        //SepetListesini Serialize Ediyoruz.

        MemoryStream memStream = new MemoryStream();
        BinaryFormatter bf = new BinaryFormatter();
        bf.Serialize(memStream, SepetListesi);

        cmd.Parameters.Add(new SqlParameter("@paramsepetlistesi", SqlDbType.VarBinary, Int32.MaxValue));
        cmd.Parameters["@paramsepetlistesi"].Value = memStream.GetBuffer();
        cmd.Parameters.Add(new SqlParameter("@paramsepeteekleyenid", SepeteEkleyenId));
        cmd.Connection.Open();
        int i = cmd.ExecuteNonQuery();
        cmd.Connection.Close();
        return i;
    }

MemoryStream memStream = new MemoryStream();
        BinaryFormatter bf = new BinaryFormatter();
        bf.Serialize(memStream, SepetListesi);

        cmd.Parameters.Add(new SqlParameter("@paramsepetlistesi", SqlDbType.VarBinary, Int32.MaxValue));
        cmd.Parameters["@paramsepetlistesi"].Value = memStream.GetBuffer();

byte[] buf = (byte[])dr["SepetListesi"];
            MemoryStream memStream = new MemoryStream(buf);
            BinaryFormatter bf = new BinaryFormatter();
            memStream.Position = 0;
            SepetListesi = (List<Sepetler>)bf.Deserialize(memStream);