firebird-net-provider

[Firebird-net-provider] FbEmbed Not Releasing Database

[Scott M. <bl...@bl...>]

Trying to drop a DB opened with the embedded system, but something seems
to be holding the file open after the connection is closed.

Test case from a console app:

Console.WriteLine("Attempting to open DB...");
var conn = new FbConnection();
conn.ConnectionString = myConnectionString;
conn.Open();

Console.WriteLine("Attempting to close DB...");
conn.Close();

conn = null;
GC.Collect();	// Getting desperate here

Console.WriteLine("Attempting to delete DB...");
FbConnection.DropDatabase(ConnectionString);
// File.Delete(DBPath); // doesn't work either

Scott

Re: [Firebird-net-provider] FbEmbed Not Releasing Database

[Mark R. <ma...@la...>]

On 27-6-2014 18:09, Scott Morgan wrote:
> Trying to drop a DB opened with the embedded system, but something seems
> to be holding the file open after the connection is closed.
>
> Test case from a console app:
>
> Console.WriteLine("Attempting to open DB...");
> var conn = new FbConnection();
> conn.ConnectionString = myConnectionString;
> conn.Open();
>
> Console.WriteLine("Attempting to close DB...");
> conn.Close();
>
> conn = null;
> GC.Collect();	// Getting desperate here
>
> Console.WriteLine("Attempting to delete DB...");
> FbConnection.DropDatabase(ConnectionString);
> // File.Delete(DBPath); // doesn't work either

The .net provider has a connection pool, so the physical connection is 
still open. You need to flush the pool, or disable connection pooling.

You can flush the pool with:
FbConnection.ClearAllPools();

and disable connection pooling by setting Pooling=false in the 
connection string.

Mark
-- 
Mark Rotteveel

Re: [Firebird-net-provider] FbEmbed Not Releasing Database

[Scott M. <bl...@bl...>]

On 27/06/14 17:27, Mark Rotteveel wrote:
> On 27-6-2014 18:09, Scott Morgan wrote:
>> Trying to drop a DB opened with the embedded system, but something seems
>> to be holding the file open after the connection is closed.
> 
> The .net provider has a connection pool, so the physical connection is 
> still open. You need to flush the pool, or disable connection pooling.
> 
> You can flush the pool with:
> FbConnection.ClearAllPools();

That did the job, thanks.
(Had a feeling it was pooling, but completely missed that function)

Scott