public List <Students> GetIndividualStudents(string studentName) { using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(SqlDataAccessConnection.connect("SchoolApp"))) { var results = connection.Query <Students>("GetIndividualStudents @StudentName", new { StudentName = studentName }).ToList(); return(results); } }
public List <Students> GetStudentWithMarks() { using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(SqlDataAccessConnection.connect("SchoolApp"))) { var results = connection.Query <Students>("GetStudentsWithMarks").ToList(); return(results); } }
//I used Dapper framework to connect sql server public List <Students> GetStudents() { //The using namespace makes sure you don't live connection to the server open. using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(SqlDataAccessConnection.connect("SchoolApp"))) { var results = connection.Query <Students>("GetAllStudents").ToList(); return(results); } }