Dapper

dotnet add package System.Data.SqlClient
dotnet dd package Dapper

class Category{
	public int CategoryId { get; get; }
	public string CategoryName { get; get; } = null!;
}

class CategoryRepository{
	IConfiguration configuration;
	public CategoryRepository(IConfiguration configuration) => this.configuration = configuration;
	public IEnumerable<Category>(){
		using(IDbConnection connnection = new SqlConnection(configuration.GetConnectionString("Store"))){
			return connection.Query<Category>("SELECT * FROM Category");
		}
	}
	public int Add(Category obj){
		using(IDbConnection connnection = new SqlConnection(configuration.GetConnectionString("Store"))){
			return connection.Execute("INSERT INTO Category (CategoryName) VALUES (@CategoryName)", obj);
		}
	}
	public int Delete(int[] ids){
		using(IDbConnection connnection = new SqlConnection(configuration.GetConnectionString("Store"))){
			return connection.Execute("DELETE Category WHERE CategoryId IN @Ids", new {ids});
		}
	}
	public int Count(){
		using(IDbConnection connnection = new SqlConnection(configuration.GetConnectionString("Store"))){
			return connection.ExecuteScalar<int>("SELECT COUNT(*) FROM Category");
		}
	}
}