System.Data.SQLite

Hi,

I tried to create an instance of SQLiteParameterCollection and got this error:

The type 'System.Data.SQLite.SQLiteParameterCollection' has no constructors defined.

This is with 1.0.33 on VS 2005. Looking at the interface through metadata shows that there isn't a public constructor.

Regards,
CT

Yep!  You'll find you can't create a SqlParameterCollection or an OleDbParameterCollection or an OdbcParameterCollection either -- they're not designed to be instantiated by themselves.

The parameter collection is exposed through a command object and cannot exist alone.  If you want to get an instance of a SQLiteParameterCollection you need to first create a command.

Robert

 

Hi Robert,

Thanks a lot for the info!

rsimpson:

Yep!  You'll find you can't create a SqlParameterCollection or an OleDbParameterCollection or an OdbcParameterCollection either -- they're not designed to be instantiated by themselves.

The parameter collection is exposed through a command object and cannot exist alone.  If you want to get an instance of a SQLiteParameterCollection you need to first create a command.

Hmm, this throws me into a bind, I've been using ParameterCollections to pass parameters around between various functions (which have a number of commands in them, but use the same parameters).

Any thoughts on how you see doing that under SQLite? (Under MySql I can just instanciate a MySqlParameterCollection and add my parameters to it).

Ah -- that feature would be unique to MySql then.

I'd recommend a more generic approach, which would be to use an array and call the Command.Parameters.AddRange() command to add the entire array to the parameters for the command.

Robert

 

Okay, well eventually I'll try that, for right now I'm being bad and using horrid coding to create a SQLiteParameterCollection (by creating a dummy command, adding my parameters to it, and then using SQLiteCommand.Parameters to retrieve the Parameter Collection).

It's ugly, but for now it works.,...

@Robert: Thanks for keeping this thread open for so long. Otherwise, I'd have to double post.

I'm new to SQLite and just ran into this same problem.

Yes, I suppose I could use something generic like "AddRange()", but then I'd need to keep track of what types of parameters these are (Integer, Double, String).

I am going to try using JamesD's approach for now, but I won't be to a point where I can compile and test this code for a few more days.

@JamesD or others: If someone tried this and ran into problems, kindly let me know.

Similarly, if I run into problems, I'll post up too.