Add new fields to the existing asp.net mvc table

 

Here we use adding an int type AttachmentId in the Circular table as an example.

1. Find the dbml file and use a text tool to open it. Locate the corresponding location of Circular and add the following statement under its type.

<Column Name = "AttachmentId" Type = "System. Int32" DbType = "Int" CanBeNull = "true"/>

 

 

2. Find the Circular class in the dbml subfile and cs type file.

 

 

3. Add a variable.

Private System. Nullable <int> _ AttachmentId;

 

 

4. Add two functions.

Partial void OnAttachmentIdChanging (System. Nullable <int> value );

Partial void OnAttachmentIdChanged ();

 

 

5. Add an attribute.

[Column (Storage = "_ AttachmentId", DbType = "Int")]

Public System. Nullable <int> AttachmentId

{

Get

{

Return this. _ AttachmentId;

}

Set

{

If (this. _ AttachmentId! = Value ))

{

This. OnAttachmentIdChanging (value );

This. SendPropertyChanging ();

This. _ AttachmentId = value;

This. SendPropertyChanged ("AttachmentId ");

This. OnAttachmentIdChanged ();

}

}

}

From: Beautiful architecture, beautiful life