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

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

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

            return(coll);
        }