Exemple #1
0
        public IList <T> ObtenerListaObjetos <T>(string cmd, Func <Lector, T> mapeo, params Parametro[] parametros)
            where T : class
        {
            Inicializar();

            using (var conn = CrearConnection())
            {
                conn.Open();

                using (var command = CrearCommand(conn, cmd, parametros))
                    using (var reader = command.ExecuteReader())
                        using (var lector = new Lector(reader))
                        {
                            try
                            {
                                var res = new List <T>();
                                while (reader.Read())
                                {
                                    res.Add(mapeo(lector));
                                }
                                return(res);
                            }
                            finally
                            {
                                reader.Close();
                            }
                        }
            }
        }
Exemple #2
0
        public T Obtener <T>(string cmd, Func <Lector, T> mapeo, params Parametro[] parametros)
        {
            T resultado = default(T);

            EjecutarOperacion(
                cmd,
                parametros,
                (command) =>
            {
                using (var reader = command.ExecuteReader())
                    using (var lector = new Lector(reader))
                    {
                        try
                        {
                            if (reader.Read())
                            {
                                resultado = mapeo(lector);
                            }
                        }
                        finally
                        {
                            reader.Close();
                        }
                    }
            });

            return(resultado);
        }
Exemple #3
0
        public T ObtenerObjeto <T>(string cmd, Func <Lector, T> mapeo, params Parametro[] parametros)
            where T : class
        {
            Inicializar();

            using (var conn = CrearConnection())
            {
                conn.Open();

                using (var command = CrearCommand(conn, cmd, parametros))
                    using (var reader = command.ExecuteReader())
                        using (var lector = new Lector(reader))
                        {
                            try
                            {
                                if (reader.Read())
                                {
                                    return(mapeo(lector));
                                }

                                return(default(T));
                            }
                            finally
                            {
                                reader.Close();
                            }
                        }
            }
        }
Exemple #4
0
        public IList <T> ObtenerLista <T>(string cmd, Func <Lector, T> mapeo, params Parametro[] parametros)
        {
            IList <T> resultado = new List <T>();

            EjecutarOperacion(
                cmd,
                parametros,
                (command) =>
            {
                using (var reader = command.ExecuteReader())
                    using (var lector = new Lector(reader))
                    {
                        while (reader.Read())
                        {
                            resultado.Add(mapeo(lector));
                        }
                    }
            });

            return(resultado);
        }