dapper.net-repository.cs

public class DapperRepository
{
    public List<Product> GetAllProductsByCategory(int categoryId)
    {
        using (IDbConnection db = new SqlConnection(@"Connection String"))
        {
            return db.Query<Product>
            ($"SELECT * From [SalesLT].[Product] INNER JOIN [SalesLT].[ProductCategory] ON [SalesLT].[ProductCategory].ProductCategoryId = [SalesLT].[Product].ProductCategoryId WHERE [SalesLT].[ProductCategory].ProductCategoryId ={categoryId}").ToList();

        }
    }
}