datetime-generation - w3toppers.com

MySQL GROUP BY DateTime +/- 3 seconds

I’m using Tom H.’s excellent idea but doing it a little differently here: Instead of finding all the rows that are the beginnings of chains, we can find all times that are the beginnings of chains, then go back and ifnd the rows that match the times. Query #1 here should tell you which times … Read more

Entity Framework/SQL2008 – How to Automatically Update LastModified fields for Entities?

I know I’m a little late to the party, but I just solved this for a project I’m working on and thought I’d share my solution. First, to make the solution more re-usable, I created a base class with the timestamp properties: public class EntityBase { public DateTime? CreatedDate { get; set; } public DateTime? … Read more