Can I use SQL Queries instead of Entity framework in .NET Core clean architecture?

Question

While researching about the clean architecture of .NET Core, I understand that only Entity Framework is being used.

I wanted to know whether we can use raw SQL queries by making a connection to SQL with connection strings.

You can use datareader, dataset and dataadapter as in system.data assembly or extension assembly based on .Net Core version — Sonal Borkar
– Sonal Borkar, Commented Mar 4, 2019 at 7:02

Imran Arshad · Accepted Answer · 2019-03-04 09:25:36Z

2

Clean architecture doesn't restricts you to entity frame work. You can also look into micro ORM e.g. Dapper which can be used to write sql queries. It's very powerful and gives you many out of box capabilities e.g. mapping. Infact if you don't want full ORM functionality Dapper is recommended in Microsoft docs.

Dapper

Dapper for read queries

edited Mar 4, 2019 at 9:25

answered Mar 4, 2019 at 9:18

Imran Arshad

4,0322 gold badges27 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Can I use SQL Queries instead of Entity framework in .NET Core clean architecture?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related