Re: [Firebird-net-provider] Error reading data from the connection Re: Firebird-net-provider Digest, Vol 139, Issue 3
I would check inner exception to see what happened. -- Mgr. Jiří Činčura https://www.tabsoverspaces.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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] ADO.NET provider 5.12.0.0
More info: https://www.tabsoverspaces.com/233658-ado-net-provider-5-12-0-0-for-firebird-is-ready/ . -- Mgr. Jiří Činčura Independent IT Specialist -- 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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] New list
> Maybe a good idea to also post instructions how to subscribe. Right. https://support.google.com/groups/answer/1067205?hl=en . -- Mgr. Jiří Činčura https://www.tabsoverspaces.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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] New list
Hi *, Because of recent changes on SourceForge we have a new list: firebird-net- provi...@googlegroups.com. Hopefully it will solve the issues of some emails not being delivered and some people being unable to post. Resubscribe there, this old list is soon going to be retired. -- Mgr. Jiří Činčura https://www.tabsoverspaces.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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Problems with list
Hi *, more and more people are having problems posting to this list (or any SF list in general). We, the Firebird project, are considering moving all the lists to Google Groups. If you have a specific idea for this list, it's time to speak. -- Mgr. Jiří Činčura https://www.tabsoverspaces.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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Gitter
Hi *, in case you'd like to talk on Gitter, I created a room: https://t.co/B81ZThgVIG . Not sure where that road goes. :) -- Mgr. Jiří Činčura https://www.tabsoverspaces.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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] ADO.NET provider 5.11.0.0
More info: https://www.tabsoverspaces.com/233642-ado-net-provider-5-11-0-0-for-firebird-is-ready-with-net-standard-2-0-support/ . -- Mgr. Jiří Činčura Independent IT Specialist -- 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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] EF - last inserted ID is 0
With DB First you can set it up in Properties the same way. Or you can use https://www.tabsoverspaces.com/230841-generated-primary-key-in-entity-framework-model-from-firebird[1]/. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ On Tue, Aug 29, 2017, at 08:44, Mr. John via Firebird-net-provider wrote:> Hi.I'm using Db first and as I found that is about code firstIf > I'm wrong> please someone give me some tips about using thatthanks. > > From: Jiří Činčura <j...@cincura.net>To: > "firebird-net-provider@lists.sourceforge.net" > <firebird-net-provider@lists.sourceforge.net>Sent: Monday, August 28,> 2017, > 2:48:44 PM GMT+3Subject: Re: [Firebird-net-provider] EF - last > inserted ID is 0 > Why so complex. Just use > https://msdn.microsoft.com/en-us/library/system.data.entity.modelconfiguration.configuration.primitivepropertyconfiguration.hasdatabasegeneratedoption(v=vs.113).aspx> > and that's it. You should consider you entities store agnostic, > in fact.> > -- > Mgr. Jiří Činčura > https://www.tabsoverspaces.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 > Firebird-net-provider@lists.sourceforge.net > 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 > Firebird-net-provider@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider Links: 1. https://www.tabsoverspaces.com/230841-generated-primary-key-in-entity-framework-model-from-firebird/ -- 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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] EF - last inserted ID is 0
Why so complex. Just use https://msdn.microsoft.com/en-us/library/system.data.entity.modelconfiguration.configuration.primitivepropertyconfiguration.hasdatabasegeneratedoption(v=vs.113).aspx and that's it. You should consider you entities store agnostic, in fact. -- Mgr. Jiří Činčura https://www.tabsoverspaces.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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] EF - last inserted ID is 0
Your myTableEnt should have Id marked as DatabaseGen…Options.Identity. Then it's fetched back automatically. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ On Fri, Aug 25, 2017, at 19:28, Mr. John via Firebird-net-provider wrote:> HiI'm using FB 2.5,EF Firebird 5.9.1,Asp MVC 5 with VS 2017 > on a table I have a trigger to generate ID: >CREATE OR ALTER TRIGGER TRIG_MYTABLE_BI FOR MYTABLE >ACTIVE BEFORE INSERT POSITION 0 AS >BEGINIF ((NEW.ID IS NULL) OR (NEW.ID=0)) >THEN NEW.ID=NEXT VALUE FOR >GEN_MYTABLE_ID; END> > in my code I insert data like this: >myTableEnt newRec= new myTableEnt(){ >NAME='MYNAME', };> > db.myTableEnt.Add(newRec); > db.SaveChanges();return ToJson(new { > msg = newRec.ID.ToString() });> newRec.ID is returned always > 0,but in database value is generatedwhat > I've done wrongthanks> > -- > > 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 > Firebird-net-provider@lists.sourceforge.net > 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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] ADO.NET provider 5.10.0.0
More info: https://www.tabsoverspaces.com/233641-ado-net-provider-5-10-0-0-for-firebird-is-ready/ . -- Mgr. Jiří Činčura Independent IT Specialist -- 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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] FbRemoteEvent
> Seems to be a problem with the install .Net framework v4.0.30319 ? Not really. Do you have all NuGet dependencies installed? -- Mgr. Jiří Činčura https://www.tabsoverspaces.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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] FbRemoteEvent
What's the complete stack trace? I copy-pasted your code to a console app and it worked fine. I only changed database name. The rest was untouched. -- Mgr. Jiří Činčura https://www.tabsoverspaces.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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Fbembed + .NET Provider 5.9.1. Memory leak?
Interesting. What's the Firebird client library version? Does the memory leak from the start of only after some time? -- Mgr. Jiří Činčura https://www.tabsoverspaces.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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Handling Errors with EF
> Stacktrace of the inner exception: > >bei >System.Data.Entity.Core.Mapping.Update.Internal.UpdateTranslator.Update() >bei > > System.Data.Entity.Core.EntityClient.Internal.EntityAdapter.b__2(UpdateTranslator >ut) >bei >System.Data.Entity.Core.EntityClient.Internal.EntityAdapter.Update[T](T >noChangesResult, Func`2 updateFunction) >bei >System.Data.Entity.Core.EntityClient.Internal.EntityAdapter.Update() >bei >System.Data.Entity.Core.Objects.ObjectContext.b__35() >bei > > System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func`1 >func, IDbExecutionStrategy executionStrategy, Boolean >startLocalTransaction, Boolean releaseConnectionOnSuccess) >bei > > System.Data.Entity.Core.Objects.ObjectContext.SaveChangesToStore(SaveOptions >options, IDbExecutionStrategy executionStrategy, Boolean >startLocalTransaction) >bei > > System.Data.Entity.Core.Objects.ObjectContext.<>c__DisplayClass2a.b__27() >bei > > System.Data.Entity.Infrastructure.DefaultExecutionStrategy.Execute[TResult](Func`1 >operation) >bei > > System.Data.Entity.Core.Objects.ObjectContext.SaveChangesInternal(SaveOptions >options, Boolean executeInExistingTransaction) >bei >System.Data.Entity.Core.Objects.ObjectContext.SaveChanges(SaveOptions >options) >bei System.Data.Entity.Internal.InternalContext.SaveChanges() This is from SaveChanges. It's not related to setting state to Detached. -- Mgr. Jiří Činčura https://www.tabsoverspaces.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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Handling Errors with EF
> If I want to loop through the navigation property directy (without > copying it to another List) is there a way to do this? I don#t > understand the collection changed error, because I do not add or remove > an item from the list. I am changing the Entitystate. What's the exception stack trace? That should work out of the box (with the proxies turned off). -- Mgr. Jiří Činčura https://www.tabsoverspaces.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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Handling Errors with EF
> I would like to understand if there is a better way to handle the > relation between the main entitiy and navigation properties when a > SaveChanges() fails. It's generally expected that every change in DbContext (and hence in UOW) will be saved. The user will eventually fix all validation violations. Hence the skipping is kind of non-standard scenario. Detaching the graph is then correct solution. Sadly you have to detach the whole graph manually (https://msdn.microsoft.com/en-us/library/system.data.objects.objectcontext.detach(v=vs.110).aspx). Given the DbContext is the UOW these no way to disconnect these - have one DbContext with multiple UOWs (where you'd discard that UOW with violations and continue saving). Or course poor man's solution would be to create bunch of DbContexts, but I'm afraid that would hurt performance and add complexity on the other side with attaching. -- Mgr. Jiří Činčura https://www.tabsoverspaces.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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Handling Errors with EF
What do you mean by "gentle way". You want to skip that record? Or skip all pending changes? Also do you have proxy creation enabled? -- Mgr. Jiří Činčura https://www.tabsoverspaces.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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] FbTrace for Firebird 3
> Option 2 - ctor with target version sounds the best. You could name pre3 > version enum "Version1" and the new format "Version2" so it's not linked > to > FB version. That sounds good. Maybe confusing for new developers, but what you can do, right? > A nice to have would be to have default enum value be "DetectVersion" > which > would do the roundtrip server check. I'm bit worried about having it as default. Convenient, yes, but hidden perf problem. Though not sure it matters on FbTrace much. -- Mgr. Jiří Činčura https://www.tabsoverspaces.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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] FbTrace for Firebird 3
Hi *, Firebird 3 changed the format for trace configuration (yeah, I know) and thus the FbTrace now needs to handle this. I'm currently banging my head how to nicely present it to you - developers. I came up with these solutions. 1. Provide 2 methods for starting. Like StartPre3 and Start. I like that it's discoverable from IntelliSense. And it's just a different method to call for developer. 2. Have Start method or ctor take enum with target version. Not sure about the naming though. Putting "3" might become confusing when v4 comes out (hopefully without format change). 3. Have different FbDatabaseTraceConfiguration classes and developer needs to instantiate correct one. I don't feel this is a clean design (not that the format change was a good design...). 4. Have a FbTrace and FbTrace3 (for example). Again as in 3. Maybe bit easier to discover. Don't like the idea of another class that will be there "forever". 5. Before connecting automagically check server version. Although most pleasant from outside, I don't like the idea of extra roundtrip to get this information. Ideas? -- Mgr. Jiří Činčura https://www.tabsoverspaces.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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Connecting to encrypted databases
> Binary data should be able to be represented with hexadecimal. And, Good point. > We are looking at implementing our own encryption plugin, but still > undecided how the key will be passed, since our application uses a mix > of Delphi(IBDAC) and C#(EF6). Our initial thought is that it will have > to be on the server with the database, since we can't find proper > documentation on how to pass it from the client, even with the > database management tools, although it is part of Firebird's > architecture. It seems to be one area that third-party tools and Look at op_crypt_key_callback. > And, I'm hoping that I will have the time in the next few weeks to > create a VSIX installer for DDEX, because the registry entries are not > staying and I have to add them everytime that I need to add EF6 classes > to represent tables. Once created, it will surely be contributed to > the project. Great. -- Mgr. Jiří Činčura https://www.tabsoverspaces.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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Global event on connection open
Hi *, I had a conversation with long time Firebird user. They I'd like to see very easy feature - global event that fires when some FbConnection is opened. The motivation is that sometimes there's some connection being opened from weird or wrong place and this would allow to hunt it down. What do you think? I wish I could even pass that information to MON$ATTACHMENTS. -- Mgr. Jiří Činčura https://www.tabsoverspaces.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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Connecting to encrypted databases
> Which would not be true anymore, except if you add EncryptionKey to > connection string parsing anyway. Of course I would. The builder and connection string options are in sync. -- Mgr. Jiří Činčura https://www.tabsoverspaces.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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Connecting to encrypted databases
> What about a callback on Connection that returns a Connection Info > (ConnectionStringBuilder-like) object. > Could also add a connection constructor overload that accepts a > Connection > Info object. > Can then provide all connection data in one place with convenience of not > converting from/to a string. Then the ConnectionStringBuilder can be used right away, no? -- Mgr. Jiří Činčura https://www.tabsoverspaces.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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Connecting to encrypted databases
Hi *, thanks to IBPhoenix I have an plugin (http://www.ibphoenix.com/products/software/encryptionplugin) to create encrypted database and I have a working prototype for passing the key. Now the question of the day. :) How to pass the key? The two obvious options are in connection string and callback on i.e. FbConnection. The callback seems to be an obvious choice, because it's most versatile. But I'd like to hear some other opinions as well. -- Mgr. Jiří Činčura https://www.tabsoverspaces.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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Entity Update-Database not working
Mark basically already responded to you. The full explanation in the answer: https://stackoverflow.com/questions/44266141/entity-framework-code-first-migrations-and-firebird/44280925#44280925 . -- Mgr. Jiří Činčura https://www.tabsoverspaces.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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] ADO.NET provider 5.9.1.0
More info: https://www.tabsoverspaces.com/233624-ado-net-provider-5-9-1-0-for-firebird-is-ready/ . -- Mgr. Jiří Činčura Independent IT Specialist -- 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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] .NET 4 support
OK, there doesn't seem to be any more discussion around this. And because, as stated before, MS is not going to support 4.0 (and also 4.7 is now out for all systems), the minimum supported version in next major version will be 4.5.2. If somebody wants the 4.0 the previous versions are always available. Any questions? -- Mgr. Jiří Činčura https://www.tabsoverspaces.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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] ADO.NET provider 5.9.0.0
More info: https://www.tabsoverspaces.com/233620-ado-net-provider-5-9-0-0-for-firebird-is-ready/ . -- Mgr. Jiří Činčura Independent IT Specialist -- 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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] EF handling - as string parameter
> Can you please add 1 line to describe the difference between using {0} > vs. @p0 ? Well, AFAIK only the @p0 is supported. Maybe the {0} works as well, but I know only about the @p0 from documentation. Of course we can check EF6 sources, but I'm too lazy to do that. :D -- Mgr. Jiří Činčura https://www.tabsoverspaces.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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [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 something here. The code below produces the same > error as {0}. > > ppaQuery = "SELECT * FROM LPP_PRODUKTIONSAUFTRAEGE WHERE > PRODUKTIONSSTATUS NOT IN ('Abgeschlossen','Storno') AND > AUSLASTUNG_GEHOERT_ZU = @p0 ORDER BY PRODUKTIONSAUFTRAG_ID"; > tmpPPA = this._ctx.LPP_PRODUKTIONSAUFTRAEGE.SqlQuery(ppaQuery, new > object[]{this.CurrentHalle}).ToList(); > > If I copy the query to the SQL tool and execute the query it works fine > (even when it does not return a record, which is also the case in other > working queries). > SELECT * FROM LPP_PRODUKTIONSAUFTRAEGE WHERE PRODUKTIONSSTATUS NOT IN > ('Abgeschlossen','Storno') AND AUSLASTUNG_GEHOERT_ZU = 'Halle 6 - > Schlosserei' ORDER BY PRODUKTIONSAUFTRAG_ID > > Do you have an idea whats missing? > > Thanks > > Niko > > -Ursprüngliche Nachricht- > Von: Jiří Činčura [mailto:j...@cincura.net] > Gesendet: Dienstag, 2. Mai 2017 10:02 > An: firebird-net-provider@lists.sourceforge.net > Betreff: Re: [Firebird-net-provider] EF handling - as string parameter > > You should use @p0 instead of {0} > (https://msdn.microsoft.com/en-us/library/system.data.entity.dbset.sqlquery%28v=vs.113%29.aspx). > Optionally you 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 that creates an exception if the > > parameter is "Halle 6 - Schlosserei". > > > > ppaQuery = "SELECT * FROM LPP_PRODUKTIONSAUFTRAEGE WHERE > > PRODUKTIONSSTATUS NOT IN ('Abgeschlossen','Storno') AND > > AUSLASTUNG_GEHOERT_ZU = {0} ORDER BY PRODUKTIONSAUFTRAG_ID"; tmpPPA = > > this._ctx.LPP_PRODUKTIONSAUFTRAEGE.SqlQuery(ppaQuery, > > this.CurrentHalle).ToList(); > > > > Niko > > > > -Ursprüngliche Nachricht- > > Von: Jiří Činčura [mailto:j...@cincura.net] > > Gesendet: Dienstag, 2. Mai 2017 09:43 > > An: firebird-net-provider@lists.sourceforge.net > > Betreff: Re: [Firebird-net-provider] EF handling - as string parameter > > > > What parameter? I don't see any parameter in the query. > > > > -- > > Mgr. Jiří Činčura > > https://www.tabsoverspaces.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 > > Firebird-net-provider@lists.sourceforge.net > > 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 > > Firebird-net-provider@lists.sourceforge.net > > 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 > Firebird-net-provider@lists.sourceforge.net > 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 > Firebird-net-provider@lists.sourceforge.net > 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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] EF handling - as string parameter
You should use @p0 instead of {0} (https://msdn.microsoft.com/en-us/library/system.data.entity.dbset.sqlquery%28v=vs.113%29.aspx). Optionally you 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 that creates an exception if the parameter > is "Halle 6 - Schlosserei". > > ppaQuery = "SELECT * FROM LPP_PRODUKTIONSAUFTRAEGE WHERE > PRODUKTIONSSTATUS NOT IN ('Abgeschlossen','Storno') AND > AUSLASTUNG_GEHOERT_ZU = {0} ORDER BY PRODUKTIONSAUFTRAG_ID"; > tmpPPA = this._ctx.LPP_PRODUKTIONSAUFTRAEGE.SqlQuery(ppaQuery, > this.CurrentHalle).ToList(); > > Niko > > -Ursprüngliche Nachricht- > Von: Jiří Činčura [mailto:j...@cincura.net] > Gesendet: Dienstag, 2. Mai 2017 09:43 > An: firebird-net-provider@lists.sourceforge.net > Betreff: Re: [Firebird-net-provider] EF handling - as string parameter > > What parameter? I don't see any parameter in the query. > > -- > Mgr. Jiří Činčura > https://www.tabsoverspaces.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 > Firebird-net-provider@lists.sourceforge.net > 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 > Firebird-net-provider@lists.sourceforge.net > 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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] EF handling - as string parameter
What parameter? I don't see any parameter in the query. -- Mgr. Jiří Činčura https://www.tabsoverspaces.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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] About GUIDs in Firebird
After a lot of thinking and considering pros and cons, I decided to do the change. It's going to be painful, especially for people already using it, but the least surprise principle here is strong argument in my head. Also because there are some big changes in Firebird 3 itself (like this https://www.tabsoverspaces.com/233552-gotcha-with-firebird-3-count-and-executescalar-common-casting-pattern/), it's better to do it sooner than later. Thus very likely next _major_ version will contain this change. -- Mgr. Jiří Činčura https://www.tabsoverspaces.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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Problem creating the code with EF6 Code First from Database
> But, what could cause it not to recognize those fields properly? > Because when I look in the database's system tables, the > RDB$FIELD_TYPE and RDB$FIELD_LENGTH both have values in them, one > would be VARCHAR(132) and the others would be CHAR(1). Don't know. If you can confirm it's really those fields, put it to tracker and I'll look at it. -- Mgr. Jiří Činčura https://www.tabsoverspaces.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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Problem creating the code with EF6 Code First from Database
> I was starting to suspect that, since the other tables that I was able > to generate the code for didn't have computed fields. Are there any > hints that I can use? > > I can try to look at the code to see if I can fix the problem. And, > since I never did look inside the ADO.Net driver code. Can you guide > me to what would be the area of code that I would need to look at? > > I'm willing to try to fix the problem, since this is not the only > table in that database that has computed fields. You can create a table without computed field, generate the CF for it. And then do the same for a table with computed field. -- Mgr. Jiří Činčura https://www.tabsoverspaces.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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Problem creating the code with EF6 Code First from Database
My *guess* is that it's the computed columns and the length is not discovered properly. -- Mgr. Jiří Činčura https://www.tabsoverspaces.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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] RES: ADO.NET provider 5.8.1.0
You need new csproj support, aka VS2017. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ On Thu, Apr 6, 2017, at 13:37, Nicolas Timmers wrote: > Hello Jiri > > When i try to open the solution from version 5.8.1.0 I get the fallowing > message > > C:\temp\TEMP\Provider\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdSql.Data.FirebirdClient_NET45.csproj > : error : The default XML namespace of the project must be the MSBuild > XML namespace. If the project is authored in the MSBuild 2003 format, > please add xmlns="http://schemas.microsoft.com/developer/msbuild/2003; to > the element. If the project has been authored in the old 1.0 or > 1.2 format, please convert it to MSBuild 2003 format. > C:\temp\TEMP\Provider\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdSql.Data.FirebirdClient_NET45.csproj > > > And the solution cannot be open, how can I proceed ? > > > -Mensagem original- > De: Jiří Činčura [mailto:j...@cincura.net] > Enviada em: quarta-feira, 5 de abril de 2017 03:13 > Para: For users & developers of the Firebird .NET providers > <firebird-net-provider@lists.sourceforge.net> > Cc: firebird-to...@yahoogroups.com; For discussion among Firebird > Developers <firebird-de...@lists.sourceforge.net> > Assunto: [Firebird-net-provider] ADO.NET provider 5.8.1.0 > > More info: > https://www.tabsoverspaces.com/233609-ado-net-provider-5-8-1-0-for-firebird-is-ready/ > . > > -- > Mgr. Jiří Činčura > Independent IT Specialist > > -- > 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 > Firebird-net-provider@lists.sourceforge.net > 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 > Firebird-net-provider@lists.sourceforge.net > 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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] ADO.NET provider 5.8.1.0
More info: https://www.tabsoverspaces.com/233609-ado-net-provider-5-8-1-0-for-firebird-is-ready/ . -- Mgr. Jiří Činčura Independent IT Specialist -- 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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Installing DDEX provider for Firebird into Visual Studio 2017
This might help you with DDEX and VS2017. https://www.tabsoverspaces.com/233604-installing-ddex-provider-for-firebird-into-visual-studio-2017/ -- Mgr. Jiří Činčura https://www.tabsoverspaces.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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Create Database Tables
> 1) Is it correct to have multiple fbCmd.ExecuteNonQuery() commands ... > followed by one fbTransaction.Commit()? Yes. Also use `using` block for disposable resource. > 2) I want to be able to handle German vowels, such as umlauts, for > fstInfo. I don't think VARCHAR is the correct choice as it is > non-unicode. You can use CHARACTER SET clause. Best is probably to use UTF8. > 3) I also want variable lengths, without a max, for fstInfo. What do > I use in place of the "100"? Then you have to use BLOB SUB_TYPE TEXT. -- Mgr. Jiří Činčura https://www.tabsoverspaces.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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] [firebird net] Install Firebird / Create Database File
> Firebird Embedded on windows does not check for username and password, > so you can leave them out. For a normal Firebird server, username is > case insensitive, but password - of course - is case sensitive. But the grants are still followed. So username/role is important, password not much. -- Mgr. Jiří Činčura https://www.tabsoverspaces.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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] [firebird net] Install Firebird / Create Database File
> 4) I'm struggling to find details about FbConnection.CreateDatabase on > the Firebird Document site. > > Apparently the order is ... connection details (string), page size > (int), force writes (bool), overwrite (bool). https://github.com/cincuranet/FirebirdSql.Data.FirebirdClient/blob/master/Provider/src/FirebirdSql.Data.FirebirdClient/FirebirdClient/FbConnection.cs#L64 > The connection string has reserved words, Database, ServerType, etc. > > Is there a site that clarifies all of the reserved words / options / > defaults? I'd like to document this info while it is still fresh in > my mind ... for future projects. https://github.com/cincuranet/FirebirdSql.Data.FirebirdClient/blob/master/Provider/src/FirebirdSql.Data.FirebirdClient/FirebirdClient/FbConnectionString.cs#L88 -- Mgr. Jiří Činčura https://www.tabsoverspaces.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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] [firebird net] Install Firebird / Create Database File
> FirebirdSql.Data.FirebirdClient.5.8.0 subdir ... with Firebird .dll's. To be precise, it's provider, not Firebird. > 1) Was the the correct procedure? Yes. > 2) How do I create a Firebird database file? ... as I did with SQLite > ... System.Data.SQLite.SQLiteConnection.CreateFile(stPathFilename) > where the filename ends with .sqlite. FbConnection.CreateDatabase. -- Mgr. Jiří Činčura https://www.tabsoverspaces.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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Problem with setup in VS 2015
> Also, what is the timeline to support VS 2017? I tried by simply > changing the registry keys from 14_Config to 15_Config, but that > simply created a 15_Config registry key that only contained the > registry keys for Firebird, and nothing else. It looks like that they > have changed how the integration works. Great. Something I don't want to hear. :) Hopefully it's just the registry keys, not the whole DDEX story. Although I wouldn't mind fresh API for that, preferably fully managed. > I can add the VS2017 support request to the tracker, just let me know > under which component(s) that would be appropriate. It' already there under DNET-739. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ -- Announcing the Oxford Dictionaries API! The API offers world-renowned dictionary content that is easy and intuitive to access. Sign up for an account today to start using our lexical data to power your apps and projects. Get started today and enter our developer competition. http://sdm.link/oxford ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Problem with setup in VS 2015
Known mistake. Your machine config entry and GAC does not match. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ On Wed, Mar 8, 2017, at 18:28, Paul Dryden wrote: > Hi, > > I was able to get Firebird to show up in the provider list by copying an > setting to my app.config file. I found that setting > somewhere on the web. But that didn't wok either. Whenever I type > anything into an input field, the dialog disappears. Very frustrating. > > > On 3/7/2017 2:12 PM, Daniel Rail wrote: > > Hi all, > > > > I was able to connect in VS2015 and create some classes to represent a > > few tables(from an existing database) by using the "ADO.Net Entity > > Model" template, by using the "Code First from Database". > > > > But, something happened(and I don't know what) that now I can't get > > the Firebird ADO.Net driver to show up in the connection dialog for > > the "ADO.Net Entity Model" template or even to add connections in the > > VS2015 Server Explorer. I reinstalled the Firebird DDEX(3.0.2), and > > even ran the .reg files manually, and the Firebird ADO.Net(5.8.0.0) > > driver but no success. I even checked machine.config and all the > > entries are there. In the project, the Firebird drivers are added via > > NuGet. > > > > Also, this is on the latest version of Windows 10 and VS2015 is up to > > date. > > > > Is there anything else that I need to look at? If more information is > > needed, let me know. > > > > -- > Announcing the Oxford Dictionaries API! The API offers world-renowned > dictionary content that is easy and intuitive to access. Sign up for an > account today to start using our lexical data to power your apps and > projects. Get started today and enter our developer competition. > http://sdm.link/oxford > ___ > Firebird-net-provider mailing list > Firebird-net-provider@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- Announcing the Oxford Dictionaries API! The API offers world-renowned dictionary content that is easy and intuitive to access. Sign up for an account today to start using our lexical data to power your apps and projects. Get started today and enter our developer competition. http://sdm.link/oxford ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Problem with setup in VS 2015
Check whether the registry entries are there (for VS2015). -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ On Tue, Mar 7, 2017, at 22:12, Daniel Rail wrote: > Hi all, > > I was able to connect in VS2015 and create some classes to represent a > few tables(from an existing database) by using the "ADO.Net Entity > Model" template, by using the "Code First from Database". > > But, something happened(and I don't know what) that now I can't get > the Firebird ADO.Net driver to show up in the connection dialog for > the "ADO.Net Entity Model" template or even to add connections in the > VS2015 Server Explorer. I reinstalled the Firebird DDEX(3.0.2), and > even ran the .reg files manually, and the Firebird ADO.Net(5.8.0.0) > driver but no success. I even checked machine.config and all the > entries are there. In the project, the Firebird drivers are added via > NuGet. > > Also, this is on the latest version of Windows 10 and VS2015 is up to > date. > > Is there anything else that I need to look at? If more information is > needed, let me know. > > -- > Best regards, > Daniel Rail > Senior System Engineer > ACCRA Solutions Inc. (www.accra.ca) > ACCRA Med Software Inc. (www.filopto.com) > > > -- > Announcing the Oxford Dictionaries API! The API offers world-renowned > dictionary content that is easy and intuitive to access. Sign up for an > account today to start using our lexical data to power your apps and > projects. Get started today and enter our developer competition. > http://sdm.link/oxford > ___ > Firebird-net-provider mailing list > Firebird-net-provider@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- Announcing the Oxford Dictionaries API! The API offers world-renowned dictionary content that is easy and intuitive to access. Sign up for an account today to start using our lexical data to power your apps and projects. Get started today and enter our developer competition. http://sdm.link/oxford ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Detaching navigation properties
Do you really have to detach? Wouldn't work for you just fine to set the state to unchanged (nor sure what's done with the entities after)? Other than that, I believe putting it into list/array is OK (at least for me). You might even just use ToList method and foreach on that, without the extra variable - but the intermediate list will be created anyway, so it's just a cosmetic thing. -- Mgr. Jiří Činčura https://blog.cincura.net/ -- 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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] FirebirdSql.Data.Services demands SYSDBA to list users, where RDB$ADMIN insufficient?
> if ((_csManager?.Role.Length ?? 0) != 0) > spb.Append((byte)IscCodes.isc_spb_sql_role_name, _csManager.Role); > > That being said, it doesn't seem to have an effect and even if logged in > with role RDB$ADMIN, only the given user is returned (other than if > SYSDBA). > > Thoughts? Is there any way to list the users? > > If not, can it be added as a features that if logged in with RDB$ADMIN > role, that the users can be listed? Sure. But do your work and find what needs to be changed. Maybe the role needs to be passed in other place and not only in SPB. -- Mgr. Jiří Činčura Independent IT Specialist -- 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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] FirebirdSql.Data.Services demands SYSDBA to list users, where RDB$ADMIN insufficient?
> This is different from how things work in gsec. There, enumeration of > users > IS possible by connecting via the RDB$ADMIN role; > >gsec -user MyAdm -pass admpw -role rdb$admin -display This gsec command is not connecting to remote database using services API. -- Mgr. Jiří Činčura Independent IT Specialist -- 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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] ADO.NET provider 5.8.0.0
More info: http://blog.cincura.net/233594-ado-net-provider-5-8-0-0-for-firebird-is-ready/ . -- Mgr. Jiří Činčura Independent IT Specialist -- 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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Slow query
How the Delphi code looks like? -- Mgr. Jiří Činčura Independent IT Specialist -- 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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Slow query
> I feel, the number of records (or number of varchar columns) grows, so > does the difference between C# and Delphi. You feel or can you confirm it? Did you tried i.e. selecting just NULL? -- Mgr. Jiří Činčura Independent IT Specialist -- 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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] RES: CORE4563
> But I'm thinking of upgrading to version 5.7 but I no longer find the > part of the code, Did you at least try to grep the sources? It's like one second operation and easy result. It's in https://github.com/cincuranet/FirebirdSql.Data.FirebirdClient/blob/master/Provider/src/FirebirdSql.Data.FirebirdClient/Client/Managed/Version10/GdsStatement.cs#L778 . > Is very important this change because I have no feasibility to change the > whole system where the parameters are passed to put the size of the > field, is there a solution to this? I would strongly advice you to fix your code, instead of band-aiding sources. Your hack is very dangerous and you will eventually loose data. -- Mgr. Jiří Činčura Independent IT Specialist -- 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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] CORE4563
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 > Firebird-net-provider@lists.sourceforge.net > 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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Firebird Net Provider very slow with blob fields
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" <j...@cincura.net> 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" <j...@cincura.net> 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 > > > > > Firebird-net-provider@lists.sourceforge.net > > > > > 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 > > > > Firebird-net-provider@lists.sourceforge.net > > > > 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 > > > Firebird-net-provider@lists.sourceforge.net > > > 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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Firebird Net Provider very slow with blob fields
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" <j...@cincura.net> 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 > > > Firebird-net-provider@lists.sourceforge.net > > > 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 > > Firebird-net-provider@lists.sourceforge.net > > 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 > Firebird-net-provider@lists.sourceforge.net > 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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Firebird Net Provider very slow with blob fields
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 > Firebird-net-provider@lists.sourceforge.net > 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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Entity Framework 6
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 -- 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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Entity Framework 6
> 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 -- 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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Entity Framework 6
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 > Firebird-net-provider@lists.sourceforge.net > 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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] FB 3 embedded Missing security context
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 -- 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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] FB 3 embedded Missing security context
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 > Firebird-net-provider@lists.sourceforge.net > 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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Entity Framework 5
OK, looks like this is not a problem, so I created DNET-732 for it and it will eventually happen. -- Mgr. Jiří Činčura Independent IT Specialist On Tue, Jan 10, 2017, at 18:27, Jiří Činčura wrote: > > Too much effort? > > Correct. > > Currently MS's story is only EF6 and EFCore so I don't want to waste too > much of my free time on anything extra. Considering the move to EF6 from > EF5 is not that difficult I don't see much reasons to keep it (and there > has been plenty of time to do it). And of course there are always > previous versions available. > > -- > Mgr. Jiří Činčura > Independent IT Specialist > > -- > Developer Access Program for Intel Xeon Phi Processors > Access to Intel Xeon Phi processor-based developer platforms. > With one year of Intel Parallel Studio XE. > Training and support from Colfax. > Order your platform today. http://sdm.link/xeonphi > ___ > Firebird-net-provider mailing list > Firebird-net-provider@lists.sourceforge.net > 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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] .NET 4 support
Hello *, reading the === As previously announced, starting January 12, 2016 Microsoft will no longer provide security updates, technical support or hotfixes for .NET 4, 4.5, and 4.5.1 frameworks. All other framework versions, including 3.5, 4.5.2, 4.6 and 4.6.1, will be supported for the duration of their established lifecycle. The decision to end support for these versions will allow us to invest more resources towards improvements of the .NET Framework. === makes me wonder who here is using strictly 4.0, still one year after it's no longer supported. ;) It would make my life easier to drop .NET 4 support and invest my resources to moving forward faster. 4.5.2+ would still be supported, of course. -- Mgr. Jiří Činčura Independent IT Specialist -- Developer Access Program for Intel Xeon Phi Processors Access to Intel Xeon Phi processor-based developer platforms. With one year of Intel Parallel Studio XE. Training and support from Colfax. Order your platform today. http://sdm.link/xeonphi___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] About GUIDs in Firebird
> I may have missed the point or I'm not aware of all the details here but > trying to use a GUID in its string representation is a failure by itself. Thank you! > Is there a case where this is needed because doing it right (using a Guid > as its type and not as string) and use parameters isn't possible? I'm not aware of any. Except when you want to show the Guid for some logging/debugging purposes and you're looking for it in database. But still... -- Mgr. Jiří Činčura Independent IT Specialist -- Developer Access Program for Intel Xeon Phi Processors Access to Intel Xeon Phi processor-based developer platforms. With one year of Intel Parallel Studio XE. Training and support from Colfax. Order your platform today. http://sdm.link/xeonphi ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Entity Framework 5
> Too much effort? Correct. Currently MS's story is only EF6 and EFCore so I don't want to waste too much of my free time on anything extra. Considering the move to EF6 from EF5 is not that difficult I don't see much reasons to keep it (and there has been plenty of time to do it). And of course there are always previous versions available. -- Mgr. Jiří Činčura Independent IT Specialist -- Developer Access Program for Intel Xeon Phi Processors Access to Intel Xeon Phi processor-based developer platforms. With one year of Intel Parallel Studio XE. Training and support from Colfax. Order your platform today. http://sdm.link/xeonphi ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Entity Framework 5
> Have you considered supporting two separate libraries? In two separate > branches/nuget and so on? Not really. -- Mgr. Jiří Činčura Independent IT Specialist -- Developer Access Program for Intel Xeon Phi Processors Access to Intel Xeon Phi processor-based developer platforms. With one year of Intel Parallel Studio XE. Training and support from Colfax. Order your platform today. http://sdm.link/xeonphi ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] About GUIDs in Firebird
Hi *, we have this ticket DNET-509 in tracker. Although I agree the change would be nice, it's also a breaking change as huge as it can get. What's your take on it? Or do you see clean way out? -- Mgr. Jiří Činčura Independent IT Specialist -- Developer Access Program for Intel Xeon Phi Processors Access to Intel Xeon Phi processor-based developer platforms. With one year of Intel Parallel Studio XE. Training and support from Colfax. Order your platform today. http://sdm.link/xeonphi ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Fill Method of FbDataAdapter fails
> I think I am running out of memory which leads to the connection being > terminated. > In such a case the Exception should be Out of Memory. > Possibly the Exception caught is incorrect. > Can this be confirmed please. Yes it can. -- Mgr. Jiří Činčura Independent IT Specialist -- Developer Access Program for Intel Xeon Phi Processors Access to Intel Xeon Phi processor-based developer platforms. With one year of Intel Parallel Studio XE. Training and support from Colfax. Order your platform today. http://sdm.link/xeonphi ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Events
Hi *, The events code was not much reliable and I recently got time to work on it to improve it. So in foreseeable future the changes from `events` branch will be merged and new version will be released. Given it's breaking changes it's going to be very very likely new major version. Here's a simple demo code to see how it works now: https://github.com/cincuranet/FirebirdSql.Data.FirebirdClient/blob/events/Provider/src/FirebirdSql.Data.UnitTests/FbRemoteEventTests.cs#L40 The major changes are: * Number of events is now limited to ushort.MaxValue. FTW! * FbRemoteEvent now takes connection string instead of FbConnection (so it's connection independent). * It implements IDisposable. * The RemoteEventCounts event is fired for every event fired with some count (aka Count > 0). * There's a new event RemoteEventError allowing you to be notified in case i.e. the events channel is broken and exception is thrown. * No extra threads are created or used. That's about it. Questions? -- Mgr. Jiří Činčura Independent IT Specialist -- Developer Access Program for Intel Xeon Phi Processors Access to Intel Xeon Phi processor-based developer platforms. With one year of Intel Parallel Studio XE. Training and support from Colfax. Order your platform today. http://sdm.link/xeonphi ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Entity Framework 5
Hi *, anybody still using EF5 (or even EF4)? Or is everybody on EF6... Thinking about slimming the FirebirdSql.Data.FirebirdClient and removing the old EF support and keeping only EF6 (EntityFramework.Firebird). -- Mgr. Jiří Činčura Independent IT Specialist -- 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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Firing event when event count is 0
Server sends whole buffer with all registered events. Some are sometimes obviously 0 (or actually last count, because in server it's incremental), if not fired, but still in buffer. -- Mgr. Jiří Činčura Independent IT Specialist On Fri, Dec 16, 2016, at 15:48, Ivan Arabadzhiev wrote: > Why would the engine throw such an event in the first place? > Does it have > an actual reason or is it a bug to be fixed? I don't think the > provider > should just ignore server messages sent on purpose, but there > might be an > actual option on whether the current user actually needs them or not. > > 2016-12-16 16:18 GMT+02:00 Alexander Muylaert-Gelein < > amuylaert_gel...@hotmail.com>: > > > I say ney. It doesn’t make sense to raise unraised events. > > > > > > > > Sent from Mail <https://go.microsoft.com/fwlink/?LinkId=550986> for > > Windows 10 > > > > > > > > *From: *Jiří Činčura <j...@cincura.net> > > *Sent: *vrijdag 16 december 2016 17:15 > > *To: *For users & developers of the Firebird .NET providers > > <firebird-net-provider@lists.sourceforge.net> > > *Subject: *[Firebird-net-provider] Firing event when event > > count is 0 > > > > > > Hi *, > > > > As I'm now reworking some pieces in events (together with > > finalizers), > > I'm wondering whether it make sense to fire the event for > > events when > > the event count was 0. From outside POV it doesn't make much sense. > > > > What do you think? > > > > -- > > Mgr. Jiří Činčura > > Independent IT Specialist > > > > > > -- > > 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 > > Firebird-net-provider@lists.sourceforge.net > > 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 > > Firebird-net-provider@lists.sourceforge.net > > 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 > Firebird-net-provider@lists.sourceforge.net > 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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Firing event when event count is 0
Hi *, As I'm now reworking some pieces in events (together with finalizers), I'm wondering whether it make sense to fire the event for events when the event count was 0. From outside POV it doesn't make much sense. What do you think? -- Mgr. Jiří Činčura Independent IT Specialist -- 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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] New Authentication for Firebird 3
Can you connect with telnet? Is the Firebird port opened on firewall? Basic network error triage… -- Mgr. Jiří Činčura Independent IT Specialist On Fri, Dec 9, 2016, at 05:15, LtColRDSChauhan wrote: > Hi, > > 1. I installed Firebird-3.0.1.32609_0_Win32 without opting to support > legacy user. After installation i could connect my database > through ISQL > and Flamerobin but my .NET application failed reporting: > > incompatible wire cryption levels for client and server > so to the firebird.conf file i added the following and re-started > firebird > service : > WireCrypt Enabled > > 2. Now on the server machine "SERVER_MACHINE" database gets >connected but > from other machine "CLIENT_MACHINE" error reported: > unable to complete network request to "SERVER_MACHINE". > I could ping the "SERVER_MACHINE" from "CLIENT_MACHINE" and flamerobin > could connect to database on "SERVER_MACHINE" from "CLIENT_MACHINE". > > 3. Made following changes to the firebird.conf file still from the > "CLIENT_MACHINE" i get error repeated - unable to complete network > request > to "SERVER_MACHINE" > > UserManager = Legacy_UserManager > WireCrypt = Disabled > AuthServer = Legacy_Auth, Srp, Win_Sspi > AuthClient = Legacy_Auth, Srp, Win_Sspi > TracePlugin = fbtrace > Providers = Remote,Engine12,Loopback > WireCryptPlugin = Arc4 > > 4. Please help me to set up correctly New Authentication for >Firebird 3 > for > the "CLIENT_MACHINE" . > > Regards, > Rajiv > -- > > Developer Access Program for Intel Xeon Phi Processors > Access to Intel Xeon Phi processor-based developer platforms. > With one year of Intel Parallel Studio XE. > Training and support from Colfax. > Order your platform today.http://sdm.link/xeonphi > ___ > Firebird-net-provider mailing list > Firebird-net-provider@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- Developer Access Program for Intel Xeon Phi Processors Access to Intel Xeon Phi processor-based developer platforms. With one year of Intel Parallel Studio XE. Training and support from Colfax. Order your platform today.http://sdm.link/xeonphi___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] FbStreamingBackup Fails Now
Regular FbConnection works? Did you tried plain telnet? -- Mgr. Jiří Činčura Independent IT Specialist On Thu, Dec 8, 2016, at 03:35, LtColRDSChauhan wrote: > Hi, > > 1. I had been backing up using FbStreamingBackup since quite some >time. > Recently it fails. The message reported is: > > Unable to complete network request to host " > No message for error code 335544721 found. > > 2. The ConnectionString of FbStreamingBackup at break point before > Execute > is called has the following value: > > user=SYSDBA;password="abcdef"; > database=D:\abc\AppAbc\ABCFireBird\ABC.FDB; > datasource=MyPC;port=3050; > dialect=3;charset=NONE;connection lifetime=15; > compression=True; > pooling=true;minpoolsize=5;maxpoolsize=50; > packet size=8192;servertype=Default > > 3. I have checked up after removing compression=True; error remains. I > have > allowed the port 3050, the fire bird service and my .NET > application to > communicate through windows firewall. > > 4. Please help. > > Regards, > Rajiv > -- > > Developer Access Program for Intel Xeon Phi Processors > Access to Intel Xeon Phi processor-based developer platforms. > With one year of Intel Parallel Studio XE. > Training and support from Colfax. > Order your platform today.http://sdm.link/xeonphi > ___ > Firebird-net-provider mailing list > Firebird-net-provider@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- Developer Access Program for Intel Xeon Phi Processors Access to Intel Xeon Phi processor-based developer platforms. With one year of Intel Parallel Studio XE. Training and support from Colfax. Order your platform today.http://sdm.link/xeonphi___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] .NET provider and embedded server
Use `Client Library` parameter. -- Mgr. Jiří Činčura Independent IT Specialist On Mon, Nov 14, 2016, at 19:20, Wolfgang Riedmann wrote: > Hello, > > I've tried to use the latest .NET provider for Firebird with Firebird > 3.01. Unfortunately on connecting to a database the driver complains that > it cannot find fbembed. > > But for Firebird 3.0 the fbembed.dll was removed and integrated in the > client.dll. > > What can I do to make the .NET provider work with Firebird 3.0 databases? > Unfortunately the use of the fbembed.dll from Firebird 2.5 is not an > option as the database files are not compatible between Firebird 2.5 and > Firebird 3.0. > > Thank you very much for any help! > > Wolfgang > > > -- > ___ > Firebird-net-provider mailing list > Firebird-net-provider@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Subsequent error 'lock conflict on no wait transaction' using TransactionScope across DBs
You have basically only one option. 2PC. But that's not something ADO.NET handles. -- Mgr. Jiří Činčura Independent IT Specialist -- Developer Access Program for Intel Xeon Phi Processors Access to Intel Xeon Phi processor-based developer platforms. With one year of Intel Parallel Studio XE. Training and support from Colfax. Order your platform today. http://sdm.link/xeonphi ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Subsequent error 'lock conflict on no wait transaction' using TransactionScope across DBs
I don't think the TransactionScope block is a good idea here (well, it never is). Having it between multiple databases mean spinning MSDTC and enlisting there. I don't remember from top of my head whether that works in FirebirdClient or not. And the ChangeDatabase is ADO.NET non-sense for MS SQL. In Firebird you can't switch databases. You just need to open another connection (which is what the implementation does). So I suppose some transaction is still dangling there on 2nd run. -- Mgr. Jiří Činčura Independent IT Specialist -- Developer Access Program for Intel Xeon Phi Processors Access to Intel Xeon Phi processor-based developer platforms. With one year of Intel Parallel Studio XE. Training and support from Colfax. Order your platform today. http://sdm.link/xeonphi ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] ADO.NET provider 5.6.0.0
More info: http://blog.cincura.net/233580-ado-net-provider-5-6-0-0-for-firebird-is-ready-with-net-core-support/ . -- Mgr. Jiří Činčura Independent IT Specialist -- Developer Access Program for Intel Xeon Phi Processors Access to Intel Xeon Phi processor-based developer platforms. With one year of Intel Parallel Studio XE. Training and support from Colfax. Order your platform today. http://sdm.link/xeonphi ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] EntitiyFramework and Update
There's really nothing EF related. You can try it with multiple console windows with multiple transactions together. It's fundamental way how transactions work. -- Mgr. Jiří Činčura Independent IT Specialist -- The Command Line: Reinvented for Modern Developers Did the resurgence of CLI tooling catch you by surprise? Reconnect with the command line and become more productive. Learn the new .NET and ASP.NET CLI. Get your free copy! http://sdm.link/telerik ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Problems with NuGet packages.
Install 3.0.2.1. -- Mgr. Jiří Činčura Independent IT Specialist On Mon, Oct 24, 2016, at 16:58, Todd Manchester wrote: > > Hi, > > > First let me apologize if this is the wrong place to place this but I > could not determine how else to contact you and it it related. > > > When I use the NuGet package manager to for the > FirebirdSql.Data.FirebirdClient and I select the the version should be > 3.0.2 (I need this version). It places version 3.0.0.0 instead in my > project. This makes it not possible to use. Is it possible that the > correct version could take its place? Thanks for your hard work! I am > attaching 2 screenshots > > https://1drv.ms/i/s!ApL4KEEAk0xwh69c6QN36H6XKRAwEA > > [https://storage.live.com/Items/704C93004128F892%21120796%3ACustomThumbnailSource%2CHighRes%2CDefault?width=1016=663=%21AOkDd-h-lykQMBA]<https://1drv.ms/i/s!ApL4KEEAk0xwh69c6QN36H6XKRAwEA> > > NugetPackageManager.png<https://1drv.ms/i/s!ApL4KEEAk0xwh69c6QN36H6XKRAwEA> > 1drv.ms > PNG Image > > https://1drv.ms/f/s!ApL4KEEAk0xwh69bUEbPU9nBNW7y2Q > > [https://storage.live.com/Items/704C93004128F892%21120797%3ACustomThumbnailSource%2CHighRes%2CDefault?width=354=886=%21AFBGz1PZwTVu8tk]<https://1drv.ms/f/s!ApL4KEEAk0xwh69bUEbPU9nBNW7y2Q> > > Firebird<https://1drv.ms/f/s!ApL4KEEAk0xwh69bUEbPU9nBNW7y2Q> > 1drv.ms > Folder > > > > Sincerely, > > Todd Manchester > Chronicle Technologies Inc. > -- > 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 > Firebird-net-provider@lists.sourceforge.net > 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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] ADO.NET provider 5.5.0.0
More info: http://blog.cincura.net/233576-ado-net-provider-5-5-0-0-for-firebird-is-ready/ . -- Mgr. Jiří Činčura Independent IT Specialist -- 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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Best practice for Rollback with EF and Firebird
> Your comment "...is only in database, not in context" indicates that > something needs to be done here: But what? You need to fix the problem in entity (or detach it, if you just want to throw it away). -- Mgr. Jiří Činčura Independent IT Specialist -- ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Testing the compression?
> Any suggestions? To see any difference you need a lot of data and slow connection. -- Mgr. Jiří Činčura Independent IT Specialist -- ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Testing the compression?
> was almost half; eg without compression 6 seconds vs 3.4s with > compression. Yes. It also highly depends on data. > Increasing the PacketSize and FetchSize to maximum 32767 also has a large > positive impact on transfer time over internet connection. Honestly I'm thinking about removing these two and using "the largest reasonable value". Almost nobody knows about these and even less people know what they are doing. And especially with PacketSize the bigger the better, maybe unless you're running on 40MB RAM. -- Mgr. Jiří Činčura Independent IT Specialist -- ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Testing the compression?
And Thanks for testing BTW. -- Mgr. Jiří Činčura Independent IT Specialist -- ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Testing the compression?
Hi *, anybody testing the compression: http://blog.cincura.net/233572-compression-support-in-firebirdclient-beta/ ? If not, there's no point in holding the beta. I'll just release it and let's see what happens [1]. I can't test it much more myself. [1]: As it's said. You need to break an egg to make an omelette. -- Mgr. Jiří Činčura Independent IT Specialist -- ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Compression support in FirebirdClient beta
Hi, http://blog.cincura.net/233572-compression-support-in-firebirdclient-beta/ Give it a nice good test. The sooner we test it, the sooner it will be released. -- Mgr. Jiří Činčura Independent IT Specialist -- ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Best practice for Rollback with EF and Firebird
> Is it really neccesssary to get transaction before context:SaveChanges() > in > order to rollback? Yes, if you want to rollback manually. OTOH if there's an error while processing the data, the rollback is automatic. Also take into account that the transaction is only in database, not in context. -- Mgr. Jiří Činčura Independent IT Specialist -- ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] ADO.NET provider 5.1.1.0
More info: http://blog.cincura.net/233571-ado-net-provider-5-1-1-0-for-firebird-is-ready/ . -- Mgr. Jiří Činčura Independent IT Specialist -- ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Finalizers
> In embedded or network part? In embedded I thought I had fixed that In network. The embedded is OK - backed by the SafeHandles - as I wrote. > issues. As for network, they should be eliminated at all IIRC. Agreed. Although there might be a one or two cases where it makes sense, higher up. I just have to review it and think carefully about all the different cases I saw in last few years. -- Mgr. Jiří Činčura Independent IT Specialist -- ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Some guess or hint
Too late. It's already solved. It was a race condition in Firebird itself. -- Mgr. Jiří Činčura Independent IT Specialist -- ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Finalizers
> What finalizers are you mention? All. -- Mgr. Jiří Činčura Independent IT Specialist -- ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Finalizers
> A forecast in time for this release Hopefully before end of the year. My current plan, among bug fixes, is roughly: compression > .NET Core > EF Core > finalizers. -- Mgr. Jiří Činčura Independent IT Specialist -- ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] ADO.NET provider 5.1.0.0
More info: http://blog.cincura.net/233569-ado-net-provider-5-1-0-0-for-firebird-is-ready/ . -- Mgr. Jiří Činčura Independent IT Specialist -- ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Finalizers
Hi *, Talking about finalizers in my last email. As I was getting through these, I found few that are wrong-ish. In 99% cases failing with exception, that's just swallowed. Confirmed from runtime. Although in 1% these might be lucky I don't think it's correct usage. What the finalizers are mostly trying to do is something like close connection gracefully with server or free some resources on server. And I believe this is wrong. First of all, this should be responsibility of developer to have correct Dispose calls. Provider should not try to band aid it unless absolutely necessary. Which brings me to the next point. The unmanaged resources, where the finalizers make sense, are not something on server. We don't manage that. Server should handle just fine when developer doesn’t close the connection. Though some resources might be wasted. Unmanaged resources directly allocated by provider are really a few around Embedded support (mostly pointers and pieces of memory for marshalling). And these are properly handled by SafeHandle. And finally finalizers introduce reentrancy issues (anybody interested in details?) and it's really not correct in provider as it grow out of hands. So in the foreseeable future I'll go through all of them and do massive cleanup together with locking cleanup. It's probably going to cause some issues for some people, but their code was wrong before, they were just "lucky". I believe it will make the code slightly faster and also solve some rare bugs, often NREs from finalizer thread. Of course it will be new major version. -- Mgr. Jiří Činčura Independent IT Specialist -- ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Some guess or hint
Hi *, I'm almost closing on compression support. It is stable when I run the tests on my machine. Multiple time, 32bit, 64bit. But are failing on AppVeyor. To make matters worse it's always different test(s). Check https://ci.appveyor.com/project/cincura_net/firebirdsql-data-firebirdclient/build/880 or https://ci.appveyor.com/project/cincura_net/firebirdsql-data-firebirdclient/build/882 . Only common piece is that it's always test with compression on (2nd parameter is True). I spent few days trying to guess what's wrong and fixing some things. But no final luck (I'll not list mine to not skew the thinking). So maybe some smart people here will have some idea. So let's open discussion. Or if you can make it fail on you machine, that would help as well. -- Mgr. Jiří Činčura Independent IT Specialist -- ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Trouble with ADO.Net Provider and connection pool
> long as this i not fixed. Thus I would urge you to prioritize this if > possible. Yeah. It pretty much depends on my time. :\ -- Mgr. Jiří Činčura Independent IT Specialist -- ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Trouble with ADO.Net Provider and connection pool
> Any plans on when this issue will be fixed? No exact ETA. -- Mgr. Jiří Činčura Independent IT Specialist -- ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider