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); } }