Foreign key used in asp.net

There is used a primary and foreign key used.Primary key as one table information save the same data in the foreign database table.The primary data not unique,and foreign key.

Foreign key set as same key both primary key and foreign key is same,and also set update rule as cascade.Using getdate() give the current time also.We can not change the table information.There is also connect each primary table connect to the foreign key.


Asp.net database have two keys primary and foreign key. Each key are use as  below.The primary key have one identifier.


There is also use inner joint,outer joint,join used.Join means joint two table,each field joint,the common fields.Inner join have left side common,but right side data remove.Outer join have right table field but remove left side field.



Below link for  the video download