Devart Forums

Code: Select all

string connString = "Data Source=C:\\Temp\\TestDb\\TestDbEf.db; Pooling=False;";
SQLiteConnection conn = new SQLiteConnection( connString );
conn.Open();

try
{
	SQLiteCommand cmd = new SQLiteCommand( "INSERT INTO TestTable VALUES (5, 'hello')", conn );
	cmd.ExecuteNonQuery();

	//the next command throws exception because of uniqueness constraint violation
	cmd = new SQLiteCommand( "INSERT INTO TestTable VALUES (5, 'hello')", conn );
	cmd.ExecuteNonQuery();
}
catch( SQLiteException e )
{
	//do nothing
}
finally
{
	conn.Close();
}

try
{
	//deletion fails, file still held open;
        //if I comment out the second insert, deletion succeeds
	File.Delete( "C:\\Temp\\TestDb\\TestDbEf.db" );
}
catch( Exception e )
{
	Console.WriteLine( e.Message );
}