.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

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
Back to Golang: Why I Switched From Static to Dynamic Again

Back to Golang: Why I Switched From Static to Dynamic Again

Read Article
View All Blog Posts