I have the following Database
CREATE TABLE [Request] ( [IDRequest] INTEGER PRIMARY KEY NOT NULL, [RequestID] VARCHAR(10) NULL, [ReceivedDate] VARCHAR(20) NULL, [RequestStatus] VARCHAR(20) NULL, [ExpirationStatus] VARCHAR(15) NULL, [ResponseStatus] VARCHAR(20) NULL, [StatusMessage] VARCHAR(20) NULL )
To connect I use the following
private SQLiteConnection conexionBD;
public DAOConexion (string directorio)
{
this.conexionBD = new SQLiteConnection(@"Data Source=" + directorio + ";Version=3;");
}
public void Conectar()
{
conexionBD.Open();
}
public bool doInsert(string sql)
{
//Creo y corro la consulta
SQLiteCommand sqlcommand = new SQLiteCommand(sql, conexionBD);
if (sqlcommand.ExecuteNonQuery() > 1)
{
sqlcommand.Dispose();
return false;
}
else
{
sqlcommand.Dispose();
return true;
}
}
The implementation that I am using test mode is the following
conBD.doInsert ("INSERT INTO Request (RequestID, ReceivedDate, RequestStatus, ExpirationStatus ,ResponseStatus, StatusMessage)VALUES ('1', 'asd', '32', 'California', '20000.00','sadsa' );");
The problem is that he is throwing me
SQLite error
no such table: Request
The table is created and if I use the same query in the database it works.