Did Linq2DB not work?

Yes, I have worked with Linq2DB. It is a lightweight ORM for .NET that allows writing database queries using LINQ, while providing high performance and control over SQL queries. Unlike Entity Framework, Linq2DB is closer to SQL and offers more control over query optimization.

Example of a simple query with Linq2DB:

using(var db = new MyDatabase())
{
    var users = db.Users
                  .Where(u => u.Age > 18)
                  .OrderBy(u => u.Name)
                  .ToList();
}

Linq2DB supports many DBMS, transactions, complex queries, and allows using SQL functions directly.