static void Main()
{
var timeData = new TimeData
{
Duration = Duration.FromMinutes(1),
Offset = Offset.FromHours(1),
ZonedDateTime = new ZonedDateTime(Instant.FromDateTimeUtc(DateTime.UtcNow), DateTimeZone.Utc),
LocalDateTime = LocalDateTime.FromDateTime(DateTime.Today),
OffsetDateTime = OffsetDateTime.FromDateTimeOffset(DateTimeOffset.UtcNow),
LocalDate = LocalDate.FromDateTime(DateTime.Today),
Instant = Instant.FromDateTimeUtc(DateTime.UtcNow),
LocalTime = new LocalTime(18, 6),
Id = Guid.NewGuid()
};
var context = new NodaTimeContext();
context.TimeData.Add(timeData);
context.SaveChanges();
var newData = context.TimeData.FirstOrDefault(x => x.Id == timeData.Id);
Console.WriteLine($"Duration: {newData.Duration}. Offset: {newData.Offset}. ZonedDateTime: {newData.ZonedDateTime}. " +
$"LocalDateTime: {newData.LocalDateTime}. OffsetDateTime: {newData.LocalDateTime}. LocalDate: {newData.LocalDate}. " +
$"LocalTime: {newData.LocalTime}. Id: {newData.Id}.");
Console.ReadLine();
}
public static void Seed(NodaTimeContext context)
{
var localDateTime = new LocalDateTime(2018, 4, 20, 10, 31, 33, 666);
var zonedDateTime = localDateTime.InUtc();
var instant = zonedDateTime.ToInstant();
_defaultPeriod = Period.FromYears(2018) + Period.FromMonths(4) + Period.FromDays(20) +
Period.FromHours(10) + Period.FromMinutes(31) + Period.FromSeconds(23) +
Period.FromMilliseconds(666);
context.Add(new NodaTimeTypes
{
Id = 1,
LocalDateTime = localDateTime,
ZonedDateTime = zonedDateTime,
Instant = instant,
LocalDate = localDateTime.Date,
LocalTime = localDateTime.TimeOfDay,
OffsetTime = new OffsetTime(new LocalTime(10, 31, 33, 666), Offset.Zero),
Period = _defaultPeriod,
DateRange = new NpgsqlRange <LocalDate>(localDateTime.Date, localDateTime.Date.PlusDays(5))
});
context.SaveChanges();
}
