easier Date/Time data entry in grid
Our database has an audit field:
[ActionDateUtc] DATETIMEOFFSET NOT NULL CONSTRAINT DEFAULT (SYSDATETIMEOFFSET()),
When I click "Add Row", this field is defaulted blank rather than null, and annoying since the only way to enter a date at this point is to manually key it in.
Save fails due to SQL overflow, and since save happens when you move off the record, it's not easy to copy/paste an existing one.
Ideally it would be fantastic if LINQPad would recognize that the value will be supplied by the DB, failing that a right click menu to enter 'now' or 'utc now' would be very helpful.
-
Nick commented
Oh, and I'll add that trying to copy a date value from one on the *same* record doesn't work because ctrl-c copies the whole row...