I am a beginner in ASP and C #. I have doubts and this is the real reason to ask here. Before you can read how the question policy is, understand that I am a beginner and really need help.
I have a question of how to connect to my ASP application with a database DB First
.
As I'm starting, I've decided to raise as much information as possible. I initially read that there are two types of projects: Code First
where classes are first developed and the database is automatically generated on top of that and Database First
: database developed before the application.
After that I started to search how to make the connections, so I collected the following information:
- Ado .net: Native to the .Net platform. All the examples I found were over
Code First
. All connections are automatically generated - Entity Framework:
ORM
heavily used incode first
applications and it is not recommended to use inDB First
applications because the code would be too long and difficult to understand. - Dapper: Micro ORM, developed by someone from
stack overflow
, fast and efficient. Also recommended forCode First
applications. - Linq: Say this is a mask for SQL strings
Why is it so unwise to use all of these items in a DB First
application?