DateTime properties

Jan 12, 2010 at 1:00 PM
Edited Jan 12, 2010 at 2:11 PM

 

One of my properties is a DateTime value.

Currently only the DD/MM/YYYY is being saved into the db (checked with a hex editor).

I've tried setting:

 

[DbfDotNet.Column(AdvancedType = AdvancedColumnType.DATETIME)]

but I'm getting the error:

 

Unknown Method : Read__DateTime.

 

Any ideas?

Jan 12, 2010 at 2:01 PM
Edited Jan 12, 2010 at 2:11 PM

I've noticed line 215 of quickserializer:

 

if (dbfType == "DATETIME") dbfType = "";

This means that the Read_DATETIME_DateTime and Write_DateTime_DATETIME methods are not found.

Is this intentional?

Coordinator
Jan 12, 2010 at 8:30 PM

You probably located the problem.

I am afraid to say I haven't pursued this project much further.

I had plan to grow it to a proper mini relational database.

The main design issue is that the columns are saved a field and not properties.

This mean I cannot trap unique index conflicts soon enough.

I have given up this project for now. I am happy to give anyone admin access to it on request.

 

 

Jan 12, 2010 at 9:50 PM

I'm probably going try and implement something similar but simpler.

I don't need dbf compatibility so I'm going to try and make a data store with fixed width data that supports native .NET data types and uses reflection. 

 

I think your library should be around for people who need to read dbf files!

Coordinator
Jan 12, 2010 at 10:43 PM

For reading dbf file it is not too bad yes, it would need some work though.

If you need solid indexes I suggest you have a look at this : http://bplusdotnet.sourceforge.net/