There's an issue when performing a query against SQL server where a .NET DateTimeOffset is being compared against a SQL Server datetime2 column. SQL Server does weird things for implicit vs explicit ...

Everything else with SQL and DateTime seems to work so well. i.e. it just works I can declare a DateTime in C# and it will drop straight into SQL with no problems or anything.<BR><BR>However, getting ...