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); }