public EntityClient Get(int Id)
        {
            var data = base.DataContext.Client.Where(p => p.PK_ClientID == Id);

            if (data.Count() == 1)
            {
                return(FactoryClient.Get(data.Single()));
            }
            else
            {
                return(null);
            }
        }
        public EntityClient GetByClientID(string ClientID)
        {
            var data = base.DataContext.Client.Where(p => p.ClientID == ClientID);

            if (data.Count() == 1)
            {
                return(FactoryClient.Get(data.Single()));
            }
            else
            {
                return(null);
            }
        }