public List <TipoDelito> GetAll()
        {
            var _providerService = new ProviderService();

            return(_providerService.ExecuteReaderTipoDelito("SELECT id, nombre, esprevenible FROM tipodelitos ORDER BY 1 ASC"));
        }