Retrieves a collection of Contacts from the database using the supplied SQL FROM and WHERE criteria and parameters. The starting SQL is: SELECT Name.* FROM Name {0} WHERE 1 = 1 {1}. So any additional FROM criteria should look something like: ", Name_Note" or "INNER JOIN Name_Note ON Name.ID = Name_Note.ID" etc. Any additional WHERE criteria should start with AND, like: "AND Name.ID = Name_Note.ID" etc.

Retrieves a collection of Contacts from the database using the supplied SQL FROM and WHERE criteria and parameters. The starting SQL is: SELECT Name.* FROM Name {0} WHERE 1 = 1 {1}. So any additional FROM criteria should look something like: ", Name_Note" or "INNER JOIN Name_Note ON Name.ID = Name_Note.ID" etc. Any additional WHERE criteria should start with AND, like: "AND Name.ID = Name_Note.ID" etc.

Retrieves a collection of Contacts from the database using the supplied SQL FROM and WHERE criteria, ORDER BY clause and parameters. The starting SQL is: SELECT Name.* FROM Name {0} WHERE 1 = 1 {1} ORDER BY {2}. So any additional FROM criteria should look something like: ", Name_Note" or "INNER JOIN Name_Note ON Name.ID = Name_Note.ID" etc. Any additional WHERE criteria should start with AND, like: "AND Name.ID = Name_Note.ID" etc. The ORDER BY should look like: "Name.LAST_NAME" or "Name.LAST_NAME DESC" etc.

Retrieves a collection of Contacts from the database using the supplied SQL FROM and WHERE criteria, ORDER BY clause and parameters. The starting SQL is: SELECT Name.* FROM Name {0} WHERE 1 = 1 {1} ORDER BY {2}. So any additional FROM criteria should look something like: ", Name_Note" or "INNER JOIN Name_Note ON Name.ID = Name_Note.ID" etc. Any additional WHERE criteria should start with AND, like: "AND Name.ID = Name_Note.ID" etc. The ORDER BY clause should look like: "Name.LAST_NAME" or "Name.LAST_NAME DESC" etc.