SqlKata - Dynamic Sql query builder for dotnet | Product Hunt

🎉 SqlKata is now on Product Hunt

Please upvote to support the product development



var query = new Query("Comments")
                .SelectRaw("count(1) as count")
SELECT [PostId], count(1) as count FROM [Comments] GROUP BY [PostId]


var query = new Query("Companies")
    .SelectRaw("COUNT(*) as count")
    .GroupByRaw("Profit WITH ROLLUP");

In PostgreSql

SELECT "Profit", COUNT(*) as count FROM "Companies" GROUP BY Profit WITH ROLLUP
one email per month about tips & tricks, new features, and maybe community feedback