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

[Firebird-net-provider] Stored Procedure's Exception Not Thrown by Update of FbDataAdapter

[LtColRDSChauhan <rds...@gm...>]

Hello,

1.  For a batch update i'm asigning stored procedures to the insert /
udpate / delete commands of FbDataAdapter object.

2.  The Update call of FbDataAdapter object, does not throw FB exception
thrown by my stored procedure.
Instead, such rows are left unchanged while the rest are still updated.

Thanks and Regards,
Lt Col (Retd) Rajiv D.S. Chauhan

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

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

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

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

[Firebird-net-provider] [FB-Tracker] Created: (DNET-574) Handle DbProviderFactories in FirebirdSql.Data.FirebirdClient NuGet

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

Handle DbProviderFactories in FirebirdSql.Data.FirebirdClient NuGet
-------------------------------------------------------------------

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


Handle DbProviderFactories in FirebirdSql.Data.FirebirdClient NuGet

-- 
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] EF Migrations

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

I've asked about mutual exclusive of schemes.
If schemes can be applied in one model you can use custom attributes on
primary keys.
If schemes are mutual exclusive, you can use custom extension method for
model builder.

2014-11-09 13:12 GMT+02:00 Jiří Činčura <ji...@ci...>:

> > The update script should not be changed by users generated by migration.
> Or maybe I don't know something?
>
> Not exactly. There's assumption that the script will not be mostly
> changed. But some DBA in some "classic" environments might change it.
>
> > We need to inject some implementation through dependency injection, or
> make it configurable. EF have some built-in dependency injector. Does
> community schemes mentioned above are mutual exclusive for database
> instance?
>
> Exactly. I'm currently planning to investigate whether EF allows adding
> 3rd party services/interfaces to be resolved. And how clean that looks
> like. Maybe after nailing the SQL generation.
>
> --
> Mgr. Jiří Činčura
> Independent IT Specialist
>
> ------------------------------------------------------------------------------
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

Re: [Firebird-net-provider] EF Migrations

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

> The update script should not be changed by users generated by migration. Or maybe I don't know something?

Not exactly. There's assumption that the script will not be mostly changed. But some DBA in some "classic" environments might change it.

> We need to inject some implementation through dependency injection, or make it configurable. EF have some built-in dependency injector. Does community schemes mentioned above are mutual exclusive for database instance?

Exactly. I'm currently planning to investigate whether EF allows adding 3rd party services/interfaces to be resolved. And how clean that looks like. Maybe after nailing the SQL generation.

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

Re: [Firebird-net-provider] EF Migrations

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

> It kind of breaks the notion of altering the table/column with one
command. It's a bit of magic with system tables and people might get
confused or break it by chaning the script.
The update script should not be changed by users generated by migration. Or
maybe I don't know something?
> MSSQL has identities. Given that there are at least two widely used
schemes in Firebird community and nothing is in the engine itself, I'd like
to keep this open, with some default implementation.
We need to inject some implementation through dependency injection, or make
it configurable. EF have some built-in dependency injector. Does community
schemes mentioned above are mutual exclusive for database instance?

2014-11-08 18:36 GMT+02:00 Jiří Činčura <ji...@ci...>:

> > 1. What problem in Execute block?
>
> It kind of breaks the notion of altering the table/column with one
> command. It's a bit of magic with system tables and people might get
> confused or break it by chaning the script.
>
> > 2. My opinion for "Identity" is to copy MSSQL behavior. Create generator
> for each primary key + trigger before insert.
>
> MSSQL has identities. Given that there are at least two widely used
> schemes in Firebird community and nothing is in the engine itself, I'd like
> to keep this open, with some default implementation.
>
> --
> Mgr. Jiří Činčura
> Independent IT Specialist
>
>
>
> ------------------------------------------------------------------------------
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

Re: [Firebird-net-provider] EF Migrations

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

> 1. What problem in Execute block?

It kind of breaks the notion of altering the table/column with one command. It's a bit of magic with system tables and people might get confused or break it by chaning the script.

> 2. My opinion for "Identity" is to copy MSSQL behavior. Create generator for each primary key + trigger before insert.

MSSQL has identities. Given that there are at least two widely used schemes in Firebird community and nothing is in the engine itself, I'd like to keep this open, with some default implementation.

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

Re: [Firebird-net-provider] EF Migrations

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

Can you provide it on github, so I can patch my copy of FB library to use
in our project?

1. What problem in Execute block?
2. My opinion for "Identity" is to copy MSSQL behavior. Create generator
for each primary key + trigger before insert.


2014-11-08 14:38 GMT+02:00 Jiří Činčura <ji...@ci...>:

> Great. Here's http://ge.tt/2Cx9f142?c  early implementation. There are
> two issues which I'm not sure how to do (see below). Rest should work. But
> there might be some missing space etc. in generated SQL or I might wrote it
> in different engine's dialect. That's what I'm mostly looking for for this
> testing.
>
> For easiest testing is enough to install EntityFramework.Firebird package
> and then replace EntityFramework.Firebird.dll reference with the one from
> above link. The class is FbMigrationSqlGenerator, if you'd like to try it
> manually.
>
> Issues:
> 1. Not easy to drop NOT NULL constraint in alter table. I can do it with
> "execute block" and generate it there, but seems pretty ugly. I wish
> Firebird 3 was here.
> 2. Generating "identity" columns. It's not directly supported in Firebird.
> I can at least generate "#PK_GEN#" comment. But I'd like to offer some
> warning at least that you need to create your own trigger and use/create
> generator. Maybe some developer-provided factory to create/alter the
> trigger and create/use generator would work. I'm open for ideas.
>
> --
> Mgr. Jiří Činčura
> Independent IT Specialist
>
> ------------------------------------------------------------------------------
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

Re: [Firebird-net-provider] EF Migrations

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

Great. Here's http://ge.tt/2Cx9f142?c  early implementation. There are two issues which I'm not sure how to do (see below). Rest should work. But there might be some missing space etc. in generated SQL or I might wrote it in different engine's dialect. That's what I'm mostly looking for for this testing. 

For easiest testing is enough to install EntityFramework.Firebird package and then replace EntityFramework.Firebird.dll reference with the one from above link. The class is FbMigrationSqlGenerator, if you'd like to try it manually.

Issues:
1. Not easy to drop NOT NULL constraint in alter table. I can do it with "execute block" and generate it there, but seems pretty ugly. I wish Firebird 3 was here.
2. Generating "identity" columns. It's not directly supported in Firebird. I can at least generate "#PK_GEN#" comment. But I'd like to offer some warning at least that you need to create your own trigger and use/create generator. Maybe some developer-provided factory to create/alter the trigger and create/use generator would work. I'm open for ideas.

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

Re: [Firebird-net-provider] FirebirdClient was not found excepction when in use with EF6

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

It’s the same, only it’s called app.config.

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

Re: [Firebird-net-provider] FirebirdClient was not found excepction when in use with EF6

[Alfred R. B. <alf...@gm...>]

But I'm developing a WinForms application. Isn't web.config only for ASP.NET
apps?


On Thu, Nov 6, 2014 at 4:34 PM, Jiří Činčura <ji...@ci...> wrote:

> I would suggest to add it - if it's for application, not your environment
> - to app/web.config. Easier for deploy.
>
> --
> Mgr. Jiří Činčura
> Independent IT Specialist
>
>
> ------------------------------------------------------------------------------
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>



-- 
Best Regards,
Alfred Reinold Baudisch

Unity 3D and Corona SDK Games Developer
Email: alf...@gm...
Skype: AlfredBaudisch

Re: [Firebird-net-provider] FirebirdClient was not found excepction when in use with EF6

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

I would suggest to add it - if it's for application, not your environment - to app/web.config. Easier for deploy.

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

Re: [Firebird-net-provider] EF Migrations

[Mercea P. <pau...@al...>]

On 2014.11.06 3:06 PM, Jiří Činčura wrote:
> Hi *,
>
> Anybody here willing to give EF Migrations a try? I'm getting close to first implementation.
>
I'm in.


Paul MERCEA
___________________________________________

Re: [Firebird-net-provider] FirebirdClient was not found excepction when in use with EF6

[Alfred R. B. <alf...@gm...>]

The space was something only in the email, it was not in the XML.

Anyway, problem solved! The DbProviderFactories group was only present in
the 32-bit directory. I added it to the machine.config inside
C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config and now everything
works.

Thanks Jiří, it if wasn't for your help I would never came to this solution
(since nowhere in Google I found something THAT specific about my problem).

On Thu, Nov 6, 2014 at 11:20 AM, Jiří Činčura <ji...@ci...> wrote:

> You’re missing a space there. Check the message closely.
> "name 'FirebirdSql.Data. FirebirdClient'"
> Not sure why are you using the space there, maybe to avoid some other
> conflicts? Anyway, if it's not intentional, just remove the space and
> you're good to go.
>
> --
> Mgr. Jiří Činčura
> Independent IT Specialist
>
>
> ------------------------------------------------------------------------------
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>



-- 
Best Regards,
Alfred Reinold Baudisch

Unity 3D and Corona SDK Games Developer
Email: alf...@gm...
Skype: AlfredBaudisch

Re: [Firebird-net-provider] EF Migrations

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

Sure, waiting for this.

2014-11-06 15:06 GMT+02:00 Jiří Činčura <ji...@ci...>:

> Hi *,
>
> Anybody here willing to give EF Migrations a try? I'm getting close to
> first implementation.
>
> --
> Mgr. Jiří Činčura
> Independent IT Specialist
>
>
> ------------------------------------------------------------------------------
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

Re: [Firebird-net-provider] FirebirdClient was not found excepction when in use with EF6

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

You’re missing a space there. Check the message closely.
"name 'FirebirdSql.Data. FirebirdClient'"
Not sure why are you using the space there, maybe to avoid some other conflicts? Anyway, if it's not intentional, just remove the space and you're good to go.

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

Re: [Firebird-net-provider] FirebirdClient was not found excepction when in use with EF6

[Alfred R. B. <alf...@gm...>]

I didn't know about that, but Firebird is there too:
<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, Version=4.5.1.0, Culture=neutral,
PublicKeyToken=3750abcc3150b00c" />
    </DbProviderFactories>
  </system.data>

So app.config and machine.config are already set. What could it be then?

On Thu, Nov 6, 2014 at 10:41 AM, Jiří Činčura <ji...@ci...> wrote:

> You’re missing record in system.data > DbProviderFactories.
>
> --
> Mgr. Jiří Činčura
> Independent IT Specialist
>
> ------------------------------------------------------------------------------
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>



-- 
Best Regards,
Alfred Reinold Baudisch

Unity 3D and Corona SDK Games Developer
Email: alf...@gm...
Skype: AlfredBaudisch

[Firebird-net-provider] EF Migrations

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

Hi *,

Anybody here willing to give EF Migrations a try? I'm getting close to first implementation.

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

Re: [Firebird-net-provider] FirebirdClient was not found excepction when in use with EF6

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

You’re missing record in system.data > DbProviderFactories.

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

Re: [Firebird-net-provider] FirebirdClient was not found excepction when in use with EF6

[Alfred R. B. <alf...@gm...>]

The cursious thing is that I do have the record in app.config. Actually
that was the 1st thing I looked when I got the error.

  <entityFramework>
    <defaultConnectionFactory
type="FirebirdSql.Data.EntityFramework6.FbConnectionFactory,
EntityFramework.Firebird" />
    <providers>
      <provider invariantName="FirebirdSql.Data.FirebirdClient"
type="FirebirdSql.Data.EntityFramework6.FbProviderServices,
EntityFramework.Firebird" />
    </providers>
  </entityFramework>

On Thu, Nov 6, 2014 at 7:26 AM, Jiří Činčura <ji...@ci...> wrote:

> You don’t have factory record in machine/app/web.config.
>
> --
> Mgr. Jiří Činčura
> Independent IT Specialist
>
>
> ------------------------------------------------------------------------------
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>



-- 
Best Regards,
Alfred Reinold Baudisch

Unity 3D and Corona SDK Games Developer
Email: alf...@gm...
Skype: AlfredBaudisch

Re: [Firebird-net-provider] FirebirdClient was not found excepction when in use with EF6

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

You don’t have factory record in machine/app/web.config.

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

[Firebird-net-provider] FirebirdClient was not found excepction when in use with EF6

[Alfred R. B. <alf...@gm...>]

I made a small test application using Entity Framework 6.0 and
FirebirdSql.Data.
FirebirdClient.dll v4.5.1.0 where I succesfully generated Entities from a
Firebird database.

But when I try to do a database operation at runtime, I get this error:


*An unhandled exception of type 'System.ArgumentException' occurred in
EntityFramework.dllAdditional information: The ADO.NET <http://ADO.NET>
provider with invariant name 'FirebirdSql.Data. FirebirdClient' is either
not registered in the machine or application config file, or could not be
loaded. See the inner exception for details.*

I checked Process Explorer and the assemblies EntityFramework.Firebird and
FirebirdSql.Data. FirebirdClient were loaded, but still the exception says
a Firebird provider couldn't be found.

- I already uninstalled the provider from GAC.
- I tested with both .NET 4.0 (and the correct Firebird provider) as well
.NET 4.5

Any ideas?

-- 
Best Regards,
Alfred Reinold Baudisch

Unity 3D and Corona SDK Games Developer
Email: alf...@gm...
Skype: AlfredBaudisch

[Firebird-net-provider] [FB-Tracker] Created: (DNET-573) Do not check Position and Length on FbStreamingRestore

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

Do not check Position and Length on FbStreamingRestore
------------------------------------------------------

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


Do not check Position and Length on FbStreamingRestore as the stream might be open ended. Just stop when EOF reached.

-- 
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] OT: Somebody in Prague

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

Hi *,

Somebody going to Prague to enjoy conference? If so catch me there. Would like to know about your FirebirdClient usage.

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

[Firebird-net-provider] [FB-Tracker] Created: (DNET-572) Connection Exception

[Alex P. (JIRA) <tr...@fi...>]

Connection Exception
--------------------

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


Hi, guys. I think, it's time to resolve bug that described here:
http://stackoverflow.com/questions/1806144/firebird-connection-error-after-converting-project-from-vs2005-to-vs2008

I had exception while trying connect to Firebird:

System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index.
   в System.Collections.ArrayList.get_Item(Int32 index)
   в FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.GetServerVersion() в c:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\src\FirebirdSql.Data.FirebirdClient\Client\Managed\Version10\GdsDatabase.cs:строка 611
   в FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.AfterAttachActions() в c:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\src\FirebirdSql.Data.FirebirdClient\Client\Managed\Version10\GdsDatabase.cs:строка 242
   в FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.Attach(DatabaseParameterBuffer dpb, String dataSource, Int32 port, String database) в c:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\src\FirebirdSql.Data.FirebirdClient\Client\Managed\Version10\GdsDatabase.cs:строка 220
   в FirebirdSql.Data.FirebirdClient.FbConnectionInternal.Connect() в c:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbConnectionInternal.cs:строка 191
   в FirebirdSql.Data.FirebirdClient.FbConnectionPoolManager.Pool.CreateNewConnection(FbConnectionString connectionString, FbConnection owner) в c:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbConnectionPoolManager.cs:строка 162
   в FirebirdSql.Data.FirebirdClient.FbConnectionPoolManager.Pool.CreateNewConnectionIfPossibleImpl(FbConnectionString connectionString, FbConnection owner) в c:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbConnectionPoolManager.cs:строка 191
   в FirebirdSql.Data.FirebirdClient.FbConnectionPoolManager.Pool.GetConnection(FbConnection owner) в c:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbConnectionPoolManager.cs:строка 106
   в FirebirdSql.Data.FirebirdClient.FbConnectionPoolManager.Get(FbConnectionString connectionString, FbConnection owner) в c:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbConnectionPoolManager.cs:строка 210
   в FirebirdSql.Data.FirebirdClient.FbConnection.Open() в c:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbConnection.cs:строка 539


Replacing line return 
this.GetDatabaseInfo(items, IscCodes.BUFFER_SIZE_256)[0].ToString(); 

to this 

ArrayList ar = this.GetDatabaseInfo(items, IscCodes.BUFFER_SIZE_256);
            if (ar.Count > 0)
                return ar[0].ToString();
            else
                return String.Empty;

helped me

File version: FirebirdSql.Data.FirebirdClient.dll	4.5.1.0

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