[{"Id":"201901222020130672","ParentId":"20180919191134139533","Type":"Text","Sequence":1,"Attributes":{"Text":"Here is how to select all users registered yesterday using the Entity Framework:"}},{"Id":"201901222023580851","ParentId":"20180919191134139533","Type":"Code","Sequence":2,"Attributes":{"Language":"csharp","Code":"var yesterday = DateTime.Now.AddDays(-1);\r\n\r\nvar yesterdayStart = yesterday.Date.ToString(\"yyyy-MM-dd 00:00:00\"); // SQL formatted\r\nvar yesterdayEnd = yesterday.Date.ToString(\"yyyy-MM-dd 23:59:59\"); // SQL formatted\r\n\r\nvar users = db.AccountUsers\r\n .Where(u => u.Created >= DateTime.Parse(yesterdayStart) && u.Created <= DateTime.Parse(yesterdayEnd))\r\n .ToList();\r\nDebug.WriteLine(users.Count);"}}]