[Mono-devel-list] ADO.NET driver upgrade - class naming and namespace query

[Tim Anderson]

> -----Original Message-----
> From: Rafael Teixeira [mailto:monoman at gmail.com] 
> Sent: 27 December 2004 18:30
> To: Tim Anderson
> Cc: mono-devel-list at lists.ximian.com
> Subject: Re: [Mono-devel-list] ADO.NET driver upgrade - class 
> naming and namespace query
> 
> Hi Tim,
> 
> > Is there any guidance as to what is best practice here, either for 
> > ADO.NET or for .NET generally?
> 
> Generally the ADO.NET provider are just plain flexible. They 
> are the same always and cope with many versions of the 
> server/backend, at most some parameter in the connection 
> string says what kind/version of backend to connect.

Thanks Rafael and kangaroo. I've now downloaded the latest version which
does indeed take this approach - there's a version argument in the
connection string.

Unfortunately at the moment the client doesn't make much use of the new
Sqlite 3.0 features as far as I can see. Sqlite 2.0 stores all data as
strings, but this isn't the case in Sqlite 3.0; however the mono client
is still converting all the data to strings. Another issue is that SQL
parameters aren't yet supported for updates, as far as I can see, which
means you can't store binary data in the new blob field type.

Tim