Table<TEntity>.InsertOnSubmit(TEntity) Method

Definition

Namespace:

System.Data.Linq

Assembly:

System.Data.Linq.dll

Adds an entity in a pending insert state to this Table<TEntity>.

public:
 virtual void InsertOnSubmit(TEntity entity);

public void InsertOnSubmit (TEntity entity);

abstract member InsertOnSubmit : 'Entity -> unit
override this.InsertOnSubmit : 'Entity -> unit

Public Sub InsertOnSubmit (entity As TEntity)

Parameters

entity

TEntity

The entity to be added.

Implements

InsertOnSubmit(TEntity)

Examples

// Create a new Order object.
Order ord = new Order
{
    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 (Exception e)
{
    Console.WriteLine(e);
    // Make some adjustments.
    // ...
    // Try again.
    db.SubmitChanges();
}

' 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

Remarks

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