how to mark as serializable in dbml?

Question

I need Linq & Serializable, so i use autogenerate dbml and add Seriable. I only need the "Dvd table" being Serializable, however there is <

Tried many combines, still fail for the error:

Type 'System.Data.Linq.EntityRef`1[[CategoryList, App_Code.dpv5xabw, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null]]' in Assembly 'System.Data.Linq, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' is not marked as serializable.

[global::System.Data.Linq.Mapping.TableAttribute(Name="dbo.DvdList"),Serializable]
public partial class DvdList : INotifyPropertyChanging, INotifyPropertyChanged
{

private static PropertyChangingEventArgs emptyChangingEventArgs = new PropertyChangingEventArgs(String.Empty);

private int _DvdId;

private string _Title;

private int _CategoryId;

private EntityRef<CategoryList> _CategoryList;

#region Extensibility Method Definitions
partial void OnLoaded();
partial void OnValidate(System.Data.Linq.ChangeAction action);
partial void OnCreated();
partial void OnDvdIdChanging(int value);
partial void OnDvdIdChanged();
partial void OnTitleChanging(string value);
partial void OnTitleChanged();
partial void OnCategoryIdChanging(int value);
partial void OnCategoryIdChanged();
#endregion

public DvdList()
{
    this._CategoryList = default(EntityRef<CategoryList>);
    OnCreated();
}

[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_DvdId", AutoSync=AutoSync.OnInsert, DbType="Int NOT NULL IDENTITY", IsPrimaryKey=true, IsDbGenerated=true)]
public int DvdId
{
    get
    {
        return this._DvdId;
    }
    set
    {
        if ((this._DvdId != value))
        {
            this.OnDvdIdChanging(value);
            this.SendPropertyChanging();
            this._DvdId = value;
            this.SendPropertyChanged("DvdId");
            this.OnDvdIdChanged();
        }
    }
}

[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Title", DbType="VarChar(50) NOT NULL", CanBeNull=false)]
public string Title
{
    get
    {
        return this._Title;
    }
    set
    {
        if ((this._Title != value))
        {
            this.OnTitleChanging(value);
            this.SendPropertyChanging();
            this._Title = value;
            this.SendPropertyChanged("Title");
            this.OnTitleChanged();
        }
    }
}

    [global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_CategoryId", DbType="Int NOT NULL")]
public int CategoryId
{
    get
    {
        return this._CategoryId;
    }
    set
    {
        if ((this._CategoryId != value))
        {
            if (this._CategoryList.HasLoadedOrAssignedValue)
            {
                throw new System.Data.Linq.ForeignKeyReferenceAlreadyHasValueException();
            }
            this.OnCategoryIdChanging(value);
            this.SendPropertyChanging();
            this._CategoryId = value;
            this.SendPropertyChanged("CategoryId");
            this.OnCategoryIdChanged();
        }
    }
}

[global::System.Data.Linq.Mapping.AssociationAttribute(Name="CategoryList_DvdList", Storage="_CategoryList", ThisKey="CategoryId", OtherKey="CategoryId", IsForeignKey=true, DeleteOnNull=true, DeleteRule="CASCADE")]
public CategoryList CategoryList
{
    get
    {
        return this._CategoryList.Entity;
    }
    set
    {
        CategoryList previousValue = this._CategoryList.Entity;
        if (((previousValue != value) 
                    || (this._CategoryList.HasLoadedOrAssignedValue == false)))
        {
            this.SendPropertyChanging();
            if ((previousValue != null))
            {
                this._CategoryList.Entity = null;
                previousValue.DvdLists.Remove(this);
            }
            this._CategoryList.Entity = value;
            if ((value != null))
            {
                value.DvdLists.Add(this);
                this._CategoryId = value.CategoryId;
            }
            else
            {
                this._CategoryId = default(int);
            }
            this.SendPropertyChanged("CategoryList");
        }
    }
}

public event PropertyChangingEventHandler PropertyChanging;

public event PropertyChangedEventHandler PropertyChanged;

protected virtual void SendPropertyChanging()
{
    if ((this.PropertyChanging != null))
    {
        this.PropertyChanging(this, emptyChangingEventArgs);
    }
}

protected virtual void SendPropertyChanged(String propertyName)
{
    if ((this.PropertyChanged != null))
    {
        this.PropertyChanged(this, new PropertyChangedEventArgs(propertyName));
    }
}

}

John Farrell John Farrell · Accepted Answer · 2011-04-04T00:05:03

You can define it in a partial class.

Create another .cs file and then use:

[Serializable]
public partial class DvdList
{

}

how to mark as serializable in dbml?

1 Answers