Home  /  Questions  /  Question

63   95.7
Jul 17, 2012

PIA: Error in Data Access Layer when using SQLServer.ADONET

Hi all,

The Version property (string) comes from a TimeStamp in the SQL Database.  The Take() and Make() methods on the CustomerDao class use the extension methods AsByteArray() and AsBase64String() respectively to convert from and to strings.

The default Version value "NotSet" doesn't convert in AsByteArray() correctly as an Exception is thrown ("Invalid length for a Base-64 char array or string.").

I think I've also found that existing Customers are passed back incorrect TimeStamps into SQL anyway so suspect the conversions are incorrect.

Any ideas?

63   95.7
Jul 19, 2012
Can anyone confirm whether they get the same problems or not?

I just wrote a simple console app to execute CRUD operations against Customers...

63   95.7
Jul 31, 2012
No one?

65   95.8
Aug 04, 2012
Hi, Martyn.

I'd like to help, and my apologies for being ignorant, but what is SqlServerCustomerDao?


63   95.7
Aug 08, 2012
Hi Mike,
Thanks for getting back to me - apologies, it was a typo - I've corrected the question...

63   95.7
Aug 16, 2012
Hi Mike,

Just wondered if this had been reviewed - especially with a new release due some time over the next few months?