Table(Of TEntity).InsertOnSubmit Method (TEntity)

 

Adds an entity in a pending insert state to this Table(Of TEntity).

Namespace:   System.Data.Linq
Assembly:  System.Data.Linq (in System.Data.Linq.dll)

Public Sub InsertOnSubmit (
	entity As TEntity
)

Parameters

entity
Type: TEntity

The entity to be added.

The added entity will not appear in query results from this table until after SubmitChanges has been called.

' Create a new Order object.
Dim ord As New Order With _
{.OrderID = 12000, _
 .ShipCity = "Seattle", _
 .OrderDate = DateTime.Now}

' Add the new object to the Orders collection.
db.Orders.InsertOnSubmit(ord)

' Submit the change to the database.
Try
    db.SubmitChanges()
Catch e As Exception
    Console.WriteLine(e)
    ' Make some adjustments.
    ' ...
    ' Try again.
    db.SubmitChanges()
End Try

.NET Framework
Available since 3.5
Windows Phone Silverlight
Available since 7.1
Return to top
Show: