C#：如何在dapper ORM中使用接口

public interface IRepository<T>
{
    IEnumerable<T> GetAll();
    T GetById(int id);
    void Insert(T entity);
    void Update(T entity);
    void Delete(T entity);
}

public class DapperRepository<T> : IRepository<T>
{
    private readonly IDbConnection _connection;

    public DapperRepository(IDbConnection connection)
    {
        _connection = connection;
    }

    public IEnumerable<T> GetAll()
    {
        string sql = "SELECT * FROM TableName";
        return _connection.Query<T>(sql);
    }

    public T GetById(int id)
    {
        string sql = "SELECT * FROM TableName WHERE Id = @Id";
        return _connection.QueryFirstOrDefault<T>(sql, new { Id = id });
    }

    public void Insert(T entity)
    {
        string sql = "INSERT INTO TableName (Column1, Column2) VALUES (@Column1, @Column2)";
        _connection.Execute(sql, entity);
    }

    public void Update(T entity)
    {
        string sql = "UPDATE TableName SET Column1 = @Column1, Column2 = @Column2 WHERE Id = @Id";
        _connection.Execute(sql, entity);
    }

    public void Delete(T entity)
    {
        string sql = "DELETE FROM TableName WHERE Id = @Id";
        _connection.Execute(sql, entity);
    }
}

// 示例代码，假设你使用ASP.NET Core的依赖注入
services.AddScoped(typeof(IRepository<>), typeof(DapperRepository<>));

public class MyService
{
    private readonly IRepository<MyEntity> _repository;

    public MyService(IRepository<MyEntity> repository)
    {
        _repository = repository;
    }

    public IEnumerable<MyEntity> GetAllEntities()
    {
        return _repository.GetAll();
    }

    // 其他方法...
}