.NET. Select Users Users Registered Yesterday with Entity Framework

Here is how to select all users registered yesterday using the Entity Framework Code First.

.NET. Select Users Users Registered Yesterday with Entity Framework

Here is how to select all users registered yesterday using the Entity Framework:

var yesterday = DateTime.Now.AddDays(-1);

var yesterdayStart = yesterday.Date.ToString("yyyy-MM-dd 00:00:00"); // SQL formatted
var yesterdayEnd = yesterday.Date.ToString("yyyy-MM-dd 23:59:59"); // SQL formatted

var users = db.AccountUsers
    .Where(u => u.Created >= DateTime.Parse(yesterdayStart) && u.Created <= DateTime.Parse(yesterdayEnd))
    .ToList();
Debug.WriteLine(users.Count);
← Previous
Python. The Zen of Python
Next →
Embedded Databases

Keep Reading

Explore more articles and insights

A Big, Opinionated List of PHP Libraries (2026 Edition)

A Big, Opinionated List of PHP Libraries (2026 Edition)

Read Article
Ork: SSH Server Automation in Go

Ork: SSH Server Automation in Go

Read Article
Deno Deploy Killed My Start Page

Deno Deploy Killed My Start Page

Read Article
View All Blog Posts