public EmployeeCollection FetchByQuery(Query qry)
{
EmployeeCollection coll = new EmployeeCollection();
coll.LoadAndCloseReader(qry.ExecuteReader());
return(coll);
}
public EmployeeCollection FetchAll()
{
EmployeeCollection coll = new EmployeeCollection();
Query qry = new Query(Employee.Schema);
coll.LoadAndCloseReader(qry.ExecuteReader());
return(coll);
}
public static Northwind.EmployeeCollection GetEmployeeCollection(string varTerritoryID)
{
SubSonic.QueryCommand cmd = new SubSonic.QueryCommand("SELECT * FROM [dbo].[Employees] INNER JOIN [EmployeeTerritories] ON [Employees].[EmployeeID] = [EmployeeTerritories].[EmployeeID] WHERE [EmployeeTerritories].[TerritoryID] = @TerritoryID", Territory.Schema.Provider.Name);
cmd.AddParameter("@TerritoryID", varTerritoryID, DbType.String);
IDataReader rdr = SubSonic.DataService.GetReader(cmd);
EmployeeCollection coll = new EmployeeCollection();
coll.LoadAndCloseReader(rdr);
return(coll);
}
