I started out my career as a database developer and it is still part of my core duties. As such, I'm extremely comfortable with writing SQL queries, stored procedures, optimizing and writing performant queries, ETC.

As such, I've been using Dapper and completely avoided EF altogether as it mostly confuses me. I can't figure out if there's a way to execute stored procedures or complicated table joins--it's straightforward with Dapper.

I've googled around and have found a lot of conflicting opinions. I've always gotten the best advice from reddit, so I thought it would be appropriate to re-ask the question here. Why should I learn it (beyond looking good on my resume)?

Thanks guys!