What tools have you used for data retrieval from databases?

In C#, the following tools are often used for data retrieval from a database:

• ADO.NET — a basic set of classes for working with databases via SQL queries.
• Entity Framework (EF) — an ORM that allows working with the database through objects and LINQ queries.
• Dapper — a lightweight ORM that uses extensions for IDbConnection and allows writing SQL queries with object mapping.

Example of data retrieval using Entity Framework:

using(var context = new MyDbContext())
{
    var users = context.Users.Where(u => u.IsActive).ToList();
}

And an example with Dapper:

using(var connection = new SqlConnection(connectionString))
{
    var users = connection.Query<User>("SELECT * FROM Users WHERE IsActive = 1").ToList();
}