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

Re: [Firebird-net-provider] CORE4563

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

It's linked to that ticket:
http://tracker.firebirdsql.org/browse/DNET-726 .

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

On Mon, Feb 20, 2017, at 19:40, Nicolas Timmers wrote:
> Hello everyone
> 
> With the release of version 2.5.7, we have the item
> 
> Http://tracker.firebirdsql.org/browse/CORE-4563
> 
> Has been implemented, I would like to know if you will need modifications
> to .net provider?
> ------------------------------------------------------------------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, SlashDot.org! http://sdm.link/slashdot
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

[Firebird-net-provider] CORE4563

[Nicolas T. <nft...@ho...>]

Hello everyone

With the release of version 2.5.7, we have the item

Http://tracker.firebirdsql.org/browse/CORE-4563

Has been implemented, I would like to know if you will need modifications to .net provider?

[Firebird-net-provider] [FB-Tracker] Created: (DNET-738) EF does not detect concurrency update fail since FBClient returns row filled with null (storage generated) values instead of "nothing" (empty result)

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

EF does not detect concurrency update fail since FBClient returns row filled with null (storage generated) values instead of "nothing" (empty result)
-----------------------------------------------------------------------------------------------------------------------------------------------------

                 Key: DNET-738
                 URL: http://tracker.firebirdsql.org/browse/DNET-738
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 5.1.1.0
         Environment: FirebirdServer 2.5.4, .NET 4.5.1, EF 6.1.3
            Reporter: Jiri Fartak
            Assignee: Jiri Cincura


Synopsis:

FirebirdClient uses Execute block statements wrapping UPDATE command clause having RETURNING statement to return server-generated values (e.g. identity column, version...etc) back to EF.

This is typical example of such command:
-----
EXECUTE BLOCK (
p0 TIMESTAMP = @p0, p1 VARCHAR(16) CHARACTER SET UTF8 = @p1, p2 BIGINT = @p2, p3 CHAR(16) CHARACTER SET OCTETS = @p3, p4 BIGINT = @p4, p5 INT = @p5
) RETURNS (
"created" TIMESTAMP, "creator" VARCHAR(16), "deleted" TIMESTAMP, "deletor" VARCHAR(16), "version" INT)

AS BEGIN

UPDATE "PersistentObject"
SET "createdByOid" = NULL, "modified" = :p0, "modifier" = :p1, "modifiedByOid" = :p2, "deletedByOid" = NULL, "clsid" = :p3
WHERE (("oid" = :p4) AND ("version" = :p5))
RETURNING "created", "creator", "deleted", "deletor", "version" INTO :"created", :"creator", :"deleted", :"deletor", :"version";

SUSPEND;
END

------

The problem arises when UPDATE fails - when no row is updated due to concurrency, since no rows satisfied WHERE constraints (version has changed). If so, the following SUSPEND directive returns the row having ALL columns filled with null values to the caller.

This is misleading to EF (control layer), beacuse the presence of the row (albait with null values) causes, that command issued by EF will read this row (via FBDataReader()) as valid row (and so rowsAffected is 1 and not zero) and EF will then try to update entity's properties with these server-ganerated values (calls translator.BackPropagateServerGen()). However, since the row is having only null values, then properties that require value (.Required())  will make the EF to throw exception due to inconsistency (see below).

This is excerpt of control in System\Data\Mapping\Update\Internal\UpdateTranslator.cs:

		  foreach (UpdateCommand command in orderedCommands)
                {
                    // Remember the data sources so that we can throw meaningful exception
                    source = command;

		!!!! rowsAffected will have value of 1 instead of 0, since command.Execute returned row with nulls and not empty result set

                    long rowsAffected = command.Execute(translator, connection, identifierValues, generatedValues);

		!!! The line below would throw DbConcurrencyException (as we want and expect) if rowsAffected would be zero, this does not happen

                    translator.ValidateRowsAffected(rowsAffected, source);
                }

!! Following method throws the exception informing about inconsistency in server generated value and requirements for property in model
  translator.BackPropagateServerGen(generatedValues);



The FBClient behavior makes EF to throw this exception - informing about inconsistency - even though the problem was caused by concurrency update:

A null store-generated value was returned for a non-nullable member 'Created' of type 'WMS.Altair.Service.Repository.PersistentObjectModel'.
A null store-generated value was returned for a non-nullable member 'Created' of type 'WMS.Altair.Service.Repository.PersistentObjectModel'.
Výpis: Vnitřní výpis chyby:--->Typ chyby: DbUpdateExceptionZpráva: A null store-generated value was returned for a non-nullable member 'Created' of type'WMS.Altair.Service.Repository.PersistentObjectModel'.Výpis: v WMS.Altair.Service.Repository.IPAddressManager.Update(IPAddressModel model) v WMS.Altair.Web.Controllers.IPAddressController.Edit(IPAddressEditViewModel viewModel, StoreObjectState objectStates)Vnitřní výpis chyby:--->Typ chyby: UpdateExceptionZpráva: A null store-generated value was returned for a non-nullable member 'Created' of type 'WMS.Altair.Service.Repository.PersistentObjectModel'.Výpis: v System.Data.Entity.Core.Mapping.Update.Internal.PropagatorResult.AlignReturnValue(Object value, EdmMember member) v System.Data.Entity.Core.Mapping.Update.Internal.PropagatorResult.SetServerGenValue(Object value) v System.Data.Entity.Core.Mapping.Update.Internal.UpdateTranslator.BackPropagateServerGen(List`1 generatedValues) v System.Data.Entity.Core.Mapping.Update.Internal.UpdateTranslator.Update() v System.Data.Entity.Core.EntityClient.Internal.EntityAdapter.b__2(UpdateTranslator ut) v System.Data.Entity.Core.EntityClient.Internal.EntityAdapter.Update[T](T noChangesResult, Func`2 updateFunction) v System.Data.Entity.Core.EntityClient.Internal.EntityAdapter.Update() v System.Data.Entity.Core.Objects.ObjectContext.b__35() v System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess) v System.Data.Entity.Core.Objects.ObjectContext.SaveChangesToStore(SaveOptions options, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction) v System.Data.Entity.Core.Objects.ObjectContext.<>c__DisplayClass2a.b__27() v System.Data.Entity.Infrastructure.DefaultExecutionStrategy.Execute[TResult](Func`1 operation) v System.Data.Entity.Core.Objects.ObjectContext.SaveChangesInternal(SaveOptions options, Boolean executeInExistingTransaction) v System.Data.Entity.Core.Objects.ObjectContext.SaveChanges(SaveOptions options) v System.Data.Entity.Internal.InternalContext.SaveChanges() 


However, this exception would be throwed when FBClient would return empty result to EF:

--->
Typ chyby: DbUpdateConcurrencyException
Zpráva: Store update, insert, or delete statement affected an unexpected number of rows (0). Entities may have been modified or deleted since entities were loaded. See http://go.microsoft.com/fwlink/?LinkId=472540 for information on understanding and handling optimistic concurrency exceptions.
Výpis: v WMS.Altair.Service.Repository.IPAddressManager.Update(IPAddressModel model) v C:\Users\genx.INTRANET\Documents\Visual Studio 2013\Projects\AltairWebClient\AltairServices\Repository\UseCaseManager\IPAddressManager\IPAddressManager.cs:řádek 661 v WMS.Altair.Web.Controllers.IPAddressController.Edit(IPAddressEditViewModel viewModel, StoreObjectState objectStates) v C:\Users\genx.INTRANET\Documents\Visual Studio 2013\Projects\AltairWebClient\AltairWebClient\Controllers\IPAddressController.cs:řádek 485
Vnitřní výpis chyby:
--->
Typ chyby: OptimisticConcurrencyException
Zpráva: Store update, insert, or delete statement affected an unexpected number of rows (0). Entities may have been modified or deleted since entities were loaded. See http://go.microsoft.com/fwlink/?LinkId=472540 for information on understanding and handling optimistic concurrency exceptions.
Výpis: v System.Data.Entity.Core.Mapping.Update.Internal.UpdateTranslator.ValidateRowsAffected(Int64 rowsAffected, UpdateCommand source) v System.Data.Entity.Core.Mapping.Update.Internal.UpdateTranslator.Update() v System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess) v System.Data.Entity.Core.Objects.ObjectContext.SaveChangesToStore(SaveOptions options, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction) v System.Data.Entity.Core.Objects.ObjectContext.SaveChangesInternal(SaveOptions options, Boolean executeInExistingTransaction) v System.Data.Entity.Internal.InternalContext.SaveChanges()



----

Suggested Fix:

Instead of simple unconditional calling of SUSPEND we made minor change to the DmlSqlGenerator.GenerateReturningSql() method:

...
if (row_count > 0) then SUSPEND;
commandText.AppendLine("END");

...

if UPDATE command in EXECUTE BLOCK succeeded then Firebird Server sets row_count to 1 and then we sent the row to the caller, otherwise we do nothing (caller obtains empty result set). According Firebird database manual, the row_count should be supported since FB 1.5+ and it should not be too limiting for today deployments.

EF then gets empty result set and correctly detects it as DbConecurrencyException. We did minor testing and it looks promising.

Affected provider versions (where seen): 4.7.0.0, 5.1.1.0 and maybe others if GenerateReturningSql() generates the same pattern.

Jiri Fartak, WMS s.r.o.


-- 
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-737) NullReference Exception - Object reference not set to an instance of an object.

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

NullReference Exception - Object reference not set to an instance of an object.
-------------------------------------------------------------------------------

                 Key: DNET-737
                 URL: http://tracker.firebirdsql.org/browse/DNET-737
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 5.5.0.0
         Environment: Windows 7. 
            Reporter: Donald Jansen
            Assignee: Jiri Cincura


 Here is the exception I recieve from the Firebird.net library and when this happens the application start to hung and I have to restart it. I have put in numerous checks for null in the application with logging in case any variable is null however it always end up with this exception

 Message: Object reference not set to an instance of an object.
 HResult: -2147467261
 Source: FirebirdSql.Data.FirebirdClient
 StackTrace:    at FirebirdSql.Data.Client.Managed.Version10.GdsStatement.SendExecuteToBuffer() in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\Client\Managed\Version10\GdsStatement.cs:line 600
   at FirebirdSql.Data.Client.Managed.Version10.GdsStatement.Execute() in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\Client\Managed\Version10\GdsStatement.cs:line 304
   at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteCommand(CommandBehavior behavior, Boolean returnsSet) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs:line 1221
   at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs:line 539
   at FirebirdConnector.FirebirdConnector.GetLastRecords()
 TargetSite: Void SendExecuteToBuffer()

-- 
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] Firebird Net Provider very slow with blob fields

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

I don't think it has anything to do with blobs. You have problem some
place else. This looks like to network issue, maybe DNS (wild guess).


-- 

Mgr. Jiří Činčura

Independent IT Specialist





On Tue, Feb 14, 2017, at 15:35, Federico Paoloni wrote:

> We just start to insert document inside blob and this behaviour begin.
>

> If i make connection with default firebird client connection is
> immeditly
>

> Il 14/feb/2017 15:16, "Jiří Činčura" <ji...@ci...> ha scritto:

>

> > How does that relate to blobs?

> >

> > --

> > Mgr. Jiří Činčura

> > Independent IT Specialist

> >

> >

> > On Tue, Feb 14, 2017, at 15:13, Federico Paoloni wrote:

> > > 8 second to establish connection

> > >

> > > Il 14/feb/2017 15:10, "Jiří Činčura" <ji...@ci...> ha
> > > scritto:
> > >

> > > > What do you mean by slow? Some numbers or something to compare
> > > > with…
> > > >

> > > > --

> > > > Mgr. Jiří Činčura

> > > > Independent IT Specialist

> > > >

> > > >

> > > > On Mon, Feb 13, 2017, at 12:21, Federico Paoloni wrote:

> > > > > Hi,

> > > > >  i have problem with performance of .net firebird net
> > > > >  provider.
> > > > > In our company , we have an ERP base on FireBird.

> > > > >

> > > > > One division of my company start to put document inside blob
> > > > > field
> > on ERP

> > > > > an now all my connection with FireBird .net provider is very
> > > > > slow.
> > > > >

> > > > > In my query i don't select the field of the blob.

> > > > > How can i do to have better performance?

> > > > > I must change somenthing in Connection String?

> > > > >

> > > > > Any help would be appreciated.

> > > > > ------------------------------------------------------------

> > > > ------------------

> > > > > Check out the vibrant tech community on one of the world's
> > > > > most
> > > > > engaging tech sites, SlashDot.org! http://sdm.link/slashdot

> > > > > _______________________________________________

> > > > > Firebird-net-provider mailing list

> > > > > Fir...@li...

> > > > > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
> > > >

> > > >

> > > > ------------------------------------------------------------

> > > > ------------------

> > > > Check out the vibrant tech community on one of the world's most
> > > > engaging tech sites, SlashDot.org! http://sdm.link/slashdot

> > > > _______________________________________________

> > > > Firebird-net-provider mailing list

> > > > Fir...@li...

> > > > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
> > > >

> > > >

> > > ------------------------------------------------------------

> > ------------------

> > > Check out the vibrant tech community on one of the world's most

> > > engaging tech sites, SlashDot.org! http://sdm.link/slashdot

> > > _______________________________________________

> > > Firebird-net-provider mailing list

> > > Fir...@li...

> > > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
> >

> >

Re: [Firebird-net-provider] Firebird Net Provider very slow with blob fields

[Federico P. <fed...@gm...>]

We just start to insert document inside blob and this behaviour begin.

If i make connection with default firebird client connection is immeditly

Il 14/feb/2017 15:16, "Jiří Činčura" <ji...@ci...> ha scritto:

> How does that relate to blobs?
>
> --
> Mgr. Jiří Činčura
> Independent IT Specialist
>
>
> On Tue, Feb 14, 2017, at 15:13, Federico Paoloni wrote:
> > 8 second to establish connection
> >
> > Il 14/feb/2017 15:10, "Jiří Činčura" <ji...@ci...> ha scritto:
> >
> > > What do you mean by slow? Some numbers or something to compare with…
> > >
> > > --
> > > Mgr. Jiří Činčura
> > > Independent IT Specialist
> > >
> > >
> > > On Mon, Feb 13, 2017, at 12:21, Federico Paoloni wrote:
> > > > Hi,
> > > >  i have problem with performance of .net firebird net provider.
> > > > In our company , we have an ERP base on FireBird.
> > > >
> > > > One division of my company start to put document inside blob field
> on ERP
> > > > an now all my connection with FireBird .net provider is very slow.
> > > >
> > > > In my query i don't select the field of the blob.
> > > > How can i do to have better performance?
> > > > I must change somenthing in Connection String?
> > > >
> > > > Any help would be appreciated.
> > > > ------------------------------------------------------------
> > > ------------------
> > > > Check out the vibrant tech community on one of the world's most
> > > > engaging tech sites, SlashDot.org! http://sdm.link/slashdot
> > > > _______________________________________________
> > > > Firebird-net-provider mailing list
> > > > Fir...@li...
> > > > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
> > >
> > >
> > > ------------------------------------------------------------
> > > ------------------
> > > Check out the vibrant tech community on one of the world's most
> > > engaging tech sites, SlashDot.org! http://sdm.link/slashdot
> > > _______________________________________________
> > > Firebird-net-provider mailing list
> > > Fir...@li...
> > > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
> > >
> > >
> > ------------------------------------------------------------
> ------------------
> > Check out the vibrant tech community on one of the world's most
> > engaging tech sites, SlashDot.org! http://sdm.link/slashdot
> > _______________________________________________
> > Firebird-net-provider mailing list
> > Fir...@li...
> > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
>

Re: [Firebird-net-provider] Firebird Net Provider very slow with blob fields

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

How does that relate to blobs?



-- 

Mgr. Jiří Činčura

Independent IT Specialist





On Tue, Feb 14, 2017, at 15:13, Federico Paoloni wrote:

> 8 second to establish connection

>

> Il 14/feb/2017 15:10, "Jiří Činčura" <ji...@ci...> ha scritto:

>

> > What do you mean by slow? Some numbers or something to compare with…
> >

> > --

> > Mgr. Jiří Činčura

> > Independent IT Specialist

> >

> >

> > On Mon, Feb 13, 2017, at 12:21, Federico Paoloni wrote:

> > > Hi,

> > >  i have problem with performance of .net firebird net provider.

> > > In our company , we have an ERP base on FireBird.

> > >

> > > One division of my company start to put document inside blob field
> > > on ERP
> > > an now all my connection with FireBird .net provider is very slow.
> > >

> > > In my query i don't select the field of the blob.

> > > How can i do to have better performance?

> > > I must change somenthing in Connection String?

> > >

> > > Any help would be appreciated.

> > > ------------------------------------------------------------

> > ------------------

> > > Check out the vibrant tech community on one of the world's most

> > > engaging tech sites, SlashDot.org! http://sdm.link/slashdot

> > > _______________________________________________

> > > Firebird-net-provider mailing list

> > > Fir...@li...

> > > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
> >

> >

> > ------------------------------------------------------------

> > ------------------

> > Check out the vibrant tech community on one of the world's most

> > engaging tech sites, SlashDot.org! http://sdm.link/slashdot

> > _______________________________________________

> > Firebird-net-provider mailing list

> > Fir...@li...

> > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

> >

> >

> ----------------------------------------------------------------------
> --------
> Check out the vibrant tech community on one of the world's most

> engaging tech sites, SlashDot.org! http://sdm.link/slashdot

> _______________________________________________

> Firebird-net-provider mailing list

> Fir...@li...

> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Firebird Net Provider very slow with blob fields

[Federico P. <fed...@gm...>]

8 second to establish connection

Il 14/feb/2017 15:10, "Jiří Činčura" <ji...@ci...> ha scritto:

> What do you mean by slow? Some numbers or something to compare with…
>
> --
> Mgr. Jiří Činčura
> Independent IT Specialist
>
>
> On Mon, Feb 13, 2017, at 12:21, Federico Paoloni wrote:
> > Hi,
> >  i have problem with performance of .net firebird net provider.
> > In our company , we have an ERP base on FireBird.
> >
> > One division of my company start to put document inside blob field on ERP
> > an now all my connection with FireBird .net provider is very slow.
> >
> > In my query i don't select the field of the blob.
> > How can i do to have better performance?
> > I must change somenthing in Connection String?
> >
> > Any help would be appreciated.
> > ------------------------------------------------------------
> ------------------
> > Check out the vibrant tech community on one of the world's most
> > engaging tech sites, SlashDot.org! http://sdm.link/slashdot
> > _______________________________________________
> > Firebird-net-provider mailing list
> > Fir...@li...
> > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
>
> ------------------------------------------------------------
> ------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, SlashDot.org! http://sdm.link/slashdot
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
>

Re: [Firebird-net-provider] Firebird Net Provider very slow with blob fields

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

What do you mean by slow? Some numbers or something to compare with…



-- 

Mgr. Jiří Činčura

Independent IT Specialist





On Mon, Feb 13, 2017, at 12:21, Federico Paoloni wrote:

> Hi,

>  i have problem with performance of .net firebird net provider.

> In our company , we have an ERP base on FireBird.

>

> One division of my company start to put document inside blob
> field on ERP
> an now all my connection with FireBird .net provider is very slow.

>

> In my query i don't select the field of the blob.

> How can i do to have better performance?

> I must change somenthing in Connection String?

>

> Any help would be appreciated.

> ----------------------------------------------------------------------
> --------
> Check out the vibrant tech community on one of the world's most

> engaging tech sites, SlashDot.org! http://sdm.link/slashdot

> _______________________________________________

> Firebird-net-provider mailing list

> Fir...@li...

> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

[Firebird-net-provider] Firebird Net Provider very slow with blob fields

[Federico P. <fed...@gm...>]

Hi,
 i have problem with performance of .net firebird net provider.
In our company , we have an ERP base on FireBird.

One division of my company start to put document inside blob field on ERP
an now all my connection with FireBird .net provider is very slow.

In my query i don't select the field of the blob.
How can i do to have better performance?
I must change somenthing in Connection String?

Any help would be appreciated.

Re: [Firebird-net-provider] Entity Framework 6

[Daniel R. <da...@ac...>]

Hi,

At February 10, 2017, 8:12 AM, Jiří Činčura wrote:

>> it(when compiled). And, since the application that is calling this
>> .dll is not a .Net application(it's a native Win32 Delphi
>> application), I am trying to find out how to setup the entity

> Again. You're not saying how are you loading it. You can load DLL and
> execute some code from it even with config file. Depends how you're
> loading the CLR (and if, also).

Just to add to the context.

I'm using RemObjects Hydra as the plugin architecture, for our
application, and it's Hydra that loads the .Net assembly DLL. The DLL
is ComVisible. But other than looking in Hydra's code, I can't say how
the DLL is loaded.

Again thanks for the information.

-- 
Best regards,
 Daniel Rail
 Senior Software Developer
 ACCRA Solutions Inc. (www.accra.ca)
 ACCRA Med Software Inc. (www.filopto.com)

Re: [Firebird-net-provider] Entity Framework 6

[Daniel R. <da...@ac...>]

Hi,

At February 10, 2017, 8:13 AM, Jiří Činčura wrote:

> Also, if you'd read my blog, you'd have been done already:
> https://blog.cincura.net/233368-configuring-3rd-party-entity-framework-provider-firebird-from-code/
> ;)

Thanks, that's what I was looking for. I do remember coming across it,
but when I did, that wasn't the information that I was looking for at
the time. At first, I was just trying to figure out why I didn't have
the ADO.Net Entity Data Model template in Visual Studio, just to find
out, after searching for almost a day, that I needed to install either
the Web Developer Tools or SQL Server Data Tools, when installing
VS2015.

Anyway, thanks for the information and your hard work on the ADO.Net
provider.

-- 
Best regards,
 Daniel Rail
 Senior Software Developer
 ACCRA Solutions Inc. (www.accra.ca)
 ACCRA Med Software Inc. (www.filopto.com)

Re: [Firebird-net-provider] Entity Framework 6

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

Also, if you'd read my blog, you'd have been done already:
https://blog.cincura.net/233368-configuring-3rd-party-entity-framework-provider-firebird-from-code/
;)

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

Re: [Firebird-net-provider] Entity Framework 6

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

> An exception of type 'System.InvalidOperationException' occurred in
> EntityFramework.dll but was not handled in user code
> 
> Additional information: No Entity Framework provider found for the
> ADO.NET provider with invariant name
> 'FirebirdSql.Data.FirebirdClient'. Make sure the provider is
> registered in the 'entityFramework' section of the application config
> file. See http://go.microsoft.com/fwlink/?LinkId=260882 for more
> information.

In your DbConfiguration class register the FbProviderServices. Here's a
field for that:
https://github.com/cincuranet/FirebirdSql.Data.FirebirdClient/blob/master/Provider/src/FirebirdSql.Data.FirebirdClient/FirebirdClient/FbProviderServices.cs#L64
(you can also use the ProviderInvariantName).

> it(when compiled). And, since the application that is calling this
> .dll is not a .Net application(it's a native Win32 Delphi
> application), I am trying to find out how to setup the entity

Again. You're not saying how are you loading it. You can load DLL and
execute some code from it even with config file. Depends how you're
loading the CLR (and if, also).

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

Re: [Firebird-net-provider] Entity Framework 6

[Daniel R. <da...@ac...>]

<html><head><title>Re: [Firebird-net-provider] Entity Framework 6</title>
</head>
<body>
<span style=" font-family:'Courier New'; font-size: 9pt;">Hi,<br>
<br>
At February 9, 2017, 6:52 PM, Paul Dryden wrote:<br>
<br>
</span><table bgcolor="#ffffff">
<tr>
<td width=2 bgcolor= #0000ff><br>
</td>
<td><span style=" font-family:'arial'; font-size: 11pt;">I have have had problems using Windows Entity Data Framework. In some cases, I can't open an edmx file in Visual Studio (that I had compiled from scanning a database perhaps a year earlier, always receiving "Provider Not Found." Very frustrating.</td>
</tr>
</table>
<br>
<span style=" font-family:'Courier New'; font-size: 9pt;">Actually, with Code First in EF6, I'm not dealing with an edmx file at all.<br>
<br>
<span style=" font-family:'calibri'; color: #c0c0c0;"><i>-- <br>
Best regards,<br>
 Daniel Rail<br>
 Senior Software Developer<br>
 ACCRA Solutions Inc. (</i></span></span><a style=" font-family:'calibri'; font-size: 9pt;" href="http://www.accra.ca">www.accra.ca</a><span style=" font-family:'calibri'; font-size: 9pt; color: #c0c0c0;"><i>)<br>
 ACCRA Med Software Inc. (</i></span><a style=" font-family:'calibri'; font-size: 9pt;" href="http://www.filopto.com">www.filopto.com</a><span style=" font-family:'calibri'; font-size: 9pt; color: #c0c0c0;"><i>)</body></html>

Re: [Firebird-net-provider] Entity Framework 6

[Daniel R. <da...@ac...>]

Hi,

At February 10, 2017, 3:28 AM, Jiří Činčura wrote:

> Well, you're not saying anything specific about the exception (at least
> which provider - EF or ADO.NET?) nor how's the assembly loaded (because
> you can as well use the config file, depending on how it's loaded).

> Let's guess that it's a ADO.NET provider, then you're probably missing
> the DbProviderFactory piece
> (https://github.com/cincuranet/EF6_Firebird/blob/master/CodeFirst/App.config#L12).
> With that, I would go the easiest way and pass directly FbConnection to
> DbContext's ctor. 

Sorry, for not being clearer.

Here's  the  exact  error  message,  that  I receive when running from
Visual Studio:

[Error Message Quote]
An exception of type 'System.InvalidOperationException' occurred in
EntityFramework.dll but was not handled in user code

Additional information: No Entity Framework provider found for the
ADO.NET provider with invariant name
'FirebirdSql.Data.FirebirdClient'. Make sure the provider is
registered in the 'entityFramework' section of the application config
file. See http://go.microsoft.com/fwlink/?LinkId=260882 for more
information.
[/Error Message Quote]

Here's the code that I use:

  using (var db = new FiloptoDataLibrary.FiloptoQuickBooksModel(new FbConnection(vFBConnectionString.ToString()), true))
  {
   ...
  }

The FiloptoQuickBooksModel is inherited from DbContext, and was
created by the Entity Framework Tools Code First from Database wizard.
The vFBConnectionString is a FbConnectionStringBuilder.

And, in the project's App.Config, all the entries are there. But, the
project compiles to a .dll and doesn't have a .config file with
it(when compiled). And, since the application that is calling this
.dll is not a .Net application(it's a native Win32 Delphi
application), I am trying to find out how to setup the entity
framework provider for usage in the .dll. And, since it is possible to
register the entity framework provider in code, in EF6, I'm wondering
what would be the required code, when trying to follow the example
from Microsoft, provided in the link of my previous message.

I am using Visual Studio 2015, EF 6.1.3 and targetting .Net 4.6.2.

I did thought of using the EntityConnectionStringBuilder, but it is
looking for the metadata files(.csdl, .ssdl, .msl), which don't exist
in my case. Unless, there is a way to tell it to ignore the metadata
files, when using the EntityConnectionString, because at least here I
would be able to specify the provider.

If more information is needed, just let me know.

-- 
Best regards,
 Daniel Rail
 Senior Software Developer
 ACCRA Solutions Inc. (www.accra.ca)
 ACCRA Med Software Inc. (www.filopto.com)

Re: [Firebird-net-provider] Entity Framework 6

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

Well, you're not saying anything specific about the exception (at least
which provider - EF or ADO.NET?) nor how's the assembly loaded (because
you can as well use the config file, depending on how it's loaded).

Let's guess that it's a ADO.NET provider, then you're probably missing
the DbProviderFactory piece
(https://github.com/cincuranet/EF6_Firebird/blob/master/CodeFirst/App.config#L12).
With that, I would go the easiest way and pass directly FbConnection to
DbContext's ctor. 

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

On Thu, Feb 9, 2017, at 21:32, Daniel Rail wrote:
> Hi,
> 
>   I'm trying to use the Firebird ADO.Net with Entity Framework 6.
> 
>   I'm able to create a code first model from an existing database.
>   But, when trying to establish a connection, it is telling me that a
>   provider is not registered. My scenario is that the connection is
>   done in a DLL, not an EXE, and the main application's EXE that is
>   calling this .Net assembly DLL is a Win32/Delphi application. I know
>   that normally the provider information would be in the application's
>   config file, but in this case the config file is not copied with the
>   assembly DLL.
> 
>   I was reading on how to register the provider in code (
>   https://msdn.microsoft.com/en-us/library/jj680699(v=vs.113).aspx ),
>   but I'm unsure what to put for the SetExecutionStrategy line in the
>   example.
> 
>   Any help would be appreciated.
> 
> -- 
> Best regards,
>  Daniel Rail
>  Senior System Engineer
>  ACCRA Solutions Inc. (www.accra.ca)
>  ACCRA Med Software Inc. (www.filopto.com)
> 
> 
> ------------------------------------------------------------------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, SlashDot.org! http://sdm.link/slashdot
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Entity Framework 6

[Paul D. <pau...@ut...>]

I have have had problems using Windows Entity Data Framework. In some 
cases, I can't open an edmx file in Visual Studio (that I had compiled 
from scanning a database perhaps a year earlier, always receiving 
"Provider Not Found." Very frustrating.

I am now considering switching to MySql, even though I would prefer to 
stay with Firebird.


On 2/9/2017 1:32 PM, Daniel Rail wrote:
> Hi,
>
>    I'm trying to use the Firebird ADO.Net with Entity Framework 6.
>
>    I'm able to create a code first model from an existing database.
>    But, when trying to establish a connection, it is telling me that a
>    provider is not registered. My scenario is that the connection is
>    done in a DLL, not an EXE, and the main application's EXE that is
>    calling this .Net assembly DLL is a Win32/Delphi application. I know
>    that normally the provider information would be in the application's
>    config file, but in this case the config file is not copied with the
>    assembly DLL.
>
>    I was reading on how to register the provider in code (
>    https://msdn.microsoft.com/en-us/library/jj680699(v=vs.113).aspx ),
>    but I'm unsure what to put for the SetExecutionStrategy line in the
>    example.
>
>    Any help would be appreciated.
>

[Firebird-net-provider] Entity Framework 6

[Daniel R. <da...@ac...>]

Hi,

  I'm trying to use the Firebird ADO.Net with Entity Framework 6.

  I'm able to create a code first model from an existing database.
  But, when trying to establish a connection, it is telling me that a
  provider is not registered. My scenario is that the connection is
  done in a DLL, not an EXE, and the main application's EXE that is
  calling this .Net assembly DLL is a Win32/Delphi application. I know
  that normally the provider information would be in the application's
  config file, but in this case the config file is not copied with the
  assembly DLL.

  I was reading on how to register the provider in code (
  https://msdn.microsoft.com/en-us/library/jj680699(v=vs.113).aspx ),
  but I'm unsure what to put for the SetExecutionStrategy line in the
  example.

  Any help would be appreciated.

-- 
Best regards,
 Daniel Rail
 Senior System Engineer
 ACCRA Solutions Inc. (www.accra.ca)
 ACCRA Med Software Inc. (www.filopto.com)

[Firebird-net-provider] [FB-Tracker] Created: (DNET-736) Set Generator Value

[Marcos G. F. S. (JIRA) <tr...@fi...>]

Set Generator Value
-------------------

                 Key: DNET-736
                 URL: http://tracker.firebirdsql.org/browse/DNET-736
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 5.7.0.0
         Environment: Select Gen_ID not work
            Reporter: Marcos Gerene Felix Spirito
            Assignee: Jiri Cincura


Look theses comands:

1. SET GENERATOR generator_name TO value

2. SELECT GEN_ID(generator_name, (SELECT MAX(id) FROM table_name) - GEN_ID(generator_name, 0)) FROM RDB$DATABASE;

The 1 its Ok with FBCommand ExecuteNonQuery(); method, but 2 not work.

-- 
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-735) Problem with the Release method of FbConnection in multithreaded context

[Lévêque M. (J. <tr...@fi...>]

Problem with the Release method of FbConnection in multithreaded context
------------------------------------------------------------------------

                 Key: DNET-735
                 URL: http://tracker.firebirdsql.org/browse/DNET-735
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 5.7.0.0
         Environment: Any Windows OS / Framework 4.0 / Firebird 2.5 / ADO .NET Provider 5.7.0.0
            Reporter: Lévêque Mathieu
            Assignee: Jiri Cincura
         Attachments: Firebird_FbCommand_Release_InnerConnection_NullRef_Exception.png, Firebird_FbCommand_Release_InnerConnection_NullRef_Exception_Stacktrace.png, FirebirdNullExceptionReproduce.zip

My software use the ADO .NET provider and crash once or twice a day.
I searched on this tracker and my problem is very similar to DNET-316 and DNET-368.

I used the provided tool (FirebirdNullExceptionReproduce.zip) to reproduce the problem.
I updated this tool with the latest version of ADO .NET provider (5.7.0.0) and the problem is still here.

I join to the issue the zipped tool updated with the 5.7.0.0 version.
Can you take another look for that problem ?

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

       

Re: [Firebird-net-provider] FB 3 embedded Missing security context

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

You need to create mapping (based on your first error):
https://www.firebirdsql.org/file/documentation/release_notes/html/en/3_0/rnfb30-security-mapping.html

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

Re: [Firebird-net-provider] FB 3 embedded Missing security context

[Daniele B. <dan...@eu...>]

Thanks for the reply,

maybe I misunderstood something, sorry, this is the first time I'm using
the 3.x embedded

I create a Databases.conf in my db folder:

radiodb = D:\path_to_db\radios.fdb
{
  RemoteAccess = false
  SecurityDatabase = radiodb
}

And now I get:

{System.Data.Common.DbException} =
{"Unable to complete network request to host \"xnet://Global\\FIREBIRD\"."}


I try to follow the RN instructions and I create a brand new DB with isql...

> isql -user sysdba
SQL> create database 'radios.fdb';

Follow the steps to create a password for sysdba:

SQL> connect radios;
SQL> create user sysdba password 'my_password';

I get a violation of PRIMARY KEY constraint INTER_2 on table PLG$USERS
because PLG$USER_NAME" = 'SYSDBA'

What I miss?


Il 01/02/2017 21:50, Jiří Činčura ha scritto:
> Check the RN, the "Security" chapter. 
> 
> -- 
> Mgr. Jiří Činčura
> Independent IT Specialist
> 
> 
> On Wed, Feb 1, 2017, at 15:58, Daniele Barzotti wrote:
>> Hi,
>>
>> I'm trying to create a \ connect to FB 3 embedded but I get a
>> DbException:
>>
>> {System.Data.Common.DbException} =
>> {"Missing security context for D:\\...path...\\RADIOS.FDB"}
>>
>> What I'm missing?
>>
>> My code is:
>>
>>       var currentDirectory =
>>         Path.GetDirectoryName(GetCurrentProcess().MainModule.FileName);
>>
>>       string dbPath = Path.Combine(currentDirectory, "Radios.fdb");
>>
>>       var connectionString = new FbConnectionStringBuilder
>>       {
>>         Database = dbPath,
>>         ServerType = FbServerType.Embedded,
>>         UserID = "sysdba",
>>         Password = "masterkey",
>>         ClientLibrary = "fbclient.dll"
>>       }.ToString();
>>
>>       try
>>       {
>>         _Conn = new FbConnection();
>>         _Conn.ConnectionString = connectionString;
>>         _Conn.InfoMessage += _Conn_InfoMessage;
>>         _Conn.StateChange += _Conn_StateChange;
>>
>>         if (!File.Exists(dbPath))
>>         {
>>           FbConnection.CreateDatabase(_Conn.ConnectionString);
>>           _Conn.Open();
>>
>>           FbCommand cmd = new FbCommand(DbDefinition, _Conn);
>>           var tr = _Conn.BeginTransaction();
>>           cmd.ExecuteNonQuery();
>>           tr.Commit();
>>
>>         }
>>         else
>>           _Conn.Open();
>>
>>         LoadData();
>>       }
>>       catch (FbException fex)
>>       {
>>         _logger.Error(fex, "MainModel error");
>>         throw fex;
>>       }
>>       catch (Exception ex)
>>       {
>>         _logger.Error(ex, "MainModel error");
>>         throw ex;
>>       }


---
Questa e-mail è stata controllata per individuare virus con Avast antivirus.
https://www.avast.com/antivirus

Re: [Firebird-net-provider] FB 3 embedded Missing security context

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

Check the RN, the "Security" chapter. 



-- 

Mgr. Jiří Činčura

Independent IT Specialist





On Wed, Feb 1, 2017, at 15:58, Daniele Barzotti wrote:

> Hi,

>

> I'm trying to create a \ connect to FB 3 embedded but I get a

> DbException:

>

> {System.Data.Common.DbException} =

> {"Missing security context for D:\\...path...\\RADIOS.FDB"}

>

> What I'm missing?

>

> My code is:

>

>       var currentDirectory =

>         Path.GetDirectoryName(GetCurrentProcess().MainModule.FileName-
>         );
>

>       string dbPath = Path.Combine(currentDirectory, "Radios.fdb");

>

>       var connectionString = new FbConnectionStringBuilder

>       {

>         Database = dbPath,

>         ServerType = FbServerType.Embedded,

>         UserID = "sysdba",

>         Password = "masterkey",

>         ClientLibrary = "fbclient.dll"

>       }.ToString();

>

>       try

>       {

>         _Conn = new FbConnection();

>         _Conn.ConnectionString = connectionString;

>         _Conn.InfoMessage += _Conn_InfoMessage;

>         _Conn.StateChange += _Conn_StateChange;

>

>         if (!File.Exists(dbPath))

>         {

>           FbConnection.CreateDatabase(_Conn.ConnectionString);

>           _Conn.Open();

>

>           FbCommand cmd = new FbCommand(DbDefinition, _Conn);

>           var tr = _Conn.BeginTransaction();

>           cmd.ExecuteNonQuery();

>           tr.Commit();

>

>         }

>         else

>           _Conn.Open();

>

>         LoadData();

>       }

>       catch (FbException fex)

>       {

>         _logger.Error(fex, "MainModel error");

>         throw fex;

>       }

>       catch (Exception ex)

>       {

>         _logger.Error(ex, "MainModel error");

>         throw ex;

>       }

>

> ----------------------------------------------------------------------
> --------
> Check out the vibrant tech community on one of the world's most

> engaging tech sites, SlashDot.org! http://sdm.link/slashdot

> _______________________________________________

> Firebird-net-provider mailing list

> Fir...@li...

> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

[Firebird-net-provider] FB 3 embedded Missing security context

[Daniele B. <dan...@eu...>]

Hi,

I'm trying to create a \ connect to FB 3 embedded but I get a DbException:

{System.Data.Common.DbException} =
{"Missing security context for D:\\...path...\\RADIOS.FDB"}

What I'm missing?

My code is:

      var currentDirectory =
        Path.GetDirectoryName(GetCurrentProcess().MainModule.FileName);

      string dbPath = Path.Combine(currentDirectory, "Radios.fdb");

      var connectionString = new FbConnectionStringBuilder
      {
        Database = dbPath,
        ServerType = FbServerType.Embedded,
        UserID = "sysdba",
        Password = "masterkey",
        ClientLibrary = "fbclient.dll"
      }.ToString();

      try
      {
        _Conn = new FbConnection();
        _Conn.ConnectionString = connectionString;
        _Conn.InfoMessage += _Conn_InfoMessage;
        _Conn.StateChange += _Conn_StateChange;

        if (!File.Exists(dbPath))
        {
          FbConnection.CreateDatabase(_Conn.ConnectionString);
          _Conn.Open();

          FbCommand cmd = new FbCommand(DbDefinition, _Conn);
          var tr = _Conn.BeginTransaction();
          cmd.ExecuteNonQuery();
          tr.Commit();

        }
        else
          _Conn.Open();

        LoadData();
      }
      catch (FbException fex)
      {
        _logger.Error(fex, "MainModel error");
        throw fex;
      }
      catch (Exception ex)
      {
        _logger.Error(ex, "MainModel error");
        throw ex;
      }