SqlServer & EF7: Using datetime vs datetime2 date type

SqlServer data type “datetime” has accuracy and rounding problems and has been superseded with “datatime2” data type that has no such problems. But, “datetime” is still present in many legacy databases. We show how those problems in .NET Entity Framework environment can lead to confusing situations.