Junior — Middle
What operators in Entity Framework are used to interact with the database for executing queries?
sobes.tech AI
Answer from AI
In Entity Framework, LINQ operators and data context methods (DbContext) are used to interact with the database. The main operators for executing queries are:
- LINQ queries: allow writing database queries as C# expressions (e.g.,
Where,Select,OrderBy). - DbSet methods:
Add,Remove,Find, and others for adding, deleting, and searching entities. SaveChanges()method: saves changes to the database.
Example of a query using LINQ:
using(var context = new MyDbContext())
{
var users = context.Users
.Where(u => u.Age > 18)
.OrderBy(u => u.Name)
.ToList();
}
Thus, interaction with the database occurs through LINQ operators and context methods, which are translated into SQL queries.