firebird-net-provider — All about development of the MS .Net provider

Re: [Firebird-net-provider] Help generating an EDMX on EF6

[Brian L. <li...@fr...>]

Interesting.

Reason?

Would think that FirebirdClient should be compiled for
Entity Framework 6.

Brian

From: Jiří Činčura 
Sent: Sunday, May 10, 2015 10:30 PM
To: For users and developers of the Firebird .NET providers 
Subject: Re: [Firebird-net-provider] Help generating an EDMX on EF6

Nope.

 

-- 

Mgr. Jiří Činčura

Independent IT Specialist

 

From: Brian Liedtke [mailto:li...@fr...] 
Sent: Monday, May 11, 2015 12:50 AM
To: For users and developers of the Firebird .NET providers
Subject: Re: [Firebird-net-provider] Help generating an EDMX on EF6

 

So the EF_6 symbol should not be set for FirebirdSql.Data.FirebirdClient?

 

Brian

 

From: Jiří Činčura 

Sent: Sunday, May 10, 2015 4:34 AM

To: For users and developers of the Firebird .NET providers 

Subject: Re: [Firebird-net-provider] Help generating an EDMX on EF6

 

The EF_6 is there for EntityFramework.Firebird, as there’s some shared code.

 

-- 

Mgr. Jiří Činčura

Independent IT Specialist

Re: [Firebird-net-provider] Help generating an EDMX on EF6

[Jiří Č. <ji...@ci...>]

Nope.

--
Mgr. Jiří Činčura
Independent IT Specialist

From: Brian Liedtke [mailto:li...@fr...]
Sent: Monday, May 11, 2015 12:50 AM
To: For users and developers of the Firebird .NET providers
Subject: Re: [Firebird-net-provider] Help generating an EDMX on EF6

So the EF_6 symbol should not be set for FirebirdSql.Data.FirebirdClient?

Brian

From: Jiří Činčura<mailto:ji...@ci...>
Sent: Sunday, May 10, 2015 4:34 AM
To: For users and developers of the Firebird .NET providers<mailto:fir...@li...>
Subject: Re: [Firebird-net-provider] Help generating an EDMX on EF6

The EF_6 is there for EntityFramework.Firebird, as there’s some shared code.

--
Mgr. Jiří Činčura
Independent IT Specialist

From: Brian Liedtke [mailto:li...@fr...]
Sent: Saturday, May 9, 2015 5:32 AM
To: For users and developers of the Firebird .NET providers
Subject: Re: [Firebird-net-provider] Help generating an EDMX on EF6

Hey Jiri,

Thanks for your response.

I downloaded the source code (NETProvider-4.6.2.0-src.7z) from the Firebirdsql.org site.
Built it, copied the libraries to my projects packages directory. Same thing happened.

So I started crawling around the code to see what I can find.
First thing I noticed, the conditional compilation symbols in the properties of the FirebirdSql.Data.FirebirdClient
project’s Build tab is missing the EF_6 symbol.

I’ve added that to my copy and attempted to rebuild it. Got some build errors that I’m trying to resolve concerning
using FirebirdSql.Data.Entity;
in FirebirdSql.Data.FirebirdClient/FbProviderManifest.

While I am working on that, I wanted to check to make sure that the EF_6 compilation symbol was set in the
build you made for the NuGet package. It could explain why I am getting the error I receive when
trying to generate an edmx.

Don’t know how close the source code that I downloaded is to what you used to generate
the NuGet package. But it was something that jumped out at me.

Brian Liedtke

Re: [Firebird-net-provider] Help generating an EDMX on EF6

[Brian L. <li...@fr...>]

So the EF_6 symbol should not be set for FirebirdSql.Data.FirebirdClient?

Brian

From: Jiří Činčura 
Sent: Sunday, May 10, 2015 4:34 AM
To: For users and developers of the Firebird .NET providers 
Subject: Re: [Firebird-net-provider] Help generating an EDMX on EF6

The EF_6 is there for EntityFramework.Firebird, as there’s some shared code.

 

-- 

Mgr. Jiří Činčura

Independent IT Specialist

 

From: Brian Liedtke [mailto:li...@fr...] 
Sent: Saturday, May 9, 2015 5:32 AM
To: For users and developers of the Firebird .NET providers
Subject: Re: [Firebird-net-provider] Help generating an EDMX on EF6

 

Hey Jiri,

 

Thanks for your response.

 

I downloaded the source code (NETProvider-4.6.2.0-src.7z) from the Firebirdsql.org site.

Built it, copied the libraries to my projects packages directory. Same thing happened.

 

So I started crawling around the code to see what I can find.

First thing I noticed, the conditional compilation symbols in the properties of the FirebirdSql.Data.FirebirdClient

project’s Build tab is missing the EF_6 symbol.

 

I’ve added that to my copy and attempted to rebuild it. Got some build errors that I’m trying to resolve concerning

using FirebirdSql.Data.Entity;

in FirebirdSql.Data.FirebirdClient/FbProviderManifest.

 

While I am working on that, I wanted to check to make sure that the EF_6 compilation symbol was set in the

build you made for the NuGet package. It could explain why I am getting the error I receive when

trying to generate an edmx.

 

Don’t know how close the source code that I downloaded is to what you used to generate

the NuGet package. But it was something that jumped out at me.

 

Brian Liedtke

Re: [Firebird-net-provider] Help generating an EDMX on EF6

[Jiří Č. <ji...@ci...>]

The EF_6 is there for EntityFramework.Firebird, as there’s some shared code.

--
Mgr. Jiří Činčura
Independent IT Specialist

From: Brian Liedtke [mailto:li...@fr...]
Sent: Saturday, May 9, 2015 5:32 AM
To: For users and developers of the Firebird .NET providers
Subject: Re: [Firebird-net-provider] Help generating an EDMX on EF6

Hey Jiri,

Thanks for your response.

I downloaded the source code (NETProvider-4.6.2.0-src.7z) from the Firebirdsql.org site.
Built it, copied the libraries to my projects packages directory. Same thing happened.

So I started crawling around the code to see what I can find.
First thing I noticed, the conditional compilation symbols in the properties of the FirebirdSql.Data.FirebirdClient
project’s Build tab is missing the EF_6 symbol.

I’ve added that to my copy and attempted to rebuild it. Got some build errors that I’m trying to resolve concerning
using FirebirdSql.Data.Entity;
in FirebirdSql.Data.FirebirdClient/FbProviderManifest.

While I am working on that, I wanted to check to make sure that the EF_6 compilation symbol was set in the
build you made for the NuGet package. It could explain why I am getting the error I receive when
trying to generate an edmx.

Don’t know how close the source code that I downloaded is to what you used to generate
the NuGet package. But it was something that jumped out at me.

Brian Liedtke



From: Jiří Činčura<mailto:ji...@ci...>
Sent: Monday, May 4, 2015 12:40 AM
To: For users and developers of the Firebird .NET providers<mailto:fir...@li...>
Subject: Re: [Firebird-net-provider] Help generating an EDMX on EF6

Hi,

Your set up looks correct, but EF cannot load the provider for some reason.

What I haven’t tried is using embedded FB with EF6 and EDMX – as the provider with embedded needs some IL emit and the provider is now executed in copyied sandboxed environment it might be an issue. Just guessing. Maybe try (for development) use server.

Or maybe you can get this https://github.com/cincuranet/EF6_Firebird/tree/master/EDMX and start from it.

--
Mgr. Jiří Činčura
Independent IT Specialist

From: Brian Liedtke [mailto:li...@fr...]
Sent: Sunday, May 3, 2015 3:45 AM
To: fir...@li...<mailto:fir...@li...>
Subject: [Firebird-net-provider] Help generating an EDMX on EF6

Hey all,

I’ve been beating my head against the wall this past week trying to get this solved.
After reading Jiri’s blog on upgrading to EF6 and going through the email archives,
I haven’t found a solution. After trying everything I can think of I am out of ideas.

Here what is happening. I am trying to upgrade to EF6. Everything looks good on the install.
I can build and run but when I try to generate an EDMX, I get the following error.

[image]

Re: [Firebird-net-provider] Help generating an EDMX on EF6

[Brian L. <li...@fr...>]

Hey Jiri,

Thanks for your response.

I downloaded the source code (NETProvider-4.6.2.0-src.7z) from the Firebirdsql.org site.
Built it, copied the libraries to my projects packages directory. Same thing happened.

So I started crawling around the code to see what I can find.
First thing I noticed, the conditional compilation symbols in the properties of the FirebirdSql.Data.FirebirdClient
project’s Build tab is missing the EF_6 symbol.

I’ve added that to my copy and attempted to rebuild it. Got some build errors that I’m trying to resolve concerning
using FirebirdSql.Data.Entity;
in FirebirdSql.Data.FirebirdClient/FbProviderManifest.

While I am working on that, I wanted to check to make sure that the EF_6 compilation symbol was set in the
build you made for the NuGet package. It could explain why I am getting the error I receive when
trying to generate an edmx.

Don’t know how close the source code that I downloaded is to what you used to generate
the NuGet package. But it was something that jumped out at me.

Brian Liedtke



From: Jiří Činčura 
Sent: Monday, May 4, 2015 12:40 AM
To: For users and developers of the Firebird .NET providers 
Subject: Re: [Firebird-net-provider] Help generating an EDMX on EF6

Hi,

 

Your set up looks correct, but EF cannot load the provider for some reason.

 

What I haven’t tried is using embedded FB with EF6 and EDMX – as the provider with embedded needs some IL emit and the provider is now executed in copyied sandboxed environment it might be an issue. Just guessing. Maybe try (for development) use server.

 

Or maybe you can get this https://github.com/cincuranet/EF6_Firebird/tree/master/EDMX and start from it.

 

-- 

Mgr. Jiří Činčura

Independent IT Specialist

 

From: Brian Liedtke [mailto:li...@fr...] 
Sent: Sunday, May 3, 2015 3:45 AM
To: fir...@li...
Subject: [Firebird-net-provider] Help generating an EDMX on EF6

 

Hey all,

 

I’ve been beating my head against the wall this past week trying to get this solved.

After reading Jiri’s blog on upgrading to EF6 and going through the email archives,

I haven’t found a solution. After trying everything I can think of I am out of ideas.

 

Here what is happening. I am trying to upgrade to EF6. Everything looks good on the install.

I can build and run but when I try to generate an EDMX, I get the following error.

 



 

[Firebird-net-provider] [FB-Tracker] Created: (DNET-606) Show unknown statement in FbBatchExecution

[Jiri C. (JIRA) <tr...@fi...>]

Show unknown statement in FbBatchExecution
------------------------------------------

                 Key: DNET-606
                 URL: http://tracker.firebirdsql.org/browse/DNET-606
             Project: .NET Data provider
          Issue Type: Improvement
          Components: ADO.NET Provider
    Affects Versions: 4.6.2.0
            Reporter: Jiri Cincura
            Assignee: Jiri Cincura


The "throw new ArgumentException("The type of the SQL statement could not be determined.");" could also show the statement.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Re: [Firebird-net-provider] Help generating an EDMX on EF6

[Jiří Č. <ji...@ci...>]

Hi,

Your set up looks correct, but EF cannot load the provider for some reason.

What I haven’t tried is using embedded FB with EF6 and EDMX – as the provider with embedded needs some IL emit and the provider is now executed in copyied sandboxed environment it might be an issue. Just guessing. Maybe try (for development) use server.

Or maybe you can get this https://github.com/cincuranet/EF6_Firebird/tree/master/EDMX and start from it.

--
Mgr. Jiří Činčura
Independent IT Specialist

Re: [Firebird-net-provider] Help generating an EDMX on EF6

[Jiří Č. <ji...@ci...>]

Hi,

Your set up looks correct, but EF cannot load the provider for some reason.

What I haven’t tried is using embedded FB with EF6 and EDMX – as the provider with embedded needs some IL emit and the provider is now executed in copyied sandboxed environment it might be an issue. Just guessing. Maybe try (for development) use server.

Or maybe you can get this https://github.com/cincuranet/EF6_Firebird/tree/master/EDMX and start from it.

--
Mgr. Jiří Činčura
Independent IT Specialist

From: Brian Liedtke [mailto:li...@fr...]
Sent: Sunday, May 3, 2015 3:45 AM
To: fir...@li...
Subject: [Firebird-net-provider] Help generating an EDMX on EF6

Hey all,

I’ve been beating my head against the wall this past week trying to get this solved.
After reading Jiri’s blog on upgrading to EF6 and going through the email archives,
I haven’t found a solution. After trying everything I can think of I am out of ideas.

Here what is happening. I am trying to upgrade to EF6. Everything looks good on the install.
I can build and run but when I try to generate an EDMX, I get the following error.

[image]

Environment is:
OS: Windows 8.1
Visual Studio 2013 Version 12.0.31101.00 Update 4
.Net Provider 4.6.2.0
DDEX 3.0.1.0
.Net Framework 4.5.1
Language C#
Firebird embedded server

And yes, I have removed all bin and obj directories and then do a clean build.
I can then run the application with no problems.

I first removed the old .NET Provider from the GAC and uninstalled it.
I then installed the latest and greatest .NET provider through NuGet in Visual Studio.
install-package EntityFramework
install-package EntityFramework.Firebird
update-package

[image]

The app.config file for the main project is also shown.

I can setup and view a data connection through the server explorer. So I believe I have the DDEX working.

[image]

Since I didn’t get the EDMX to generate. I heeded Jiri’s comment on his blog
http://blog.cincura.net/233472-entity-framework-6-with-firebird-updated/
to make sure that the DDEX is using the same FirebirdClient as the project and
added the new provider to the GAC.

[image]

The machine.config file for both 32 and 64 bit have the following entry.

[image]

I have run both versions of the DbProviderFactories  FirebirdClient Data Provider entry with the same result.

I then checked to see if there were any other versions of FirebirdSql.Data.FirebirdClient on my system.

[image]

Nope. Only the libraries in the GAC and the project’s packages directory.
C:\Windows\Microsoft.NET\assembly\GAC_MSIL\FirebirdSql.Data.FirebirdClient\v4.0_4.6.2.0__3750abcc3150b00c
C:\Users\liedtke\Documents\Visual Studio 2013\Projects\MyGen\packages\FirebirdSql.Data.FirebirdClient.4.6.2.0\lib\net40-client
C:\Users\liedtke\Documents\Visual Studio 2013\Projects\MyGen\packages\FirebirdSql.Data.FirebirdClient.4.6.2.0\lib\net45

The one in the GAC is the net45 library. (See above)

So, either I have missed a something (probably in a config file), or there is a bug. I lean toward the former.

Thanks in advance,
Brian

[Firebird-net-provider] Help generating an EDMX on EF6

[Brian L. <li...@fr...>]

Hey all,

I’ve been beating my head against the wall this past week trying to get this solved.
After reading Jiri’s blog on upgrading to EF6 and going through the email archives,
I haven’t found a solution. After trying everything I can think of I am out of ideas.

Here what is happening. I am trying to upgrade to EF6. Everything looks good on the install.
I can build and run but when I try to generate an EDMX, I get the following error.



Environment is:
OS: Windows 8.1
Visual Studio 2013 Version 12.0.31101.00 Update 4
.Net Provider 4.6.2.0
DDEX 3.0.1.0
.Net Framework 4.5.1
Language C#
Firebird embedded server

And yes, I have removed all bin and obj directories and then do a clean build.
I can then run the application with no problems.

I first removed the old .NET Provider from the GAC and uninstalled it.
I then installed the latest and greatest .NET provider through NuGet in Visual Studio.
install-package EntityFramework
install-package EntityFramework.Firebird
update-package



The app.config file for the main project is also shown.

I can setup and view a data connection through the server explorer. So I believe I have the DDEX working.



Since I didn’t get the EDMX to generate. I heeded Jiri’s comment on his blog
http://blog.cincura.net/233472-entity-framework-6-with-firebird-updated/
to make sure that the DDEX is using the same FirebirdClient as the project and
added the new provider to the GAC.



The machine.config file for both 32 and 64 bit have the following entry.



I have run both versions of the DbProviderFactories  FirebirdClient Data Provider entry with the same result.

I then checked to see if there were any other versions of FirebirdSql.Data.FirebirdClient on my system.



Nope. Only the libraries in the GAC and the project’s packages directory.
C:\Windows\Microsoft.NET\assembly\GAC_MSIL\FirebirdSql.Data.FirebirdClient\v4.0_4.6.2.0__3750abcc3150b00c
C:\Users\liedtke\Documents\Visual Studio 2013\Projects\MyGen\packages\FirebirdSql.Data.FirebirdClient.4.6.2.0\lib\net40-client
C:\Users\liedtke\Documents\Visual Studio 2013\Projects\MyGen\packages\FirebirdSql.Data.FirebirdClient.4.6.2.0\lib\net45

The one in the GAC is the net45 library. (See above)

So, either I have missed a something (probably in a config file), or there is a bug. I lean toward the former.

Thanks in advance,
Brian

[Firebird-net-provider] [FB-Tracker] Created: (DNET-605) NullReferenceException in FirebirdSql.Data.FirebirdClient.FbConnectionInternal.TransactionUpdated()

[Maxim (JIRA) <tr...@fi...>]

NullReferenceException in FirebirdSql.Data.FirebirdClient.FbConnectionInternal.TransactionUpdated()
---------------------------------------------------------------------------------------------------

                 Key: DNET-605
                 URL: http://tracker.firebirdsql.org/browse/DNET-605
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 4.6.2.0
         Environment: IDE: Visual studio communiti 2013. Framework: C# .Net 4.0. Platform: Windows Server 2012 x64. Server: Firebird Embedded 2.5.4 x64.
            Reporter: Maxim
            Assignee: Jiri Cincura


Hi all.
First, sorry by my english, not native laguage.
Have the problem with x64 ADO.NET Provider.
In operations of adding, changing and deleting data in tables the program throwing exception NullReferenceException.

Exception stack:
   at FirebirdSql.Data.FirebirdClient.FbConnectionInternal.TransactionUpdated()
   at FirebirdSql.Data.FirebirdClient.FbTransaction.UpdateTransaction()
   at FirebirdSql.Data.FirebirdClient.FbTransaction.Commit()
   at FirebirdSql.Data.FirebirdClient.FbCommand.CommitImplicitTransaction()
   at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteNonQuery()
   at *myMethod*

For example adding method:
                if (dbConnect.State != ConnectionState.Open)
                    dbConnect.Open();
                FbCommand findClientCom = new FbCommand("Select ID FROM CLIENTS WHERE ID='" + ID.ToString() + "'", dbConnect);
                FbDataAdapter FDA = new FbDataAdapter(findClientCom);
                DataSet ds = new DataSet();
                int count = FDA.Fill(ds);
                if (count > 0)
                {
                    errStr = "This Client is present";
                    return false;
                }
                String insertText = @"INSERT INTO CLIENTS (ID, NET_ID, NAME, LOGIN, PASSWORD, RES_PU, RES_KP, CLUSTER)";
                insertText += @" VALUES(@ID, @NET_ID, @NAME, @LOGIN, @PASSWORD, @RES_PU, @RES_KP, @CLUSTER)";
                FbCommand insertCom = new FbCommand(insertText, dbConnect);
                insertCom.Parameters.AddWithValue("@ID", ID.ToString());
                insertCom.Parameters.AddWithValue("@NET_ID", net_id.ToString());
                insertCom.Parameters.AddWithValue("@NAME", name);
                insertCom.Parameters.AddWithValue("@LOGIN", login);
                insertCom.Parameters.AddWithValue("@PASSWORD", password);
                insertCom.Parameters.AddWithValue("@RES_PU", res_pu);
                insertCom.Parameters.AddWithValue("@RES_KP", res_kp);
                insertCom.Parameters.AddWithValue("@CLUSTER", cluster.ToString());
                insertCom.ExecuteNonQuery();
                errStr = "Client " + VikingServer.ushortToStr(ID) + " was added";
                return true;
            }
            catch (Exception ex)
            {
                errStr = ex.ToString();
                return false;
            }

My methods are working stable on 32 platform. On x64 tables are changing, but after change i have this exception.

Please help me with this problem.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[Firebird-net-provider] [FB-Tracker] Created: (DNET-604) Improvement the time to execute parametred queries

[Pascal (JIRA) <tr...@fi...>]

Improvement the time to execute parametred queries
--------------------------------------------------

                 Key: DNET-604
                 URL: http://tracker.firebirdsql.org/browse/DNET-604
             Project: .NET Data provider
          Issue Type: Improvement
          Components: ADO.NET Provider
    Affects Versions: 4.6.2.0
            Reporter: Pascal
            Assignee: Jiri Cincura


When FirebirdSql.Data.FirebirdClient is used to insert a lot of records in a table using parametred query, it's possible to gain time in the FbCommand.UpdateParameterValues :

Change this code :
  for (int i = 0; i < this.statement.Parameters.Count; i++)
            {
                index = i;

                if (this.namedParameters.Count > 0)
                {
                        index = this.Parameters.IndexOf(this.namedParameters[i]);
                        if (index == -1)
                        {
                            throw new FbException(String.Format("Must declare the variable '{0}'", this.namedParameters[i]));
                        }
                }

by this one :
  for (int i = 0; i < this.statement.Parameters.Count; i++)
            {
                index = i;

                if (this.namedParameters.Count > 0)
                {
                    if (this.Parameters[i].ParameterName != this.namedParameters[i]) // Added by webpac
                    {
                        index = this.Parameters.IndexOf(this.namedParameters[i]);
                        if (index == -1)
                        {
                            throw new FbException(String.Format("Must declare the variable '{0}'", this.namedParameters[i]));
                        }
                    }
                }

And then, if the namedParamers[i] is the same then Parameters[i], it doesn't looking for all nameParameters.

I tried to insert 1000 records with 50 parameters, without the optimisation, it dures 10 seconds and with the optimisation it dures 7 seconds.

Regards,

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[Firebird-net-provider] [FB-Tracker] Created: (DNET-603) operating system directive CreateFile failed

[Wolfgang J. (JIRA) <tr...@fi...>]

operating system directive CreateFile failed
--------------------------------------------

                 Key: DNET-603
                 URL: http://tracker.firebirdsql.org/browse/DNET-603
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 4.5.2.0
            Reporter: Wolfgang Janz
            Assignee: Jiri Cincura


we are recently getting an error when using firebird (filebased-database). Here is the stacktrace:

FirebirdSql.Data.FirebirdClient.FbException: operating system directive CreateFile failed ---> FirebirdSql.Data.Common.IscException: operating system directive CreateFile failed
bei FirebirdSql.Data.Client.Native.FesDatabase.ParseStatusVector(IntPtr[] statusVector) in c:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\src\FirebirdSql.Data.FirebirdClient\Client\Native\FesDatabase.cs:Zeile 420.
bei FirebirdSql.Data.Client.Native.FesDatabase.Attach(DatabaseParameterBuffer dpb, String dataSource, Int32 port, String database) in c:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\src\FirebirdSql.Data.FirebirdClient\Client\Native\FesDatabase.cs:Zeile 291.
bei FirebirdSql.Data.FirebirdClient.FbConnectionInternal.Connect() in c:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbConnectionInternal.cs:Zeile 191.
— Ende der internen Ausnahmestapelüberwachung —
bei FirebirdSql.Data.FirebirdClient.FbConnectionInternal.Connect() in c:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbConnectionInternal.cs:Zeile 196.
bei FirebirdSql.Data.FirebirdClient.FbConnection.Open() in c:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbConnection.cs:Zeile 539.
bei NHibernate.Connection.DriverConnectionProvider.GetConnection()

 Do you have any ideas why this happens? The file is available. The problem just accrues recently without any changes in the source.


-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

[Firebird-net-provider] [FB-Tracker] Created: (DNET-602) Some unit tests for FbTrace

[Jiri C. (JIRA) <tr...@fi...>]

Some unit tests for FbTrace
---------------------------

                 Key: DNET-602
                 URL: http://tracker.firebirdsql.org/browse/DNET-602
             Project: .NET Data provider
          Issue Type: Task
          Components: ADO.NET Provider
    Affects Versions: 4.6.2.0
            Reporter: Jiri Cincura
            Assignee: Jiri Cincura
            Priority: Minor




-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[Firebird-net-provider] ADO.NET provider 4.6.2.0

[Jiří Č. <ji...@ci...>]

More info http://blog.cincura.net/233504-ado-net-provider-4-6-2-0-for-firebird-is-ready/ .

-- 
Mgr. Jiří Činčura
Independent IT Specialist

[Firebird-net-provider] [FB-Tracker] Created: (DNET-601) sanya

[Aleksandr (JIRA) <tr...@fi...>]

sanya
-----

                 Key: DNET-601
                 URL: http://tracker.firebirdsql.org/browse/DNET-601
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 2.6
         Environment: ewewe
            Reporter: Aleksandr
            Assignee: Jiri Cincura


wewe

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[Firebird-net-provider] Scripts parsing

[Jiří Č. <ji...@ci...>]

Hi *,

I’m now working on improving the parser we use in Isql namespace for processing scripts. I tested a lot of scripts I have myself. But that’s for sure only small sample of what’s possible. If you have any script(s) you think use some really “nice” FB statement, if yould be nice to have it shared here. 

Thanks.

-- 
Mgr. Jiří Činčura
Independent IT Specialist

[Firebird-net-provider] Migrations

[Jiří Č. <ji...@ci...>]

Hi guys,

Small update on Migrations for EF. EF had regression in 6.x (https://entityframework.codeplex.com/workitem/2683) which is now fixed. But will be included in 6.2. So I'm holding it. I'll then merge the branch, process PRs and it goes out. I don't want to release it before, because there will be a lot of whining and I just don't want to go there (and if somebody really wants it the branch is public).

-- 
Mgr. Jiří Činčura
Independent IT Specialist

[Firebird-net-provider] [FB-Tracker] Created: (DNET-600) Connection string improperly parsed

[Jiri C. (JIRA) <tr...@fi...>]

Connection string improperly parsed
-----------------------------------

                 Key: DNET-600
                 URL: http://tracker.firebirdsql.org/browse/DNET-600
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 4.6.1.0
            Reporter: Jiri Cincura
            Assignee: Jiri Cincura


Connection string "data source=localhost;port number=20455;initial catalog=;user id=SYSDBA;password=masterkey;pooling=False;packet size=16384;character set=UTF8" is not properly parsed. The initial catalog is mixed with user id.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[Firebird-net-provider] [FB-Tracker] Created: (DNET-599) SetDefaultOptions sets "catalog" instead of "initial catalog"

[Jiri C. (JIRA) <tr...@fi...>]

SetDefaultOptions sets "catalog" instead of "initial catalog"
-------------------------------------------------------------

                 Key: DNET-599
                 URL: http://tracker.firebirdsql.org/browse/DNET-599
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 4.6.1.0
            Reporter: Jiri Cincura
            Assignee: Jiri Cincura
            Priority: Minor


The line "this.options.Add("catalog", DefaultCatalog);" should be "this.options.Add("initial catalog", DefaultCatalog);".

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Re: [Firebird-net-provider] Random crashes in Finalizers

[Геннадий З. <zab...@gm...>]

That's why I think my suggested changes won't impact most users of Dnet
provider.

On Thursday, April 9, 2015, Alexander Muylaert-Gelein <
amu...@ho...> wrote:

> Hi
>
> No, I have to admit I've abondoned EF long time ago.  Too much magic
> behind the scenes for me.  I couldn't predict the behavior of EF and that
> was too hard to manage.  I also don't use embedded.  I have a lot of pooled
> connections on cs and ss and normal stay open long connections on mostly
> ss.  For mapping I prefer LLBLGEN pro, because it is "dumb" and thus does
> what I want and nothing "extra".
>
> thanks
>
> a
>
> > Date: Wed, 8 Apr 2015 18:16:36 +0300
> > From: zab...@gm...
> <javascript:_e(%7B%7D,'cvml','zab...@gm...');>
> > To: fir...@li...
> <javascript:_e(%7B%7D,'cvml','fir...@li...');>
> > Subject: Re: [Firebird-net-provider] Random crashes in Finalizers
> >
> > We use FbConnection in EF. EF does not always calls Dispose on classes
> > provided by the FB Data provider.
> > Alexander, what server do you use? For example, we use embedded
> > configuration in our production. And code of the Fes* namespace
> > doesn't work well in finalizers as we see.
> >
> > On Wed, Apr 8, 2015 at 6:12 PM, Alexander Muylaert-Gelein
> > <amu...@ho...
> <javascript:_e(%7B%7D,'cvml','amu...@ho...');>> wrote:
> > > Hi
> > >
> > > I intensively use firebird and provider... I always use the dispose
> method
> > > (using) and I don't depend on the GC for this. I never had any of the
> > > exceptions refererred to.
> > >
> > > Wouldn't it be better *not* to depend on something horrible as the gc
> for
> > > something as important as your db connectivity? Isn't it better to
> prevent
> > > then to cure?
> > >
> > > thanks
> > >
> > > a
> > >
> > >
> > >> Date: Wed, 8 Apr 2015 18:00:26 +0300
> > >> From: zab...@gm...
> <javascript:_e(%7B%7D,'cvml','zab...@gm...');>
> > >> To: fir...@li...
> <javascript:_e(%7B%7D,'cvml','fir...@li...');>
> > >> Subject: [Firebird-net-provider] Random crashes in Finalizers
> > >
> > >>
> > >> Hello everyone.
> > >>
> > >> I want to discuss changes in finalizers regarding a couple of crashes
> > >> we experience in our FB using.
> > >>
> > >> Issues in tracker:
> > >> http://tracker.firebirdsql.org/browse/DNET-582
> > >> http://tracker.firebirdsql.org/browse/DNET-597
> > >>
> > >> As for 582 we have discussion in PR that crutches it on GitHub:
> > >> https://github.com/cincuranet/FirebirdSql.Data.FirebirdClient/pull/19
> > >>
> > >> As for 597 try...catch doesn't work, it is a more complicated problem.
> > >>
> > >> My suggestion is to refactor Dispose/Finalizer methods to not use
> > >> managed objects which might be already disposed.
> > >>
> > >> Maybe anyone have another thought?
> > >> JIri, what do you think?
> > >>
> > >>
> > >>
> ------------------------------------------------------------------------------
> > >> BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
> > >> Develop your own process in accordance with the BPMN 2 standard
> > >> Learn Process modeling best practices with Bonita BPM through live
> > >> exercises
> > >> http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual-
> > >> event?utm_
> > >> source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF
> > >> _______________________________________________
> > >> Firebird-net-provider mailing list
> > >> Fir...@li...
> <javascript:_e(%7B%7D,'cvml','Fir...@li...');>
> > >> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
> > >
> > >
> ------------------------------------------------------------------------------
> > > BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
> > > Develop your own process in accordance with the BPMN 2 standard
> > > Learn Process modeling best practices with Bonita BPM through live
> exercises
> > > http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual-
> event?utm_
> > > source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF
> > > _______________________________________________
> > > Firebird-net-provider mailing list
> > > Fir...@li...
> <javascript:_e(%7B%7D,'cvml','Fir...@li...');>
> > > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
> > >
> >
> >
> ------------------------------------------------------------------------------
> > BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
> > Develop your own process in accordance with the BPMN 2 standard
> > Learn Process modeling best practices with Bonita BPM through live
> exercises
> > http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual-
> event?utm_
> > source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF
> > _______________________________________________
> > Firebird-net-provider mailing list
> > Fir...@li...
> <javascript:_e(%7B%7D,'cvml','Fir...@li...');>
> > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

[Firebird-net-provider] [FB-Tracker] Created: (DNET-598) DDEX crashes Visual studio

[Sergey I. (JIRA) <tr...@fi...>]

DDEX crashes Visual studio
--------------------------

                 Key: DNET-598
                 URL: http://tracker.firebirdsql.org/browse/DNET-598
             Project: .NET Data provider
          Issue Type: Bug
          Components: DDEX Provider
    Affects Versions: 4.6.1.0
         Environment: Windows 8 Pro, Visual Studio 2013 Pro, Firebird 2.5, Version of firebird .net adapter is 4.6.1.0. DDEX 3.0.1.0
            Reporter: Sergey Isupov
            Assignee: Jiri Cincura
            Priority: Critical


I'm trying to create table adapter wiht the following query:

select i.ID, count(C.ID_LEGAL_PERSON) as CLIENT_COUNT, sum(ceil(a.symbols_count / e.STRING_LENGTH)) as SYMBOLS_COUNT, sum(p.issue_sum) as TOTAL_SUM, count(a.id) as ADS_COUNT
from ISSUE I
inner join ISSUE_ADS IA on I.ID = IA.ID_ISSUE
inner join ADS A on IA.ID_ADS = A.ID
inner join "Client" C on A.C_ID = C.ID_LEGAL_PERSON
inner join PAYMENT P on P.id = ia.id_payment
inner join Edition e on e.ID = i.ID_EDITION
where I.ID = @ID_ISSUE and
      C.ID_SOURCE = @ID_SOURCE and
      e.id = @id_edition
      group by 1

On the last step after clicking "Finish" button Visual Studio crashes and restarts.


-------------------------System logs---------------------------
Application: devenv.exe
Platform version: v4.0.30319
Exception: System.AccessViolationException
Stack:
   в Microsoft.VisualStudio.Data.Interop.IVsDataObjectChangeEvents.OnObjectAdded(System.String, System.Object[])
   в Microsoft.VisualStudio.DataTools.DataServices.DataConnection+DataObjectChangeEvents.OnObjectAdded(Microsoft.VisualStudio.Data.DataObjectChangedEventArgs)
   в Microsoft.VisualStudio.Data.Compatibility.OldObjectChangeEvents.<Microsoft.VisualStudio.Data.Compatibility.IVsDataCompatibleObject<Microsoft.VisualStudio.Data.Services.IVsDataObjectChangeEvents>.set_CompatibleObject>b__1(System.Object, Microsoft.VisualStudio.Data.Services.DataObjectAddedEventArgs)
   в System.EventHandler`1[[System.__Canon, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]].Invoke(System.Object, System.__Canon)
   в Microsoft.VisualStudio.Data.Package.DataObjectChangeEvents.OnObjectAdded(Microsoft.VisualStudio.Data.Services.DataObjectAddedEventArgs)
   в Microsoft.VisualStudio.Data.Package.DataObjectChangeEvents.EndEventGroup(Int32)
   в Microsoft.VisualStudio.Data.Package.DataObjectStore+Tree.RaisePendingObjectChangeEvents()
   в Microsoft.VisualStudio.Data.Package.DataObjectStore.SelectObjects(System.String, System.Object[], System.String[], System.String, System.String, Boolean)
   в Microsoft.VisualStudio.Data.Package.DataMappedObjectSelector.SelectMappedObjects[[System.__Canon, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]](System.String, System.Object[], Boolean)
   в Microsoft.VisualStudio.Data.Package.DataMappedObjectSelector.SelectMappedObjects[[System.__Canon, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]](System.Object[], Boolean)
   в Microsoft.VisualStudio.DataTools.MetaData.Generic.MetaDataEnumerator.Microsoft.VisualStudio.DataTools.MetaData.Interop.IMetaDataEnumerator.EnumerateTables(System.String, System.String, System.String, Boolean)
   в Microsoft.VisualStudio.DataTools.Interop.ICQryAuto.set_NewSQLText(System.String)
   в Microsoft.VSDesigner.Data.VS.QueryEditor.set_CommandText(System.String)
   в Microsoft.VSDesigner.Data.VS.QueryEditor..ctor(Microsoft.VSDesigner.Data.ConfigurationContext, System.String)
   в Microsoft.VSDesigner.DataSource.DbSource.GetDataSource(Microsoft.VSDesigner.DataSource.DbSourceCommand, Microsoft.VSDesigner.Data.ConfigurationContext)
   в Microsoft.VSDesigner.DataSource.DbSource.UpdateDbObjectInfo()
   в Microsoft.VSDesigner.DataSource.DbSource.get_DbObjectType()
   в Microsoft.VSDesigner.DataSource.DesignDataSource.Get1TableBasedDesignTables()
   в Microsoft.VSDesigner.DataSource.Designer.DataSourceRootDesigner.GetRelatedRelationsFromDb(Microsoft.VSDesigner.DataSource.DesignTable)
   в Microsoft.VSDesigner.DataSource.Designer.DataSourceRootDesigner.ExecCmdAddRadTable()
   в Microsoft.VSDesigner.DataSource.Designer.DataSourceRootDesigner.OnCmdAddRadTable(System.Object, System.EventArgs)
   в System.ComponentModel.Design.MenuCommand.Invoke()
   в Microsoft.VSDesigner.DesignerFramework.VSMenuCommand.Invoke()
   в System.ComponentModel.Design.MenuCommand.Invoke(System.Object)
   в Microsoft.VisualStudio.Shell.OleMenuCommandService.Microsoft.VisualStudio.OLE.Interop.IOleCommandTarget.Exec(System.Guid ByRef, UInt32, UInt32, IntPtr, IntPtr)
   в Microsoft.VisualStudio.Shell.Interop.IVsUIDataSource.Invoke(System.String, System.Object, System.Object ByRef)
   в Microsoft.Internal.VisualStudio.PlatformUI.DataSource.Invoke(System.String, System.Object, System.Object ByRef)
   в Microsoft.VisualStudio.PlatformUI.VsCommand.Execute(System.Object)
   в MS.Internal.Commands.CommandHelpers.CriticalExecuteCommandSource(System.Windows.Input.ICommandSource, Boolean)
   в System.Windows.Controls.MenuItem.InvokeClickAfterRender(System.Object)
   в System.Windows.Threading.ExceptionWrapper.InternalRealCall(System.Delegate, System.Object, Int32)
   в MS.Internal.Threading.ExceptionFilterHelper.TryCatchWhen(System.Object, System.Delegate, System.Object, Int32, System.Delegate)
   в System.Windows.Threading.DispatcherOperation.InvokeImpl()
   в System.Windows.Threading.DispatcherOperation.InvokeInSecurityContext(System.Object)
   в System.Threading.ExecutionContext.RunInternal(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)
   в System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)
   в System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object)
   в System.Windows.Threading.DispatcherOperation.Invoke()
   в System.Windows.Threading.Dispatcher.ProcessQueue()
   в System.Windows.Threading.Dispatcher.WndProcHook(IntPtr, Int32, IntPtr, IntPtr, Boolean ByRef)
   в MS.Win32.HwndWrapper.WndProc(IntPtr, Int32, IntPtr, IntPtr, Boolean ByRef)
   в MS.Win32.HwndSubclass.DispatcherCallbackOperation(System.Object)
   в System.Windows.Threading.ExceptionWrapper.InternalRealCall(System.Delegate, System.Object, Int32)
   в MS.Internal.Threading.ExceptionFilterHelper.TryCatchWhen(System.Object, System.Delegate, System.Object, Int32, System.Delegate)
   в System.Windows.Threading.Dispatcher.LegacyInvokeImpl(System.Windows.Threading.DispatcherPriority, System.TimeSpan, System.Delegate, System.Object, Int32)
   в MS.Win32.HwndSubclass.SubclassWndProc(IntPtr, Int32, IntPtr, IntPtr)
   в Microsoft.VisualStudio.PlatformUI.NativeMethods.DispatchMessage(System.Windows.Interop.MSG ByRef)
   в Microsoft.VisualStudio.Platform.WindowManagement.WindowManagerService.<PushMessageLoopOnContextMenuTrackingComponent>b__6b(System.Object, Microsoft.VisualStudio.PlatformUI.OleComponentSupport.PreTranslateMessageEventArgs)
   в Microsoft.VisualStudio.PlatformUI.OleComponentSupport.OleComponent.FPreTranslateMessageCore(Microsoft.VisualStudio.OLE.Interop.MSG[])
   в Microsoft.VisualStudio.PlatformUI.OleComponentSupport.OleComponent+<>c__DisplayClasse.<Microsoft.VisualStudio.OLE.Interop.IOleComponent.FPreTranslateMessage>b__d()
   в Microsoft.VisualStudio.PlatformUI.OleComponentSupport.OleComponent.CallAndReturnOnException(System.Func`1<Int32>, Int32)
   в Microsoft.VisualStudio.PlatformUI.OleComponentSupport.OleComponent.Microsoft.VisualStudio.OLE.Interop.IOleComponent.FPreTranslateMessage(Microsoft.VisualStudio.OLE.Interop.MSG[])
   в Microsoft.VisualStudio.OLE.Interop.IOleComponentManager.FPushMessageLoop(UInt32, UInt32, IntPtr)
   в Microsoft.VisualStudio.Platform.WindowManagement.WindowManagerService.PushMessageLoopOnContextMenuTrackingComponent()
   в Microsoft.VisualStudio.Shell.Interop.IOleComponentUIManager.ShowContextMenu(UInt32, System.Guid ByRef, Int32, Microsoft.VisualStudio.Shell.Interop.POINTS[], Microsoft.VisualStudio.OLE.Interop.IOleCommandTarget)
   в Microsoft.VisualStudio.Shell.OleMenuCommandService.ShowContextMenu(System.ComponentModel.Design.CommandID, Int32, Int32)
   в Microsoft.VSDesigner.DesignerFramework.VSRootDesigner.OnContextMenu(Int32, Int32)
   в Microsoft.VSDesigner.DesignerFramework.VSRootDesigner.WmContextMenu(System.Windows.Forms.Message ByRef)
   в Microsoft.VSDesigner.DesignerFramework.VSRootDesigner.WndProc(System.Windows.Forms.Message ByRef)
   в Microsoft.VSDesigner.DesignerFramework.VSRootDesigner+VSRootDesignerWindowTarget.OnMessage(System.Windows.Forms.Message ByRef)
   в System.Windows.Forms.Control+ControlNativeWindow.WndProc(System.Windows.Forms.Message ByRef)
   в System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr, Int32, IntPtr, IntPtr)
   в System.Windows.Forms.UnsafeNativeMethods.CallWindowProc(IntPtr, IntPtr, Int32, IntPtr, IntPtr)
   в System.Windows.Forms.NativeWindow.DefWndProc(System.Windows.Forms.Message ByRef)
   в System.Windows.Forms.Control.DefWndProc(System.Windows.Forms.Message ByRef)
   в System.Windows.Forms.Control.WmMouseUp(System.Windows.Forms.Message ByRef, System.Windows.Forms.MouseButtons, Int32)
   в System.Windows.Forms.Control.WndProc(System.Windows.Forms.Message ByRef)
   в System.Windows.Forms.ScrollableControl.WndProc(System.Windows.Forms.Message ByRef)
   в System.Windows.Forms.ContainerControl.WndProc(System.Windows.Forms.Message ByRef)
   в System.Windows.Forms.UserControl.WndProc(System.Windows.Forms.Message ByRef)
   в System.Windows.Forms.Control+ControlNativeWindow.OnMessage(System.Windows.Forms.Message ByRef)
   в Microsoft.VSDesigner.DesignerFramework.VSRootDesigner+VSRootDesignerWindowTarget.DefWndProc(System.Windows.Forms.Message ByRef)
   в Microsoft.VSDesigner.DesignerFramework.VSRootDesigner.WndProc(System.Windows.Forms.Message ByRef)
   в Microsoft.VSDesigner.DesignerFramework.VSRootDesigner+VSRootDesignerWindowTarget.OnMessage(System.Windows.Forms.Message ByRef)
   в System.Windows.Forms.Control+ControlNativeWindow.WndProc(System.Windows.Forms.Message ByRef)
   в System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr, Int32, IntPtr, IntPtr)


-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

Re: [Firebird-net-provider] Random crashes in Finalizers

[Alexander Muylaert-G. <amu...@ho...>]

Hi
No, I have to admit I've abondoned EF long time ago.  Too much magic behind the scenes for me.  I couldn't predict the behavior of EF and that was too hard to manage.  I also don't use embedded.  I have a lot of pooled connections on cs and ss and normal stay open long connections on mostly ss.  For mapping I prefer LLBLGEN pro, because it is "dumb" and thus does what I want and nothing "extra".  
thanks
a

> Date: Wed, 8 Apr 2015 18:16:36 +0300
> From: zab...@gm...
> To: fir...@li...
> Subject: Re: [Firebird-net-provider] Random crashes in Finalizers
> 
> We use FbConnection in EF. EF does not always calls Dispose on classes
> provided by the FB Data provider.
> Alexander, what server do you use? For example, we use embedded
> configuration in our production. And code of the Fes* namespace
> doesn't work well in finalizers as we see.
> 
> On Wed, Apr 8, 2015 at 6:12 PM, Alexander Muylaert-Gelein
> <amu...@ho...> wrote:
> > Hi
> >
> > I intensively use firebird and provider... I always use the dispose method
> > (using) and I don't depend on the GC for this.  I never had any of the
> > exceptions refererred to.
> >
> > Wouldn't it be better *not* to depend on something horrible as the gc for
> > something as important as your db connectivity?  Isn't it better to prevent
> > then to cure?
> >
> > thanks
> >
> > a
> >
> >
> >> Date: Wed, 8 Apr 2015 18:00:26 +0300
> >> From: zab...@gm...
> >> To: fir...@li...
> >> Subject: [Firebird-net-provider] Random crashes in Finalizers
> >
> >>
> >> Hello everyone.
> >>
> >> I want to discuss changes in finalizers regarding a couple of crashes
> >> we experience in our FB using.
> >>
> >> Issues in tracker:
> >> http://tracker.firebirdsql.org/browse/DNET-582
> >> http://tracker.firebirdsql.org/browse/DNET-597
> >>
> >> As for 582 we have discussion in PR that crutches it on GitHub:
> >> https://github.com/cincuranet/FirebirdSql.Data.FirebirdClient/pull/19
> >>
> >> As for 597 try...catch doesn't work, it is a more complicated problem.
> >>
> >> My suggestion is to refactor Dispose/Finalizer methods to not use
> >> managed objects which might be already disposed.
> >>
> >> Maybe anyone have another thought?
> >> JIri, what do you think?
> >>
> >>
> >> ------------------------------------------------------------------------------
> >> BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
> >> Develop your own process in accordance with the BPMN 2 standard
> >> Learn Process modeling best practices with Bonita BPM through live
> >> exercises
> >> http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual-
> >> event?utm_
> >> source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF
> >> _______________________________________________
> >> Firebird-net-provider mailing list
> >> Fir...@li...
> >> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
> >
> > ------------------------------------------------------------------------------
> > BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
> > Develop your own process in accordance with the BPMN 2 standard
> > Learn Process modeling best practices with Bonita BPM through live exercises
> > http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
> > source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF
> > _______________________________________________
> > Firebird-net-provider mailing list
> > Fir...@li...
> > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
> >
> 
> ------------------------------------------------------------------------------
> BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
> Develop your own process in accordance with the BPMN 2 standard
> Learn Process modeling best practices with Bonita BPM through live exercises
> http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
> source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
 		 	   		  

Re: [Firebird-net-provider] Random crashes in Finalizers

[Геннадий З. <zab...@gm...>]

We use FbConnection in EF. EF does not always calls Dispose on classes
provided by the FB Data provider.
Alexander, what server do you use? For example, we use embedded
configuration in our production. And code of the Fes* namespace
doesn't work well in finalizers as we see.

On Wed, Apr 8, 2015 at 6:12 PM, Alexander Muylaert-Gelein
<amu...@ho...> wrote:
> Hi
>
> I intensively use firebird and provider... I always use the dispose method
> (using) and I don't depend on the GC for this.  I never had any of the
> exceptions refererred to.
>
> Wouldn't it be better *not* to depend on something horrible as the gc for
> something as important as your db connectivity?  Isn't it better to prevent
> then to cure?
>
> thanks
>
> a
>
>
>> Date: Wed, 8 Apr 2015 18:00:26 +0300
>> From: zab...@gm...
>> To: fir...@li...
>> Subject: [Firebird-net-provider] Random crashes in Finalizers
>
>>
>> Hello everyone.
>>
>> I want to discuss changes in finalizers regarding a couple of crashes
>> we experience in our FB using.
>>
>> Issues in tracker:
>> http://tracker.firebirdsql.org/browse/DNET-582
>> http://tracker.firebirdsql.org/browse/DNET-597
>>
>> As for 582 we have discussion in PR that crutches it on GitHub:
>> https://github.com/cincuranet/FirebirdSql.Data.FirebirdClient/pull/19
>>
>> As for 597 try...catch doesn't work, it is a more complicated problem.
>>
>> My suggestion is to refactor Dispose/Finalizer methods to not use
>> managed objects which might be already disposed.
>>
>> Maybe anyone have another thought?
>> JIri, what do you think?
>>
>>
>> ------------------------------------------------------------------------------
>> BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
>> Develop your own process in accordance with the BPMN 2 standard
>> Learn Process modeling best practices with Bonita BPM through live
>> exercises
>> http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual-
>> event?utm_
>> source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF
>> _______________________________________________
>> Firebird-net-provider mailing list
>> Fir...@li...
>> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
> ------------------------------------------------------------------------------
> BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
> Develop your own process in accordance with the BPMN 2 standard
> Learn Process modeling best practices with Bonita BPM through live exercises
> http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
> source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

Re: [Firebird-net-provider] Random crashes in Finalizers

[Alexander Muylaert-G. <amu...@ho...>]

Hi
I intensively use firebird and provider... I always use the dispose method (using) and I don't depend on the GC for this.  I never had any of the exceptions refererred to.  
Wouldn't it be better *not* to depend on something horrible as the gc for something as important as your db connectivity?  Isn't it better to prevent then to cure?
thanks
a

> Date: Wed, 8 Apr 2015 18:00:26 +0300
> From: zab...@gm...
> To: fir...@li...
> Subject: [Firebird-net-provider] Random crashes in Finalizers
> 
> Hello everyone.
> 
> I want to discuss changes in finalizers regarding a couple of crashes
> we experience in our FB using.
> 
> Issues in tracker:
> http://tracker.firebirdsql.org/browse/DNET-582
> http://tracker.firebirdsql.org/browse/DNET-597
> 
> As for 582 we have discussion in PR that crutches it on GitHub:
> https://github.com/cincuranet/FirebirdSql.Data.FirebirdClient/pull/19
> 
> As for 597 try...catch doesn't work, it is a more complicated problem.
> 
> My suggestion is to refactor Dispose/Finalizer methods to not use
> managed objects which might be already disposed.
> 
> Maybe anyone have another thought?
> JIri, what do you think?
> 
> ------------------------------------------------------------------------------
> BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
> Develop your own process in accordance with the BPMN 2 standard
> Learn Process modeling best practices with Bonita BPM through live exercises
> http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
> source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
 		 	   		  

[Firebird-net-provider] Random crashes in Finalizers

[Геннадий З. <zab...@gm...>]

Hello everyone.

I want to discuss changes in finalizers regarding a couple of crashes
we experience in our FB using.

Issues in tracker:
http://tracker.firebirdsql.org/browse/DNET-582
http://tracker.firebirdsql.org/browse/DNET-597

As for 582 we have discussion in PR that crutches it on GitHub:
https://github.com/cincuranet/FirebirdSql.Data.FirebirdClient/pull/19

As for 597 try...catch doesn't work, it is a more complicated problem.

My suggestion is to refactor Dispose/Finalizer methods to not use
managed objects which might be already disposed.

Maybe anyone have another thought?
JIri, what do you think?