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