public T GetById(S id) { using (var db = new SqlConnection(_connectionString)) { var data = db.Query <T>(String.Format("{0} where {1} = @id", Reflections.GetQuery(typeof(T)), Reflections.GetPk(typeof(T))), new { id = id }); return(data.SingleOrDefault()); } }
public IEnumerable <T> GetAll() { using (var db = new SqlConnection(_connectionString)) { var data = db.Query <T>(Reflections.GetQuery(typeof(T))); return(data); } }