[Mono-list] Parameters & SQLite

[Jay R. Wren]

It is my blog, but take a look anyway. 

http://little.xmtp.net/blog/2005/10/21/proper-data-abstraction-in-net-and-mono-applications/
http://little.xmtp.net/blog/2005/11/22/more-proper-data-abstractions-in-net-and-mono-applications/

The short answer is "yes" parameters are supported.  There are examples
at the above URLs.

A short example:
|IDbCommand idcSelect = conn.CreateCommand();
idcSelect.CommandText = "select col from table where othercl=@someting";
||IDataParameter param = idcSelect.CreateParameter();
Cmd.Parameters.Add(param);
param.ParameterName = "@someting";
param.DbType = DbType.String;
param.Value = "whatever something would equal";
|
The above is more geared to 1.1, since 2.0 has DbConnection and the
ADO2.0 db provider stuff.
--
Jay

Adam Tauno Williams wrote:
> Are parameters supported by the Mono.Data.SqliteClient
> namespace/assembly?
>
> I've googled myself silly can can't find an example or statement about
> this.  Just lots of examples of using DataReader. :)
>
> Perhaps there is a matrix somewhere of what features are implemented in
> the various providers?
>
> _______________________________________________
>