Inserting Data

To insert a record into the table:

• Create a new instance of the class that represents a connection to the database.
• Get the table gateway object and call its Insert method passing a row object.
• Close the connection to the database.

For example:

[C#]

using(MyDatabase db = new MyDatabase())
{
    // Create new row object
    UserRow user = new UserRow();
    user.FirstName = "John";
    user.LastName = "Smith";
    user.City = "Houston";

    // Insert the object into the User table
    db.UserCollection.Insert(user);

    // You do not need to close the DB connection manually.
    // The using statement does it automatically.
}

MyDatabase db = new MyDatabase();
try
{
    // Create new row object
    UserRow user = new UserRow();
    user.FirstName = "John";
    user.LastName = "Smith";
    user.City = "Houston";

    // Insert the object into the User table
    db.UserCollection.Insert(user);
}
finally
{
    // Do not forget to close the DB connection
    db.Close();
}

VB.NET