firebird-net-provider Mailing List for Firebird

You might need to provide more information.

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

On Wed, Mar 30, 2016, at 23:32, Paul Dryden wrote:
> I installed the firebird .net provider with Nuget command 
> /Install-Package EntityFramework/. However when I build my project with 
> Visual Studio Pro 2013 I get the build error /Failed to find or load the 
> registered .Net Framework Data Provider/. Why is that and is there a 
> solution to this problem?
> 
> Paul
> 
> 
> ------------------------------------------------------------------------------
> Transform Data into Opportunity.
> Accelerate data analysis in your applications with
> Intel Data Analytics Acceleration Library.
> Click to learn more.
> http://pubads.g.doubleclick.net/gampad/clk?id=278785471&iu=/4140
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

I installed the firebird .net provider with Nuget command 
/Install-Package EntityFramework/. However when I build my project with 
Visual Studio Pro 2013 I get the build error /Failed to find or load the 
registered .Net Framework Data Provider/. Why is that and is there a 
solution to this problem?

Paul

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

                 Key: DNET-677
                 URL: http://tracker.firebirdsql.org/browse/DNET-677
             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: Pedro Filipe de Morais Lima
            Assignee: Jiri Cincura
             Fix For: 4.7.0.0


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

        

> Indeed. It's EF poor design, that they try to rework in EF core.
> Still there are plenty of workarounds for this. For example attaching
> entities only by ids.

Attaching by ID? It's still attaching...

> DbContext is supposed to be used in request-response scenario (web
> sites, for example), where context object is short-living object.

Quite opposite. Short-living context is recommended in request-response
scenarios. If you can keep the instance - like WPF, WinForms, etc. - the
benefit of having the context to track what you're doing is great help.

The context class itself was not designed to be used in any scenario in
particular. It should work and works in all range of options .NET
ecosystem offers. In fact, even just the disconnected scenario has at
least like 3 options to tackle it.

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

> That doesn't make any sense. If I dispose context after query then I
can't update the entities without attaching them to new context. Waste
of resources.

Indeed. It's EF poor design, that they try to rework in EF core.
Still there are plenty of workarounds for this. For example attaching
entities only by ids.

DbContext is supposed to be used in request-response scenario (web
sites, for example), where context object is short-living object.


On 26 March 2016 at 11:20, Jiří Činčura <ji...@ci...> wrote:
>> > d) Do I need to dispose the the context on closing the window?
>> Not only on that. you should create and dispose context for every
>> action you do with a database: insert, delete, update, query etc.
>
> That doesn't make any sense. If I dispose context after query then I
> can't update the entities without attaching them to new context. Waste
> of resources.
>
>> > 3.       As long the user does not explicit reload the data I am working in a connected mode
>> You don't have to be always connected for any reason.
>
> True. But for fat client type applications this is then way easier than
> disconnected scenarios.
>
> --
> Mgr. Jiří Činčura
> Independent IT Specialist
>
> ------------------------------------------------------------------------------
> Transform Data into Opportunity.
> Accelerate data analysis in your applications with
> Intel Data Analytics Acceleration Library.
> Click to learn more.
> http://pubads.g.doubleclick.net/gampad/clk?id=278785351&iu=/4140
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

> > d) Do I need to dispose the the context on closing the window?
> Not only on that. you should create and dispose context for every
> action you do with a database: insert, delete, update, query etc.

That doesn't make any sense. If I dispose context after query then I
can't update the entities without attaching them to new context. Waste
of resources.

> > 3.       As long the user does not explicit reload the data I am working in a connected mode
> You don't have to be always connected for any reason.

True. But for fat client type applications this is then way easier than
disconnected scenarios.

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

On 25-3-2016 17:23, LtColRDSChauhan wrote:
> Mark, thanks for your help.
> I was using FBackup.
>
>     FbStreamingBackup if you want to backup to your local machine.
>
> Using FbStreamingBackup solved my problem.
> But the ServiceOutput event handler is now not getting called.

That is expected, because there can't be any logging when using the 
streaming backup. The channel that in FbBackup is used to get log 
information is not available, because instead the backup data is sent 
over that channel.

Mark
-- 
Mark Rotteveel

>
> Message: 4
> Date: Wed, 23 Mar 2016 14:43:25 +0100
> From: Mark Rotteveel <ma...@la...>
> Subject: Re: [Firebird-net-provider] How to backup the remote database
>         to a local hard disk
> To: "For users and developers of the Firebird .NET providers"
>         <fir...@li...>
> Message-ID: <56F...@la...>
> Content-Type: text/plain; charset=utf-8; format=flowed
>
> On 23-3-2016 11:31, LtColRDSChauhan wrote:
> > Hi,
> >
> > 1.  Not able to back up:
> >
> > \\ServerMachine\C\ABC.FDB
> > to
> > \\TheLocalMachine\C\ABC.GBK
>
> Please show the code you use for the backup. You should be using
>

Mark, thanks for your help.
I was using FBackup.

FbStreamingBackup if you want to backup to your local machine.
>

Using FbStreamingBackup solved my problem.
But the ServiceOutput event handler is now not getting called.

> 2. The C drive of the TheLocalMachine is shared to Everyone with Allow
> > Full Control.
>
> Note that Firebird does not allow you to connect to a database on a
> network share (even if that share is local to the machine).
>
> Mark
> --
> Mark Rotteveel
>
>
>
> ------------------------------
>
> Message: 5
> Date: Fri, 25 Mar 2016 07:11:57 +0100
> From: "Nikolaus Kern" <par...@gm...>
> Subject: [Firebird-net-provider] Entity Framework: Best practices to
>         work in a multiuser environment
> To: "'For users and developers of the Firebird .NET providers'"
>         <fir...@li...>
> Message-ID: <000001d1865d$3ccec780$b66c5680$@gmx.at>
> Content-Type: text/plain; charset="us-ascii"
>
> Hello all,
>
>
>
> I am using EF 6.0 with Firebird 4.10 and have same questions about best
> practices. It is an WPF/MVVM application that runs in a multiuser
> environment.
>
>
>
> 1.       There is a static class to create the connection string
>
>     AppGlobals
> <
> http://127.0.0.1/roeder/dotnet/Default.aspx?Target=code://Support:1.0.11723
> .42736/Support.AppGlobals> .EFMetadata
> <
> http://127.0.0.1/roeder/dotnet/Default.aspx?Target=code://Support:1.0.11723
> .42736/Support.AppGlobals/property:EFMetadata:String>  =
> "res://*/LPP.csdl|res://*/LPP.ssdl|res://*/LPP.msl";
>     AppGlobals
> <
> http://127.0.0.1/roeder/dotnet/Default.aspx?Target=code://Support:1.0.11723
> .42736/Support.AppGlobals> .CreateConnectionString
> <
> http://127.0.0.1/roeder/dotnet/Default.aspx?Target=code://Support:1.0.11723
> .42736/Support.AppGlobals/CreateConnectionString()> ();
>
>
>
> 2.       I am using long living efcontext as protected variable in the
> ViewModel to read the data
>
>         protected lehnerEntities
> <
> http://127.0.0.1/roeder/dotnet/Default.aspx?Target=code://LppDataAccess:1.0
> .0.0/LppDataAccess.lehnerEntities>  _ctx
> <
> http://127.0.0.1/roeder/dotnet/Default.aspx?Target=code://LPP:1.0.0.0/LPP.v
> mEisenbiegerei/_ctx:LppDataAccess.lehnerEntities> ;
>
>
>
> 3.       As long the user does not explicit reload the data I am working in
> a connected mode
>
>
>
> 4.       Inserts, updates and deletes use the same context
>
>         LPP_LOGISTIK_EISENBIEGEN
> <
> http://127.0.0.1/roeder/dotnet/Default.aspx?Target=code://LppDataAccess:1.0
> .0.0/LppDataAccess.LPP_LOGISTIK_EISENBIEGEN>  entity = new
> LPP_LOGISTIK_EISENBIEGEN
> <
> http://127.0.0.1/roeder/dotnet/Default.aspx?Target=code://LppDataAccess:1.0
> .0.0/LppDataAccess.LPP_LOGISTIK_EISENBIEGEN/.ctor()> ();
>         this._ctx
> <
> http://127.0.0.1/roeder/dotnet/Default.aspx?Target=code://LPP:1.0.0.0/LPP.v
> mEisenbiegerei/_ctx:LppDataAccess.lehnerEntities>
> .LPP_LOGISTIK_EISENBIEGEN
> <
> http://127.0.0.1/roeder/dotnet/Default.aspx?Target=code://LppDataAccess:1.0
>
> .0.0/LppDataAccess.lehnerEntities/property:LPP_LOGISTIK_EISENBIEGEN:System.D
> ata.Entity.DbSet%3cLppDataAccess.LPP_LOGISTIK_EISENBIEGEN%3e> .Add
> <
> http://127.0.0.1/roeder/dotnet/Default.aspx?Target=code://EntityFramework:6
>
> .0.0.0:b77a5c561934e089/System.Data.Entity.DbSet%3c%3e/Add(%3c!0%3e):%3c!0%3
> e> (entity);
>         this._ctx
> <
> http://127.0.0.1/roeder/dotnet/Default.aspx?Target=code://LPP:1.0.0.0/LPP.v
> mEisenbiegerei/_ctx:LppDataAccess.lehnerEntities> .SaveChanges
> <
> http://127.0.0.1/roeder/dotnet/Default.aspx?Target=code://EntityFramework:6
> .0.0.0:b77a5c561934e089/System.Data.Entity.DbContext/SaveChanges():Int32>
> ();
>
>
>
> 5. When the user wants to refresh (F5) I instanciate the context again and
> use it as before
>
>     this._ctx
> <
> http://127.0.0.1/roeder/dotnet/Default.aspx?Target=code://LPP:1.0.0.0/LPP.v
> mEisenbiegerei/_ctx:LppDataAccess.lehnerEntities>  = new lehnerEntities
> <
> http://127.0.0.1/roeder/dotnet/Default.aspx?Target=code://LppDataAccess:1.0
> .0.0/LppDataAccess.lehnerEntities/.ctor(String)> (AppGlobals
> <
> http://127.0.0.1/roeder/dotnet/Default.aspx?Target=code://Support:1.0.11723
> .42736/Support.AppGlobals> .efSB
> <
> http://127.0.0.1/roeder/dotnet/Default.aspx?Target=code://Support:1.0.11723
>
> .42736/Support.AppGlobals/property:efSB:System.Data.EntityClient.EntityConne
> ctionStringBuilder> .ConnectionString
> <
> http://127.0.0.1/roeder/dotnet/Default.aspx?Target=code://System.Data:4.0.0
>
> .0:b77a5c561934e089/System.Data.Common.DbConnectionStringBuilder/property:Co
> nnectionString:String> );
>     this._auftraege
> <
> http://127.0.0.1/roeder/dotnet/Default.aspx?Target=code://LPP:1.0.0.0/LPP.v
>
> mEisenbiegerei/_auftraege:System.Linq.IQueryable%3cLppDataAccess.LPP_LOGISTI
> K_EISENBIEGEN%3e>  = this._ctx
> <
> http://127.0.0.1/roeder/dotnet/Default.aspx?Target=code://LPP:1.0.0.0/LPP.v
> mEisenbiegerei/_ctx:LppDataAccess.lehnerEntities> .GetOffeneEisenAuftraege
> <
> http://127.0.0.1/roeder/dotnet/Default.aspx?Target=code://LppDataAccess:1.0
>
> .0.0/LppDataAccess.lehnerEntities/GetOffeneEisenAuftraege():System.Linq.IQue
> ryable%3cLppDataAccess.LPP_LOGISTIK_EISENBIEGEN%3e> ();
>
>
>
> Questions:
>
> a) Is the method described above considered as good practice?
>
> b) Basically it is a connected Context until the user refreshes the data.
> In
> this case the context is recreated.
>
> c) In order to manage multiuser environment, do I need to work generally
> with disconnected entities?
>
> d) Do I need to dispose the the context on closing the window?
>
>
>
> Thanks
>
>
>
> Niko
>
> -------------- next part --------------
> An HTML attachment was scrubbed...
>
> ------------------------------
>
>
> ------------------------------------------------------------------------------
> Transform Data into Opportunity.
> Accelerate data analysis in your applications with
> Intel Data Analytics Acceleration Library.
> Click to learn more.
> http://pubads.g.doubleclick.net/gampad/clk?id=278785351&iu=/4140
>
> ------------------------------
>
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
>
> End of Firebird-net-provider Digest, Vol 119, Issue 2
> *****************************************************
>



-- 
  Regards,
  Lt Col (Retd) Rajiv D.S. Chauhan
  in.linkedin.com/in/ltcolrdschauhan
_____________________________

EF context is implementation of unit-of-work pattern, it is not
repository pattern.

> d) Do I need to dispose the the context on closing the window?
Not only on that. you should create and dispose context for every
action you do with a database: insert, delete, update, query etc.

> 3.       As long the user does not explicit reload the data I am working in a connected mode
You don't have to be always connected for any reason.

On 25 March 2016 at 09:18, Jiří Činčura <ji...@ci...> wrote:
>> a) Is the method described above considered as good practice?
>
> From what you've written, yes.
>
>> b) Basically it is a connected Context until the user refreshes the data.
>> In
>> this case the context is recreated.
>
> No problem with that.
>
>> c) In order to manage multiuser environment, do I need to work generally
>> with disconnected entities?
>
> No, you don't have to.
>
>> d) Do I need to dispose the the context on closing the window?
>
> Yes, you should.
>
> --
> Mgr. Jiří Činčura
> Independent IT Specialist
>
> ------------------------------------------------------------------------------
> Transform Data into Opportunity.
> Accelerate data analysis in your applications with
> Intel Data Analytics Acceleration Library.
> Click to learn more.
> http://pubads.g.doubleclick.net/gampad/clk?id=278785351&iu=/4140
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

> a) Is the method described above considered as good practice?

>From what you've written, yes.

> b) Basically it is a connected Context until the user refreshes the data.
> In
> this case the context is recreated.

No problem with that.

> c) In order to manage multiuser environment, do I need to work generally
> with disconnected entities?

No, you don't have to.
 
> d) Do I need to dispose the the context on closing the window?

Yes, you should.

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

Hello all,

 

I am using EF 6.0 with Firebird 4.10 and have same questions about best
practices. It is an WPF/MVVM application that runs in a multiuser
environment.

 

1.       There is a static class to create the connection string

    AppGlobals
<http://127.0.0.1/roeder/dotnet/Default.aspx?Target=code://Support:1.0.11723
.42736/Support.AppGlobals> .EFMetadata
<http://127.0.0.1/roeder/dotnet/Default.aspx?Target=code://Support:1.0.11723
.42736/Support.AppGlobals/property:EFMetadata:String>  =
"res://*/LPP.csdl|res://*/LPP.ssdl|res://*/LPP.msl";
    AppGlobals
<http://127.0.0.1/roeder/dotnet/Default.aspx?Target=code://Support:1.0.11723
.42736/Support.AppGlobals> .CreateConnectionString
<http://127.0.0.1/roeder/dotnet/Default.aspx?Target=code://Support:1.0.11723
.42736/Support.AppGlobals/CreateConnectionString()> ();

 

2.       I am using long living efcontext as protected variable in the
ViewModel to read the data

        protected lehnerEntities
<http://127.0.0.1/roeder/dotnet/Default.aspx?Target=code://LppDataAccess:1.0
.0.0/LppDataAccess.lehnerEntities>  _ctx
<http://127.0.0.1/roeder/dotnet/Default.aspx?Target=code://LPP:1.0.0.0/LPP.v
mEisenbiegerei/_ctx:LppDataAccess.lehnerEntities> ;

 

3.       As long the user does not explicit reload the data I am working in
a connected mode

 

4.       Inserts, updates and deletes use the same context

        LPP_LOGISTIK_EISENBIEGEN
<http://127.0.0.1/roeder/dotnet/Default.aspx?Target=code://LppDataAccess:1.0
.0.0/LppDataAccess.LPP_LOGISTIK_EISENBIEGEN>  entity = new
LPP_LOGISTIK_EISENBIEGEN
<http://127.0.0.1/roeder/dotnet/Default.aspx?Target=code://LppDataAccess:1.0
.0.0/LppDataAccess.LPP_LOGISTIK_EISENBIEGEN/.ctor()> ();
        this._ctx
<http://127.0.0.1/roeder/dotnet/Default.aspx?Target=code://LPP:1.0.0.0/LPP.v
mEisenbiegerei/_ctx:LppDataAccess.lehnerEntities> .LPP_LOGISTIK_EISENBIEGEN
<http://127.0.0.1/roeder/dotnet/Default.aspx?Target=code://LppDataAccess:1.0
.0.0/LppDataAccess.lehnerEntities/property:LPP_LOGISTIK_EISENBIEGEN:System.D
ata.Entity.DbSet%3cLppDataAccess.LPP_LOGISTIK_EISENBIEGEN%3e> .Add
<http://127.0.0.1/roeder/dotnet/Default.aspx?Target=code://EntityFramework:6
.0.0.0:b77a5c561934e089/System.Data.Entity.DbSet%3c%3e/Add(%3c!0%3e):%3c!0%3
e> (entity);
        this._ctx
<http://127.0.0.1/roeder/dotnet/Default.aspx?Target=code://LPP:1.0.0.0/LPP.v
mEisenbiegerei/_ctx:LppDataAccess.lehnerEntities> .SaveChanges
<http://127.0.0.1/roeder/dotnet/Default.aspx?Target=code://EntityFramework:6
.0.0.0:b77a5c561934e089/System.Data.Entity.DbContext/SaveChanges():Int32>
();

 

5. When the user wants to refresh (F5) I instanciate the context again and
use it as before

    this._ctx
<http://127.0.0.1/roeder/dotnet/Default.aspx?Target=code://LPP:1.0.0.0/LPP.v
mEisenbiegerei/_ctx:LppDataAccess.lehnerEntities>  = new lehnerEntities
<http://127.0.0.1/roeder/dotnet/Default.aspx?Target=code://LppDataAccess:1.0
.0.0/LppDataAccess.lehnerEntities/.ctor(String)> (AppGlobals
<http://127.0.0.1/roeder/dotnet/Default.aspx?Target=code://Support:1.0.11723
.42736/Support.AppGlobals> .efSB
<http://127.0.0.1/roeder/dotnet/Default.aspx?Target=code://Support:1.0.11723
.42736/Support.AppGlobals/property:efSB:System.Data.EntityClient.EntityConne
ctionStringBuilder> .ConnectionString
<http://127.0.0.1/roeder/dotnet/Default.aspx?Target=code://System.Data:4.0.0
.0:b77a5c561934e089/System.Data.Common.DbConnectionStringBuilder/property:Co
nnectionString:String> );
    this._auftraege
<http://127.0.0.1/roeder/dotnet/Default.aspx?Target=code://LPP:1.0.0.0/LPP.v
mEisenbiegerei/_auftraege:System.Linq.IQueryable%3cLppDataAccess.LPP_LOGISTI
K_EISENBIEGEN%3e>  = this._ctx
<http://127.0.0.1/roeder/dotnet/Default.aspx?Target=code://LPP:1.0.0.0/LPP.v
mEisenbiegerei/_ctx:LppDataAccess.lehnerEntities> .GetOffeneEisenAuftraege
<http://127.0.0.1/roeder/dotnet/Default.aspx?Target=code://LppDataAccess:1.0
.0.0/LppDataAccess.lehnerEntities/GetOffeneEisenAuftraege():System.Linq.IQue
ryable%3cLppDataAccess.LPP_LOGISTIK_EISENBIEGEN%3e> ();

 

Questions:

a) Is the method described above considered as good practice?

b) Basically it is a connected Context until the user refreshes the data. In
this case the context is recreated.

c) In order to manage multiuser environment, do I need to work generally
with disconnected entities?

d) Do I need to dispose the the context on closing the window?

 

Thanks

 

Niko

On 23-3-2016 11:31, LtColRDSChauhan wrote:
> Hi,
>
> 1.  Not able to back up:
>
> \\ServerMachine\C\ABC.FDB
> to
> \\TheLocalMachine\C\ABC.GBK

Please show the code you use for the backup. You should be using 
FbStreamingBackup if you want to backup to your local machine.

> 2. The C drive of the TheLocalMachine is shared to Everyone with Allow
> Full Control.

Note that Firebird does not allow you to connect to a database on a 
network share (even if that share is local to the machine).

Mark
-- 
Mark Rotteveel

Hi,

1.  Not able to back up:

\\ServerMachine\C\ABC.FDB
to
\\TheLocalMachine\C\ABC.GBK

2. The C drive of the TheLocalMachine is shared to Everyone with Allow Full
Control.

Please help.

Regards,
Rajiv

> Looks good for me.
> 
> Here is one more suggestion: extract DDEX sources to separate
> repository, and use FirebirdSql.Data.FirebirdClient rep only for
> client itself.

I wish MS ditch the DDEX and creating something more today-like. :)

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

Looks good for me.

Here is one more suggestion: extract DDEX sources to separate
repository, and use FirebirdSql.Data.FirebirdClient rep only for
client itself.

On 22 March 2016 at 22:12, Jiří Činčura <ji...@ci...> wrote:
> Hi *,
>
> I'm contemplating renaming some folders - the two top level folders to
> be precise
> (https://github.com/cincuranet/FirebirdSql.Data.FirebirdClient/tree/rename).
> So the names make a bit more sense as the codebase evolved. Yes? No?
>
> With the FB 3 protocol work I'm doing right now I'm kind of in a "you
> can't make an omelette without breaking eggs" mode. Refactoring all over
> the place. :) Like this polishing
> https://github.com/cincuranet/FirebirdSql.Data.FirebirdClient/commit/e166e84c2f5409d91b723a5d03930cf2b08a1662.
> :)
>
> --
> Mgr. Jiří Činčura
> Independent IT Specialist
>
> ------------------------------------------------------------------------------
> Transform Data into Opportunity.
> Accelerate data analysis in your applications with
> Intel Data Analytics Acceleration Library.
> Click to learn more.
> http://pubads.g.doubleclick.net/gampad/clk?id=278785351&iu=/4140
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Hi *,

I'm contemplating renaming some folders - the two top level folders to
be precise
(https://github.com/cincuranet/FirebirdSql.Data.FirebirdClient/tree/rename).
So the names make a bit more sense as the codebase evolved. Yes? No?

With the FB 3 protocol work I'm doing right now I'm kind of in a "you
can't make an omelette without breaking eggs" mode. Refactoring all over
the place. :) Like this polishing
https://github.com/cincuranet/FirebirdSql.Data.FirebirdClient/commit/e166e84c2f5409d91b723a5d03930cf2b08a1662.
:)

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

Excessive memory increase problem in FbDataAdapter method even using dispose ( ) .
----------------------------------------------------------------------------------

                 Key: DNET-673
                 URL: http://tracker.firebirdsql.org/browse/DNET-673
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 4.10.0.0
         Environment: Windows 10, Windows Server 2008, Windows Server 2012.
            Reporter: Workdev Tecnologia da Informação LTDA
            Assignee: Jiri Cincura


The execution of the command every 1 minute considerably increases memory not reducing after dispose .

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

       

Support SRP authentication in Firebird 3.0
------------------------------------------

                 Key: DNET-672
                 URL: http://tracker.firebirdsql.org/browse/DNET-672
             Project: .NET Data provider
          Issue Type: Sub-task
          Components: ADO.NET Provider
            Reporter: Simonov Denis
            Assignee: Jiri Cincura


In Firebird 3.0 the default authentication protocol uses the SRP. Currently provider does not support SRP, because of this we have to change the configuration to use Firebird Legacy_Auth.

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

        

> Is there a schedule to update the .net provider to support the new
> features
> of FB 3 e.g. compression?

Currently the Srp auth and bool support is being finalized. The
compression is still open ended.

> What are the plans regarding EF 7?
> (http://tracker.firebirdsql.org/browse/DNET-663)

http://blog.cincura.net/233539-ado-net-provider-4-9-0-0-for-firebird-is-ready/#comment-2547821373

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

Hello,

 

I understood that the current version of the .net provider supports access
to the FB 3 by using some setting (e.g. legacy code fro authentication).

 

Is there a schedule to update the .net provider to support the new features
of FB 3 e.g. compression?

 

What are the plans regarding EF 7?
(http://tracker.firebirdsql.org/browse/DNET-663)

 

Thanks

 

Niko

Null Object reference Exception while starting Serializable level transaction with ASP.NET
------------------------------------------------------------------------------------------

                 Key: DNET-671
                 URL: http://tracker.firebirdsql.org/browse/DNET-671
             Project: .NET Data provider
          Issue Type: Bug
    Affects Versions: 4.10.0.0
         Environment: Windows 7 64bit 
ASP.NET MVC 5
.NET 4.5
            Reporter: robsonwk
            Assignee: Jiri Cincura
            Priority: Critical


When I am trying to start serializable transaction:
using (var trans = _context.Database.BeginTransaction(IsolationLevel.Serializable)

I am getting exception: Object reference not set to an instance of an object.
with stacktrace:
at FirebirdSql.Data.EntityFramework6.FbMigrationsTransactionsInterceptor.<>c.<isinmigrations>b__1_0(StackFrame f) in C:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\src\EntityFramework.Firebird\FbMigrationsTransactionsInterceptor.cs:line 47

Firebird .NET provider 4.10.0.0
EF.Firebird 4.10.0.0
EF 6.1.3

The exception doesn't occure while I execute the same code in Console Application.

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