Datetime2 Data Type

The. NET Entity Framework builds the website data layer and assigns values to the datetime type attribute of an object.
An exception that does not match the type is as follows:

System. Data. sqlclient. sqlexception: the conversion from datetime2 data type to datetime data type generates a value out of the range.

Solution:

Set the automatically generated code in the *. Designer. CS File

[EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=false)]        [DataMemberAttribute()]        public global::System.DateTime addtime        {            get            {                return _addtime;            }            set            {                OnaddtimeChanging(value);                ReportPropertyChanging("addtime");                _addtime = StructuralObject.SetValidValue(value);                ReportPropertyChanged("addtime");                OnaddtimeChanged();            }        }        private global::System.DateTime _addtime;        partial void OnaddtimeChanging(global::System.DateTime value);        partial void OnaddtimeChanged();

 

Change

 

[EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=false)]        [DataMemberAttribute()]        public Nullable<global::System.DateTime> addtime        {            get            {                return _addtime;            }            set            {                OnaddtimeChanging(value);                ReportPropertyChanging("addtime");                _addtime = StructuralObject.SetValidValue(value);                ReportPropertyChanged("addtime");                OnaddtimeChanged();            }        }        private Nullable<global::System.DateTime> _addtime;        partial void OnaddtimeChanging(Nullable<global::System.DateTime> value);        partial void OnaddtimeChanged();