public OrderTemplateTableCollection FetchByQuery(Query qry)
        {
            OrderTemplateTableCollection coll = new OrderTemplateTableCollection();

            coll.LoadAndCloseReader(qry.ExecuteReader());
            return(coll);
        }
        public OrderTemplateTableCollection FetchAll()
        {
            OrderTemplateTableCollection coll = new OrderTemplateTableCollection();
            Query qry = new Query(OrderTemplateTable.Schema);

            coll.LoadAndCloseReader(qry.ExecuteReader());
            return(coll);
        }
        public OrderTemplateTableCollection FetchByID(object OrderTemplateID)
        {
            OrderTemplateTableCollection coll = new OrderTemplateTableCollection().Where("OrderTemplateID", OrderTemplateID).Load();

            return(coll);
        }