Cannot save nullable datetime

[sinancx]

Hi All,

We have problems to save nullable datetime in oracle.

[MapField("XYZ"], Nullable]
public DateTime? ValidFrom{get;set;}

If the value of the Property is null, we become the following error:

Exception thrown: 'System.ArgumentOutOfRangeException' in Oracle.ManagedDataAccess.dll
   bei Oracle.ManagedDataAccess.Client.OracleParameter.set_DbType(DbType value)
   bei BLToolkit.Data.DataProvider.OdpManagedDataProvider.BLToolkitExtension.OracleParameterWrap.System.Data.IDataParameter.set_DbType(DbType value)
   bei BLToolkit.Data.DbManager.Parameter(ParameterDirection parameterDirection, String parameterName, Object value, DbType dbType)
   bei BLToolkit.Data.DbManager.Parameter(String parameterName, Object value, DbType dbType)
   bei BLToolkit.DataAccess.SqlQueryInfo.GetParameters(DbManager db, Object obj)
   bei BLToolkit.DataAccess.SqlQuery`1.Insert(DbManager db, T obj)
   bei BLToolkit.DataAccess.SqlQuery`1.Insert(T obj)

Any help is appreciated.

Regards

Sinan

[ili]

I'll take a look in next few days.

[ili]

fixed in 4.3.9
nugets updated

[sinancx]

Great job! Thanks for the quick support!

[ili]

Not at all.
Please consider migrating to linq2db :)

[sinancx]

linq2db looks very good and similar to BLToolkit Linq Extension.

What's the difference between the two? and Which one will be supported more in the future?

Thanks and kind regards

Sinan

[ili]

linq2db is linq-only (and you are right, it is similar with BLToolkit Linq, because it is from the same author: @igor-tkachev )
no DataAccessors, no EditableObjects (but you can generate Editable objects from database with T4 templates), no ObjectBinder, reflection, etc...

BLToolkit is suspended, no new features would be implemented, only small bug fixes (as one you faced with). linq2db is live & growing project. So we do suggest to start new projects with inq2db & to migrate old, of possible.

[sinancx]

Thanks for the useful information! We liked BLToolkit and I am pretty sure linq2db will be great, as well.

Good luck!