I can't reproduce it in our tests (which had a test for this already, works fine) ->
[Test]
public void InsertEmployee()
{
var toInsert = new EmployeeEntity();
toInsert.Name = "John D.";
toInsert.DateOfBirth = new DateTime(1970, 1, 1);
toInsert.StartTime = new DateTimeOffset(new DateTime(2014, 1, 1), new TimeSpan(11, 0, 0));
using(var adapter = new DataAccessAdapter())
{
Assert.IsTrue(adapter.SaveEntity(toInsert));
}
Assert.IsTrue(toInsert.Id > 0);
}
SQL:
SELECT @p2=NEXT VALUE FOR [SequenceDB].[dbo].[SEQ_Central]; INSERT INTO [SequenceTester].[dbo].[Employee] ([DateOfBirth], [ID], [Name], [StartTime]) VALUES (@p1, @p2, @p3, @p4)
Will test your test table now, perhaps it's something else...