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