Load Methods that Utilize Database Indexes

As you saw in the previous example, the Code Generator will always generate two load methods, Load and LoadAll, for every code generated class. Load takes in the primary key (or primary keys if you have multiple PKs defined on the table) as the parameter, while LoadAll simply returns all the rows in the table.

Using database indexes, the code generator will also generate additional Load-type methods given the way you have defined those indexes. In our Examples Site Database, there are quite a few indexes defined, but we will highlight two:

• person.last_name
• login.username (UNIQUE)

Given these two indexes, the code generator has generated LoadArrayByLastName in the Person object, and it has defined LoadByUsername in the Login object.

Note that the LastName load method returns an array while the Username load method returns just a single object. The code generator has recognized the UNIQUE property on the column, and it generated code accordingly.

You could also define indexes on multiple columns and the code generator will generate load methods based on those multi-column keys.