Jonathan Gilbert wrote: > What about making SQLite type "safety" an optional feature, configured in > the connection string, so that when enabled, the GetSchemaTable method > returns the types asreported by SQLite, but by default (with a plain, > standard connection string) it returns all columns as 'String'? This is > especilaly attractive if there is some way to indicate this in the > connection string that other providers (e.g. Finisar) will simply ignore. > That way, if you know & trust the database, you can enable the type > conversions, but with the knowledge that the database could be "corrupt" > w.r.t. the column types, resulting in exceptions that are outside of your > control. If you don't trust the database, then you can simply get strings > back and go from there :-)
That is an excellent idea. Unfortunately, the existing library will not cope with arbitrary strings in DateTime fields - the only additional feature it allows is floating point numbers, which seems a bit pointless to me. > Of course, Mono.Data.SqliteClient uses "URI" in place of "Data Source", but > perhaps "Data Source" could be added to Mono.Data.SqliteClient; then, the > above connection string would work just fine in both Finisar.Sqlite and > Mono.Data.SqliteClient :-) In a similar vein, it would be nice if Mono.Data.Sqlite had trivial subclasses of all the public classes called "SQLite*" instead of "Sqlite*", thus making it even more compatible with Finisar (without breaking any existing code). -- Nikki Locke, Trumphurst Ltd. PC & Unix consultancy & programming http://www.trumphurst.com/ _______________________________________________ Mono-list maillist - [email protected] http://lists.ximian.com/mailman/listinfo/mono-list
