Re: [Firebird-net-provider] Trace down rootcause for FirebirdSql.Data.Common.IscException

2016-01-02 Thread Nikolaus Kern
of the Firebird .NET providers <firebird-net-provider@lists.sourceforge.net> Betreff: Re: [Firebird-net-provider] Trace down rootcause for FirebirdSql.Data.Common.IscException What's the call stack? -- Mgr. Jiří Činčura Independent IT Specialist On Fri, Jan 1, 2016, at 19:43, Nikolau

Re: [Firebird-net-provider] Trace down rootcause for FirebirdSql.Data.Common.IscException

2016-01-02 Thread Nikolaus Kern
09:44 An: firebird-net-provider@lists.sourceforge.net Betreff: Re: [Firebird-net-provider] Trace down rootcause for FirebirdSql.Data.Common.IscException Isn't it the same as DNET-657? -- Mgr. Jiří Činčura Independent IT Specialist On Sat, Jan 2, 2016, at 09:21, Nikolaus Kern wrote: > Hello J

[Firebird-net-provider] Trace down rootcause for FirebirdSql.Data.Common.IscException

2016-01-01 Thread Nikolaus Kern
Hello, I am getting a number of execptions during the tests of my .net 4.5 app. It uses EF6 as well as .net provider 4.9. Is there a way to get the rootcause of this exception? I don´t have an idea where to put a TRY CATCH arround because the exception is not crashing the app. Therefore I don´t

[Firebird-net-provider] Pre-Generated Views with EF6

2016-01-12 Thread Nikolaus Kern
Hello all, I have read an articl about pre-generated Views in EF. What is your experience on that topic? Is there a significant performance improvment? Thanks Niko -- Site24x7 APM Insight: Get Deep

[Firebird-net-provider] fbConnection in Windows Service

2016-01-19 Thread Nikolaus Kern
Hello, I am using Firebird .net Provider (at the moment 4.9) in a Windows Service that sends JSON data to a mobile app. The only problem there is the handling of the fbConnection. 1. There is a static class to provide the fbConnectionStringBuilder 2. Each method creates a

Re: [Firebird-net-provider] fbConnection in Windows Service

2016-01-20 Thread Nikolaus Kern
Hello all, one additional comment: The fbStringBuilder is a property of a public static class. Niko -Ursprüngliche Nachricht- Von: Nikolaus Kern [mailto:parzival1...@gmx.at] Gesendet: Donnerstag, 21. Jänner 2016 08:13 An: 'For users and developers of the Firebird .NET providers

Re: [Firebird-net-provider] fbConnection in Windows Service

2016-01-20 Thread Nikolaus Kern
Hello Jiri, this is the staketrace: NOK KALENDER: Die Auflistung wurde geändert. Der Enumerationsvorgang kann möglicherweise nicht ausgeführt werden. bei System.ThrowHelper.ThrowInvalidOperationException(ExceptionResource resource) bei

Re: [Firebird-net-provider] fbConnection in Windows Service

2016-01-22 Thread Nikolaus Kern
Hello Jiri, I solved it by using FbConnectionStringBuilder only for the static configuration like hostname, charset etc. Username and password are added to the connection string and not written to the FbConnectionstringBuilder. Different question: Is it better to use connection pooling for a

[Firebird-net-provider] Entity Framework: Best practices to work in a multiuser environment

2016-03-25 Thread Nikolaus Kern
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

[Firebird-net-provider] .net Provider and EF support for FB 3 also EF7

2016-03-05 Thread Nikolaus Kern
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

Re: [Firebird-net-provider] How to backup the remote database to a local hard disk

2016-08-16 Thread Nikolaus Kern
Hello, is there any possibility to track the progress of the backup from the remote machine? Thanks Niko -Ursprüngliche Nachricht- Von: Mark Rotteveel [mailto:m...@lawinegevaar.nl] Gesendet: Freitag, 25. März 2016 17:30 An: For users and developers of the Firebird .NET providers

[Firebird-net-provider] Detaching navigation properties

2017-03-01 Thread Nikolaus Kern
Hello, I am currently using EF 6.x with Firebird 2.5.x and it works very well. During a dataload from an external datasource I load a number of records from my database and compare them with the external source. Sometimes I have to correct/complete my data. In the case this update fails on

[Firebird-net-provider] Best practice for Rollback with EF and Firebird

2016-09-13 Thread Nikolaus Kern
Hello, what is the best practice to rollback a failed statement with EF? 1. Working with an entity in a context 2. Putting a raw SQL statement to the database via the context Is it really neccesssary to get transaction before context:SaveChanges() in order to rollback?

Re: [Firebird-net-provider] Best practice for Rollback with EF and Firebird

2016-09-21 Thread Nikolaus Kern
Hello Jiri, thanks for the fast response. I still have troubles arround clearing the context after an error happend on the database. I loop through N entities and modify them. The 3rd creates an error on the database which is reported back in an exception. Now the 4th and ongoing

Re: [Firebird-net-provider] Events

2017-01-10 Thread Nikolaus Kern
Hello Jiri, is it neccessary or recommended to dispose a FbRemoteEvent with this new release? (I assume it should be disposed) Number of events: Is this the number the program can listen to or something different? Thanks Niko -Ursprüngliche Nachricht- Von: Jiří Činčura

[Firebird-net-provider] Handling Errors with EF

2017-07-28 Thread Nikolaus Kern
Hello, I am using EF with Firebird for some time now and it works very fine. When I submit a new record via EF i wrap it into a try{} catch{} and want to to recover in a gentle way. Eg. The new record violates the PK. In this case I set the current entity to state detached. This works ok

Re: [Firebird-net-provider] Handling Errors with EF

2017-08-01 Thread Nikolaus Kern
Hello Jiri, by gentle way I mean that one failing record does not impact the following context.SaveChanges(). Yes I want to skip the failing record. If the user complets e.g. missing data and submits the data a second time I will add the entity again and save it. During a mass import of data

Re: [Firebird-net-provider] Handling Errors with EF

2017-08-01 Thread Nikolaus Kern
Hello, this is the current config: ctx.Configuration.ProxyCreationEnabled = false; // res is the main object = an employee // res.ARBEITSZEITEN are the list of past and current engagements res = ctx.RESSOURCEN.Include(z => z.ARBEITSZEITEN).FirstOrDefault(a => a.EXTERNE_ID == personalnummer);

[Firebird-net-provider] EF handling - as string parameter

2017-05-02 Thread Nikolaus Kern
Hello, I am using following query to get all workitems for a specific organisation unit: ppaQuery = "SELECT * FROM LPP_PRODUKTIONSAUFTRAEGE WHERE PRODUKTIONSSTATUS NOT IN ('Abgeschlossen','Storno') ORDER BY PRODUKTIONSAUFTRAG_ID"; tmpPPA =

Re: [Firebird-net-provider] EF handling - as string parameter

2017-05-02 Thread Nikolaus Kern
Hi, I just saw that the query and the execution do not match correct. This is the query with the parameter that creates an exception if the parameter is "Halle 6 - Schlosserei". ppaQuery = "SELECT * FROM LPP_PRODUKTIONSAUFTRAEGE WHERE PRODUKTIONSSTATUS NOT IN ('Abgeschlossen','Storno') AND

Re: [Firebird-net-provider] EF handling - as string parameter

2017-05-02 Thread Nikolaus Kern
u can also specify the Size in FbParameter. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ On Tue, May 2, 2017, at 09:58, Nikolaus Kern wrote: > Hi, > > I just saw that the query and the execution do not match correct. This > is the query with the parameter tha

Re: [Firebird-net-provider] EF handling - as string parameter

2017-05-02 Thread Nikolaus Kern
[Firebird-net-provider] EF handling - as string parameter What's the AUSLASTUNG_GEHOERT_ZU's datatype? -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ On Tue, May 2, 2017, at 11:55, Nikolaus Kern wrote: > Hello Jiri, > > thanks for the response. > > I guess I am missing