Provider problem, workaround in LLBLGen 2.6?

Posts   
 
    
Rushmore
User
Posts: 125
Joined: 27-Jan-2005
# Posted on: 11-Aug-2009 16:31:44   

Hello,

I´ve ported my FoxproDBDriver, FoxproDQE and the Templates to LLBLGen 2.6 (May 15th, 2009). The Provider problem appears as follows:

If a Date/DateTime value is null (and that´s possible, also in vfp) the provider returns 30.12.1899 for the column. Where´s the best place to handle this in the generated code.

A little bit more explantation:

There´s a CustomerEntity with a LastOrder column. The Database contains for the given customer/column a null value. Now I fetch the data for the Customer and Customer.LastOrder contains 30.12.1899 and that´s not right, the value should be null. I now it´s a problem of the Visual Foxpro OLEDB Provider but it would be great if that issue can be handled within the dal.

Again: Where´s the best place in LLBLGen to handle that issue?

Any suggestions?

Kind regards Carlo

MTrinder
User
Posts: 1461
Joined: 08-Oct-2008
# Posted on: 11-Aug-2009 21:55:26   

Possibly a type converter ?

Matt