How do I write a LINQ query for a list of users and their first article in MySQL?
How do I write a LINQ query that would translate to the following SQL? SELECT u.id, u.username, a.id, MIN(a.created_at) AS firstArticle FROM users u INNER JOIN editorial_articles a ON a.user_id = u.id GROUP BY u.id ORDER BY u.id, a.created_at, a.id…