public void RemoveStudent(int Id)
        {
            using (var cassandraDA = new CassandraDA(_config))
            {
                var     session = cassandraDA.GetSession();
                IMapper mapper  = new Mapper(session);

                mapper.Execute("Delete From tblStudent Where Id = ?", Id);
            }
        }
        public void ChangeDetails(Student student)
        {
            using (var cassandraDA = new CassandraDA(_config))
            {
                var     session = cassandraDA.GetSession();
                IMapper mapper  = new Mapper(session);

                mapper.Execute(" Update tblStudent SET Name = ?, Email = ?, Phone = ? where Id = ?;", student.Name, student.Email, student.Phone, student.Id);
            }
        }
        public Student GetStudentById(int Id)
        {
            using (var cassandraDA = new CassandraDA(_config))
            {
                var     session = cassandraDA.GetSession();
                IMapper mapper  = new Mapper(session);

                var student = mapper.SingleOrDefault <Student>("Select * From tblStudent Where Id = ?;", Id);
                return(student);
            }
        }
        public void NewStudent(Student student)
        {
            using (var cassandraDA = new CassandraDA(_config))
            {
                var     session = cassandraDA.GetSession();
                IMapper mapper  = new Mapper(session);


                mapper.Execute("Insert into tblstudent(Id, Name, Email, Phone) Values(?,?,?,?)", student.Id, student.Name, student.Email, student.Phone);
            }
        }
        public IEnumerable <Student> GetStudents()
        {
            using (var cassandraDA = new CassandraDA(_config))
            {
                var     session = cassandraDA.GetSession();
                IMapper mapper  = new Mapper(session);

                var students = mapper.Fetch <Student>("Select * From tblStudent;");
                return(students);
            }
        }