ASP.NET Core 2.2 and Entity Framework Core development

[Cromulent]

I'm about to start creating a website using .NET Core 2.2 and ASP.NET Core 2.2. I'll be using PostgreSQL 11.3 as the database, but I'm trying to decide whether I should use Entity Framework Core or whether I should use raw SQL.

The advantage of Entity Framework Core is that everything stays in C# which makes management more manageable but the benefit of using raw SQL is that I can do everything via stored procedures and triggers as well as doing decent profiling so I can optimise the SQL queries aggressively.

At the moment I'm not sure which route to take. Does anyone have any advice at all?

 

[Cromulent]

What is the aim of the website and how busy is it going to be?

As above, depends what your website is for. If it's CRUD and fairly standard DB structures, EF is ok. I'd be leaning towards Dapper and SQL queries for anything moderately complicated though.

The website is going to be a social network for politics. I imagine it will be fairly small but I want to try and make it grow to a reasonable size.

Thank you all for the replies I think I'll go with raw SQL as you have all said.