System.Data.SQLite

Hi,

I use DbProviderFactory with System.Data.SQLite 1.0.60.0 in code like this:

DbProviderFactory dbProviderFactory = DbProviderFactories.GetFactory(ConfigurationContext.ProviderName);

DbConnection connection = dbProviderFactory.CreateConnection();
connection.ConnectionString = ConfigurationContext.ConnectionString;
connection.Open();

DbCommand command = dbProviderFactory.CreateCommand();

command.Connection = connection;
command.CommandText = "query with parameter";
command.Parameters.Add(someInteger); << here exception

System.InvalidCastException: Unable to cast object of type 'System.Int32' to type 'System.Data.SQLite.SQLiteParameter'.

 It seems, that last line call Add(SQLiteParameter)  instead of  Add(Object).

 Something wrong in my code?

 Thanks

 Hi,

 You need to create parameters of the correct type

A quick example

    int afsluiting = 7;

    cmd.CommandText = "SELECT * FROM Voorraad WHERE Afsluiting=@Afsluiting";

    cmd.Parameters.Add( new SQLiteParameter{ ParameterName="@Afsluiting" , Value = afsluiting });

Thanks for your answer, but you dont understand that I want. I want to create all SQLite objects by DbProviderFactory and work with them by abstract classes like DbCommand, DbConnection, etc.

Use either the command object's or the factory's "CreateParameter" method.  Not sure if the DbCommand abstract class includes that or not. If not, you'll need to use the factory's version.

 Thanks! I overlooked CreateParameter method of DbProviderFactory.