SiswaRepository.cs

using Dapper;
using log4net;
using WindowsServiceGammu.Model;

namespace WindowsServiceGammu.Repository
{
    public interface ISiswaRepository
    {
        Siswa GetByNIS(string nis);
    }

    public class SiswaRepository : ISiswaRepository
    {
        private IDapperContext _context;
        private ILog _log;

        public SiswaRepository(IDapperContext context, ILog log)
        {
            this._context = context;
            this._log = log;
        }

        public Siswa GetByNIS(string nis)
        {
            Siswa siswa = null;

            try
            {
                var sql = @"select nis, nama 
                            from siswa 
                            where nis = @nis";

                siswa = _context.db.QuerySingleOrDefault<Siswa>(sql, new { nis });
            }
            catch (Exception ex)
            {
                _log.Error("Error:", ex);
            }

            return siswa;   
        }
    }
}