//Método para traer los estudiantes por Nombre
    //Ejemplo: GET http://localhost:8080/items?filter=ABC
    router.get('/estudiante/name',(req,res,next)=>{
        var sql = require("mssql");

        //var FirstName = req.params.FirstName;

        // config for your database
          var config = {
                user: 'martin',
                password: '1234',
                server: 'JMTABORDA-PC\SQLEXPRESS',
                database: 'school'
            };


        sql.connect(config, function (err) {

            if (err) console.log(err);

            // create Request object
            var request = new sql.Request();

            // query to the database and get the records
            request.query('select * from Student WHERE FirstName=' +FirstName, function (err, recordset) {

                if (err) console.log(err)

                // send records as a response
                res.send(recordset);
                res.end();

            });


        });



    });