Approver.com

Retrieve an object by its ID

s = new School.Student(12);

Retrieve an object by arbitrary parameter

s = new School.Student();
s.GetData("LastName", "=", "Smith")

Save (insert) a new object

s = new School.Student();

s.FirstName = FirstNameText.Text;
s.LastName = LastNameText.Text;

try
{
    s.Save();
}
catch (MySqlException mex)
{
    Response.Write("ERROR: " + mex.Message);
}

Save (update) an existing object

s = new School.Student(12);
s.FirstName = "Chris";

try {
    s.Save();
}
catch (MySqlException mex)
{
    Response.Write("ERROR: " + mex.Message)
}

Retrieve a list of objects

ClassroomListFactory clf = new School.ClassroomListFactory();
Collection<Classroom> rooms = clf.GetClassroomList("RoomNumber", "ID > 1");

Delete an object

s = new School.Student(12);
s.Delete();

Return to Cgen Home page