Erik Jan Meijer (JIRA | 17 Apr 17:11 2014

[FB-Tracker] Created: (DNET-552) ConnectionLifetime with value 0 (zero) is no longer treated as infinite but really as zero.

ConnectionLifetime with value 0 (zero) is no longer treated as infinite but really as zero.
-------------------------------------------------------------------------------------------

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

In
NETProvider\NETProvider\source\FirebirdSql\Data\FirebirdClient\FbConnectionPoolManager.cs
, Pool.CleanupPool() does the following:

 var keep = available.Where(x => x.Created.AddSeconds(_connectionString.ConnectionLifeTime) > now).ToArray();

This does not take into account the default(!) value of zero for _connectionString.ConnectionLifeTime.

The effect is that connections are closed and recreated for every request.
You can see TCP-connections closing and new ones reopening by using TcpView by SysInternals.

--

-- 
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

(Continue reading)

Joseph Martinez | 15 Apr 20:05 2014

Entity Framework woes (cannot update model from database)

When I try to do "Update model from database", I get the following error:

An exception of type 'Microsoft.VSDesigner.Data.Local.ConnectionStringConverterServiceException' occurred while attempting to update from the database. The exception message is: ''.

I searched this error, and I find a reply from Jiri from about a year ago that says, "DDEX not installed correctly."

I then performed the following steps:
1) Uninstalled the Firebird DDEX provider and the Firebird ADO.Net provider
2) Replaced machine.config in the following folders with the machine.config.default file:
C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config
C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config
3) Reinstalled ADO.NET provider from NETProvider-4.1.0.0.msi
4) Reinstalled DDEX provider from DDEXProvider-3.0.1.0.msi

However, I still get the same error.  I can open the .EDMX file and view the entities, but I cannot update the model from the database.

Here is my connection string:
metadata=res://*/TRS11Model.csdl|res://*/TRS11Model.ssdl|res://*/TRS11Model.msl;provider=FirebirdSql.Data.FirebirdClient;provider connection string='initial catalog="C:\Program Files (x86)\TRS11\Data\DATA1100.FDB";user id=sysdba;password=masterkey;data source=localhost'

The database path, userid, and password are all correct.

Does this still sound like an issue with DDEX not being installed correctly?
If so, what else should I do to install it correctly, if my above steps are not sufficient.

-Joe
------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/NeoTech
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Jiri Cincura | 15 Apr 11:51 2014
Picon

ADO.NET provider for Firebird 4.1.5.0 is ready

ADO.NET provider for Firebird 4.1.5.0 is ready:
http://blog.cincura.net/233450-ado-net-provider-for-firebird-4-1-5-0-is-ready/

--

-- 
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com

------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/NeoTech
Jiri Cincura (JIRA | 15 Apr 10:19 2014

[FB-Tracker] Created: (DNET-551) Fix sql generating for table with only one column

Fix sql generating for table with only one column
-------------------------------------------------

                 Key: DNET-551
                 URL: http://tracker.firebirdsql.org/browse/DNET-551
             Project: .NET Data provider
          Issue Type: Improvement
          Components: Entity Framework support
    Affects Versions: 4.1.0.0
            Reporter: Jiri Cincura
            Assignee: Jiri Cincura
            Priority: Minor

https://github.com/cincuranet/NETProvider/pull/3

--

-- 
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

------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/NeoTech
André Knappstein | 8 Apr 14:33 2014
Picon

Mystery 3.0.2 revisited

I don't see my posting from this afternoon, yet.

Nevertheless, don't bother, please.
Maybe you know the feeling that testing something strange for days and
days  won't  bring you further, you ask someone for help  - like I did
with  this  list  this afternoon - and then you suddenly have the idea
for one more test and finally see clear :-)

I  was  me,  after  all,  nothing  wrong - of course - with FBProvider
handling transactions.

For   some   reason   I   had  changed  an outer to an inner join in a
relevant place and the record I thought missing was not fulfilling the
condition on the first select, but on the second.

regards,
André

------------------------------------------------------------------------------
Put Bad Developers to Shame
Dominate Development with Jenkins Continuous Integration
Continuously Automate Build, Test & Deployment 
Start a new project now. Try Jenkins in the cloud.
http://p.sf.net/sfu/13600_Cloudbees
André Knappstein | 8 Apr 13:05 2014
Picon

commit mystery 3.0.2

Hi there,

I  nearly  broke  my  head  around  some  mysterious  behaviour  of my
application, and right now I don't know if this is all natural and WAD
or maybe if there was a bug in 3.0.2 or maybe still is.

First  I'm gonna give a brief description and maybe one of the experts
here  can  tell  me  what  I am probably understanding wrong about how
FBProvider handles transactions.

1.)
Transaction  T1  saves  a  new  record  to  the database, then commits
(certified!).

2.)
T2 selects records from the database, but does not get the
recently saved record. T2 commits.

3.)
T3  is really doing the same as T2 (because I am only calling the very
same method!), but now the missing record is selected.

I am handling transactions like this:

  t = connXY.BeginTransaction();
  ...
  ...
  // do the stuff
  ...
  ...
  t.commit();
  t = null;

All transactions are using the same connection object.
Isolation   level   is   "read   committed";   using  all  the default
values.

I  would have expected T2 to select the record that has been committed
to the database by T1. And I am certainly surprised that simply "asking
the database again" will then yield the record.

T1 most definitely is committed. Of course I am using try/catch and in
addition I checked with other software using "read committed" and they
can already select the new record.

Where  is  my  misconception  in this story? I plan to implement a lot
more  "live"  updates  using  events  and  would like to get immediate
selecting of freshly inserted records working.

mit freundlichen Grüßen,

André Knappstein
EDV und Controlling
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
beta Eigenheim- und Grundstücksverwertungsgesellschaft mbH
Hafenweg 4
59192 Bergkamen-Rünthe

Telefon: +49 2389 9240 140
Telefax: +49 2389 9240 150
e-mail:  knappstein@...

Amtsgericht Hamm Nr. B 420
Geschäftsführer: Achim Krähling, Dirk Salewski und Matthias Steinhaus

USt-IDNr.: DE 125215402

------------------------------------------------------------------------------
Put Bad Developers to Shame
Dominate Development with Jenkins Continuous Integration
Continuously Automate Build, Test & Deployment 
Start a new project now. Try Jenkins in the cloud.
http://p.sf.net/sfu/13600_Cloudbees
Hennadii (JIRA | 3 Apr 09:26 2014

[FB-Tracker] Created: (DNET-550) NotSupportedException occurs when using ServerType embedded

NotSupportedException occurs when using ServerType embedded
-----------------------------------------------------------

                 Key: DNET-550
                 URL: http://tracker.firebirdsql.org/browse/DNET-550
             Project: .NET Data provider
          Issue Type: Bug
    Affects Versions: 4.1.0.0
            Reporter: Hennadii
            Assignee: Jiri Cincura

Exception throwed from Common.DbValue.GetBytes
public byte[] GetBytes()
{
...
switch (this.Field.DbDataType)
...
default: throw new NotSupportedException("Unknown data type");

with this.Field.DbDataType equal to DbDataType.Null

--

-- 
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

------------------------------------------------------------------------------
Joël Gijbels | 26 Mar 14:46 2014
Picon

Re: Question about the Firebird .Net Client forEF6.

Hi Firebird-net-provider,

 

Still no solution, has anyone an idea how to fix this? I have the idea, EF still finds traces of the old version of the Firebird .Net provider… What I also saw is that the Firebird .Net provider EF6 is only on NuGet and not as an install, so Windows has no notice of the new driver.

 

Kind regards,

 

Joël Gijbels.

 

Van: Joël Gijbels
Verzonden: woensdag 19 maart 2014 9:29
Aan: 'mcastro <at> mcsoft.com.br'; firebird-net-provider <at> lists.sourceforge.net
Onderwerp: RE: [Firebird-net-provider] Question about the Firebird .Net Client forEF6.

 

HI Marco,

 

Thanks for your response. I forgot to mention that in my initial quest. Yes, I did do that. Here is the content of my App.config fil:

 

<?xml version="1.0" encoding="utf-8"?>

<configuration>

  <configSections>

    <!-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID=237468 -->

    <section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />

  </configSections>

  <system.data>

    <DbProviderFactories>

      <add name="FirebirdClient Data Provider" invariant="FirebirdSql.Data.FirebirdClient" description=".NET Framework Data Provider for Firebird" type="FirebirdSql.Data.FirebirdClient.FirebirdClientFactory, FirebirdSql.Data.FirebirdClient" />

    </DbProviderFactories>

  </system.data>

  <entityFramework>

    <defaultConnectionFactory type="System.Data.Entity.Infrastructure.LocalDbConnectionFactory, EntityFramework">

      <parameters>

        <parameter value="v11.0" />

      </parameters>

    </defaultConnectionFactory>

    <providers>

      <provider invariantName="FirebirdSql.Data.FirebirdClient" type="FirebirdSql.Data.FirebirdClient.FbProviderServices, FirebirdSql.Data.FirebirdClient" />

      <provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" />

    </providers>

  </entityFramework>

</configuration>

 

Kind regards,

 

Joël Gijbels

 

Van: Marco Castro - McSoft [mailto:mcastro <at> mcsoft.com.br]
Verzonden: dinsdag 18 maart 2014 19:19
Aan: Joël Gijbels;
firebird-net-provider <at> lists.sourceforge.net
Onderwerp: RE: [Firebird-net-provider] Question about the Firebird .Net Client forEF6.

 

 


Hello Joel,

Did you configured your App.config file with this provider configuration?

<configuration>
  <configSections>
    <section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />
    <!-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID=237468 -->
  </configSections>

  <startup>
    <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.5.1" />
  </startup>
  <system.data>
    <DbProviderFactories>
      <add name="FirebirdClient Data Provider" invariant="FirebirdSql.Data.FirebirdClient" description=".NET Framework Data Provider for Firebird" type="FirebirdSql.Data.FirebirdClient.FirebirdClientFactory, FirebirdSql.Data.FirebirdClient" />
    </DbProviderFactories>
  </system.data>
  <entityFramework>
    <defaultConnectionFactory type="System.Data.Entity.Infrastructure.LocalDbConnectionFactory, EntityFramework">
      <parameters>
        <parameter value="v11.0" />
      </parameters>
    </defaultConnectionFactory>
    <providers>
      <provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" />
      <provider invariantName="FirebirdSql.Data.FirebirdClient" type="FirebirdSql.Data.FirebirdClient.FbProviderServices, FirebirdSql.Data.FirebirdClient" />
    </providers>
  </entityFramework>
</configuration>

          Best  regards,

Marco Aurelio Castro
Director
McSoft



----- Original Message -----
From: Joël Gijbels [
mailto:J.Gijbels <at> farmad.be]
To:
firebird-net-provider <at> lists.sourceforge.net
Sent: Tue, 18 Mar 2014 11:00:26 +0000
Subject: [Firebird-net-provider] Question about the Firebird .Net Client forEF6.

Hi Firebird-net-provider,

 

As a .Net developer I have been asked to connect to a Firebird database via Entity Framework. I installed both the Data Provider and the DDEX.

 

 

Via NuGet I added Entity Framework 6.0.2 and the Firebird ADO.NET Data Provider (Entity Framework 6).

 

 

So far so good, I managed to open the ADO.Net Entity Data Model wizard, select the correct database for a database first approach. But then I get this confusing error according to the version of the database provider I have installed.

 

 

Any help would be appreciated. If you need more info, please let me know.

 

Thanks in advance for your advice.

 

Kind regards,

 

Joël Gijbels.

 

 

------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/13534_NeoTech
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Eric FE | 25 Mar 22:38 2014

DDEX not working on VS2013

Hello,

 

I’m trying to use the DDEX Provider Version 3.0.1 in VS2013, but it’s not working.

 

When I change any values in the connection dialog, the dialog disappears.

 

Has anyone got the DDEX provider working in VS2013?

 

 

I’m in the process of adding Firebird support to my ORM.

 

Thanks,

 

 

Eric Schneider

 

Frozen Elephant Inc.

739 N. Thompson Dr. #207

Madison, WI

53704

 

------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/13534_NeoTech
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Lukáš Vykydal (JIRA | 24 Mar 22:47 2014

[FB-Tracker] Created: (DNET-549) When you change culture of application while it's connected to firebird database, the connection won't be returned into pool.

When you change culture of application while it's connected to firebird database, the connection won't be
returned into pool.
-----------------------------------------------------------------------------------------------------------------------------

                 Key: DNET-549
                 URL: http://tracker.firebirdsql.org/browse/DNET-549
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider, ASP.NET Providers
    Affects Versions: 4.1.0.0
         Environment:  Fb .NET Provider version 4.1.0.0 and .NET FW version: 4.0.30319 and ASP .NET
4.0.30319.34009. OS: Windows 8.1 64bit
            Reporter: Lukáš Vykydal
            Assignee: Jiri Cincura

i found interesting bug. When you change culture of application while it's connected to firebird
database, the connection won't be returned into pool.

Here is example code (from Page_Load) :
       this.Culture = "en-GB";
        FbConnection fbc = new
FbConnection("Database=d:/database.fdb;DataSource=localhost;User=sysdba;Password=masterkey;Dialect=1;Charset=UTF8;Pooling=true;MinPoolSize=0;MaxPoolSize=10;Connection lifetime=30;");
        fbc.Open();

        this.Culture = "cs-CZ";

//        this.Culture = "en-GB";    When you change it back everything will be OK

        fbc.Close();

this code will fail after 10 calls on "System.InvalidOperationException: Connection pool is full". Its
thrown from "FirebirdSql.Data.FirebirdClient.Pool.CreateNewConnectionIfPossibleImpl".

After quick look into the source code i think that problem is in generating NormalizedConnectionString
(FbConnectgionString.cs:233). This code is probably culture dependent.

I'm using  Fb .NET Provider version 4.1.0.0 and .NET FW version: 4.0.30319 and ASP .NET 4.0.30319.34009

--

-- 
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

------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/13534_NeoTech
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Lukáš Vykydal | 21 Mar 10:18 2014
Picon

Connection close after culture change

Good morning,

i found interesting bug. When you change culture of application while 
it's connected to firebird database, the connection won't be returned 
into pool.

Here is example code (from Page_Load) :
        this.Culture = "en-GB";
         FbConnection fbc = new

FbConnection("Database=d:/database.fdb;DataSource=localhost;User=sysdba;Password=masterkey;Dialect=1;Charset=UTF8;Pooling=true;MinPoolSize=0;MaxPoolSize=10;Connection 
lifetime=30;");
         fbc.Open();

         this.Culture = "cs-CZ";

//        this.Culture = "en-GB";    When you change it back everything 
will be OK

         fbc.Close();

this code will fail after 10 calls on "System.InvalidOperationException: 
Connection pool is full". Its thrown from 
"FirebirdSql.Data.FirebirdClient.Pool.CreateNewConnectionIfPossibleImpl".

After quick look into the source code i think that problem is in 
generating NormalizedConnectionString (FbConnectgionString.cs:233). This 
code is probably culture dependent.

I'm using  Fb .NET Provider version 4.1.0.0 and .NET FW version: 
4.0.30319 and ASP .NET 4.0.30319.34009

Thank you for answer

Lukáš Vykydal

------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/13534_NeoTech

Gmane