private T GetFirst <T>(SqlCommand command, SqlRowParser <T> parser) { using (var reader = command.ExecuteReader()) { return(reader.Read() ? parser.Parse(reader, 0) : default(T)); } }
public MsSqlDbService(SqlRowParser <Student> studentParser, SqlRowParser <Enrollment> enrollmentParser, SqlRowParser <Studies> studiesParser, SqlRowParser <Role> roleParser) { _studentParser = studentParser; _enrollmentParser = enrollmentParser; _studiesParser = studiesParser; _roleParser = roleParser; }
private IEnumerable <T> GetAll <T>(SqlCommand command, SqlRowParser <T> parser) { using (var reader = command.ExecuteReader()) { var result = new List <T>(); while (reader.Read()) { var item = parser.Parse(reader, result.Count); result.Add(item); } return(result); } }
public EnrollmentSqlRowParser(SqlRowParser <Studies> studiesSqlRowParser) { _studiesSqlRowParser = studiesSqlRowParser; }