Both ORMs are great and work with any kind of project, from small-scale to massive enterprise-level applications. The answer is 100% a personal / enterprise culture choice.
Some people prefer to write all queries (Dapper) and some people prefer to work with LINQ (EF Core). Both are their pros and cons.
You can learn more on Dapper vs EF Core