This question is locked. New answers and comments are not allowed.
Hello all.
I have a TimeSpan property. This is being mapped on SQL-Server to a Datetime column. On retrieval I always get a zero time span
My persisent class:
001.
#pragma warning disable 1591
002.
//------------------------------------------------------------------------------
003.
// <auto-generated>
004.
// Dieser Code wurde von einem Tool generiert.
005.
// Wenn der Code neu generiert wird, gehen alle Ă„nderungen an dieser Datei verloren
006.
// </auto-generated>
007.
//------------------------------------------------------------------------------
008.
using
idee5.Dispatcher.Model.Constants;
009.
using
System;
010.
using
System.Collections.Generic;
011.
using
System.ComponentModel.DataAnnotations;
012.
using
System.Linq;
013.
using
System.Text;
014.
015.
namespace
idee5.Dispatcher.Model.DAL {
016.
public
partial
class
Operation : IMasterSystemId {
017.
[Required(),Key()]
018.
public
virtual
int
Id {
019.
get
;
020.
set
;
021.
}
022.
023.
[Required]
024.
public
virtual
uint
SequenceNumber {
025.
get
;
026.
set
;
027.
}
028.
029.
/// <summary>
030.
/// Taktzeit
031.
/// </summary>
032.
public
virtual
float
CycleTime {
033.
get
;
034.
set
;
035.
}
036.
037.
public
virtual
OperationProcessingStates ProcessingStatus {
038.
get
;
039.
set
;
040.
}
041.
042.
public
virtual
float
QuantityPerCycle {
043.
get
;
044.
set
;
045.
}
046.
047.
[Required()]
048.
public
virtual
string
Description {
049.
get
;
050.
set
;
051.
}
052.
053.
/// <summary>
054.
/// Produzierte Menge der Komponente
055.
/// </summary>
056.
public
virtual
float
QuantityConfirmed {
057.
get
;
058.
set
;
059.
}
060.
061.
/// <summary>
062.
/// Ausschussmenge der Komponente
063.
/// </summary>
064.
public
virtual
float
QuantityDefective {
065.
get
;
066.
set
;
067.
}
068.
069.
/// <summary>
070.
/// Menge der Komponenten mit verminderter Qualität.
071.
/// </summary>
072.
public
virtual
float
QuantityLessQuality {
073.
get
;
074.
set
;
075.
}
076.
077.
/// <summary>
078.
/// RĂ¼stzeit
079.
/// </summary>
080.
public
virtual
TimeSpan SetupTime {
081.
get
;
082.
set
;
083.
}
084.
085.
/// <summary>
086.
/// StĂ¼ckzeit
087.
/// </summary>
088.
public
virtual
TimeSpan TimePerUnit {
089.
get
;
090.
set
;
091.
}
092.
093.
/// <summary>
094.
/// Geplanter Start des Arbeitsgangs
095.
/// </summary>
096.
public
virtual
DateTime? StartScheduled {
097.
get
;
098.
set
;
099.
}
100.
101.
/// <summary>
102.
/// Geplantes Ende des Arbeitsgang
103.
/// </summary>
104.
public
virtual
DateTime? EndScheduled {
105.
get
;
106.
set
;
107.
}
108.
109.
/// <summary>
110.
/// Tatsächlicher Start des Arbeitsgang
111.
/// </summary>
112.
public
virtual
DateTime? StartActual {
113.
get
;
114.
set
;
115.
}
116.
117.
/// <summary>
118.
/// Tatsächliches Ende des Arbeitsgang
119.
/// </summary>
120.
public
virtual
DateTime? EndActual {
121.
get
;
122.
set
;
123.
}
124.
125.
public
virtual
int
WorkOrderId {
126.
get
;
127.
set
;
128.
}
129.
130.
public
virtual
int
? CycleTimeUoM {
131.
get
;
132.
set
;
133.
}
134.
135.
public
virtual
int
? WorkplaceId {
136.
get
;
137.
set
;
138.
}
139.
140.
public
virtual
int
? OperatingResourceId {
141.
get
;
142.
set
;
143.
}
144.
145.
/// <summary>
146.
/// Berechneter Start des Arbeitsgang
147.
/// </summary>
148.
public
virtual
DateTime? StartCalculated {
149.
get
;
150.
set
;
151.
}
152.
153.
/// <summary>
154.
/// Highest rank means highest efficiency
155.
/// </summary>
156.
[Required]
157.
public
virtual
char
EfficiencyRank {
158.
get
;
159.
set
;
160.
}
161.
162.
/// <summary>
163.
/// Liefezeit nach Arbeitsgang
164.
/// </summary>
165.
public
virtual
TimeSpan WaitTimeAfter {
166.
get
;
167.
set
;
168.
}
169.
170.
// Implementation of IMasterSystemId
171.
/// <summary>
172.
/// Master systems hierarchical identification. E.g. Company and/orPlant
173.
/// </summary>
174.
public
virtual
string
MasterSystemHierarchy {
get
;
set
; }
175.
176.
/// <summary>
177.
/// Master systems unique identification within the hierarchy.
178.
/// </summary>
179.
public
virtual
string
MasterSystemId {
get
;
set
; }
180.
181.
// association properties
182.
private
IList<MaterialComponent> materialComponents =
new
List<MaterialComponent>();
183.
public
virtual
IList<MaterialComponent> MaterialComponents {
184.
get
{
return
this
.materialComponents;}
185.
}
186.
187.
private
IList<Transaction> transactions =
new
List<Transaction>();
188.
public
virtual
IList<Transaction> Transactions {
189.
get
{
return
this
.transactions;}
190.
}
191.
192.
private
IList<MessageEvent> messageEvents =
new
List<MessageEvent>();
193.
public
virtual
IList<MessageEvent> MessageEvents {
194.
get
{
return
this
.messageEvents;}
195.
}
196.
197.
private
IList<CalendarEvent> calendarEvents =
new
List<CalendarEvent>();
198.
public
virtual
IList<CalendarEvent> CalendarEvents {
199.
get
{
return
this
.calendarEvents;}
200.
}
201.
202.
public
virtual
Item OperatingResource {
203.
get
;
204.
set
;
205.
}
206.
207.
public
virtual
UnitOfMeasure CycleUoM {
208.
get
;
209.
set
;
210.
}
211.
212.
public
virtual
Workplace Workplace {
213.
get
;
214.
set
;
215.
}
216.
217.
public
virtual
WorkOrder WorkOrder {
218.
get
;
219.
set
;
220.
}
221.
222.
}
223.
}
224.
#pragma warning restore 1591
Not being able to upload a screenshot I just can give the value stored in the database: "1907-08-05 00:00:00.000".
The value makes no sense, but yet it is more than zero.
How can I make this work?
Kind regards
Bernd