.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

uid: SafeShortID and HexShortID — Time-Ordered IDs Without the Rude Words

uid: SafeShortID and HexShortID — Time-Ordered IDs Without the Rude Words

Read Article
Bootlegance: 70 Free Bootstrap 5 Themes with Native Dark Mode

Bootlegance: 70 Free Bootstrap 5 Themes with Native Dark Mode

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

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

Read Article
View All Blog Posts