There are several ways to load data into your business objects.

---

Method 1 - LoadByPrimaryKey

1. Automatically generated for you in your business object.
2. Calls the "Get" version stored procedure (i.e. daab_GetEmployees).
3. All the columns contained in the table's primary key become parameters to the function. You must specify a value for all fields in the primary key in order to return one row.

Employees obj = new Employees(); // Load a single row via the primary key obj.LoadByPrimaryKey(18);

---

Method 2 - LoadAll

1. Automatically generated for you in your business object.
2. Calls the "GetAll" version stored procedure (i.e. daab_GetAllEmployees).
3. Returns all rows in the database table.

Employees obj = new Employees(); // Load all rows from the table obj.LoadAll();

---

Method 3 - Dynamic Queries

1. Used to create custom queries. (see the Dynamic Query tutorial)
2. Queries are created in code without writing SQL (which is not portable across databases).

Employees emp = new Employees(); // Limit the columns returned by the SELECT query emp.Query.AddResultColumn(EmployeesSchema.LastName); emp.Query.AddResultColumn(EmployeesSchema.FirstName); emp.Query.AddResultColumn(EmployeesSchema.City); emp.Query.AddResultColumn(EmployeesSchema.Region); // Add an ORDER BY clause emp.Query.AddOrderBy(EmployeesSchema.LastName); // Add a WHERE clause emp.Where.Region.Value = "WA"; emp.Query.Load();

---

Method 4 - LoadFromSql

1. Used in your concrete classes to call custom queries.
2. Can be used with both stored procedures and inline SQL.

public virtual bool EmployeeSalesbyCountry (DateTime BeginningDate, DateTime EndingDate) { // Create the Database object, using the default database service. The // default database service is determined through configuration. Database db = GetDatabase(); string sqlCommand = this.SchemaStoredProcedureWithSeparator + "Employee Sales by Country"; DBCommandWrapper dbCommandWrapper = db.GetStoredProcCommandWrapper(sqlCommand); // Add procedure parameters return base.LoadFromSql(dbCommandWrapper); }

---

Method 5 - QuerySource

1. Used in conjunction with dynamic queries to load the business object from an alternate data source, such as a view.
2. If the alternate data source is a superset of the columns defined in the business object, you can still Save the business object.

Employees emp = new Employees(); emp.QuerySource = "EmployeeDetailView"; // Load the business object from a view emp.Query.Load();

---

Method 6 - LoadFromSqlNoExec

1. Used to call a custom query without affecting the business object's contents.
2. Can be used with both stored procedures and inline SQL.

---

Method 7 - LoadFromSqlScalar

1. Used to return a value from a custom query without affecting the business object's contents.
2. Can be used with both stored procedures and inline SQL.

---

Method 8 - LoadFromSqlReader

1. Used to return an IDataReader from a custom query without affecting the business object's contents.
2. Can be used with both stored procedures and inline SQL.