Re: [Firebird-net-provider] Firebird and Generate Views in Visual Studio 2013
In EF6 you might not need pre-generate views. In EF6 this was greatly improved. Anyway, you can fire up ProcMon and look where the T4 template is running. -- Mgr. Jiří Činčura Independent IT Specialist -- Want fast and easy access to all the code in your enterprise? Index and search up to 200,000 lines of code with a free copy of Black Duck Code Sight - the same software that powers the world's largest code search on Ohloh, the Black Duck Open Hub! Try it now. http://p.sf.net/sfu/bds ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Questions with performance metrics doing large inserts into DB
Hi, Any chance to do profiling? I would expect .NET be slightly slower that .NET, but this is x-times slower. That's weird. But finding the bottleneck might be helpful. -- Mgr. Jiří Činčura Independent IT Specialist -- Want fast and easy access to all the code in your enterprise? Index and search up to 200,000 lines of code with a free copy of Black Duck Code Sight - the same software that powers the world's largest code search on Ohloh, the Black Duck Open Hub! Try it now. http://p.sf.net/sfu/bds ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Abbility to use no garbage collect connection parameter
Looks fine to me. -- Mgr. Jiří Činčura Independent IT Specialist -- Want fast and easy access to all the code in your enterprise? Index and search up to 200,000 lines of code with a free copy of Black Duck Code Sight - the same software that powers the world's largest code search on Ohloh, the Black Duck Open Hub! Try it now. http://p.sf.net/sfu/bds ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Questions with performance metrics doing large inserts into DB
Yep, same for me. -- Mgr. Jiří Činčura Independent IT Specialist From: Alexander Muylaert-Gelein [mailto:amuylaert_gel...@hotmail.com] Sent: Friday, August 8, 2014 8:55 PM To: firebird-net-provider@lists.sourceforge. Subject: Re: [Firebird-net-provider] Questions with performance metrics doing large inserts into DB I personally really like the one from red-gate but the visual studio profiler is also good. a From: emendez...@nc.rr.commailto:emendez...@nc.rr.com To: firebird-net-provider@lists.sourceforge.netmailto:firebird-net-provider@lists.sourceforge.net Date: Fri, 8 Aug 2014 09:51:52 -0400 Subject: Re: [Firebird-net-provider] Questions with performance metrics doing large inserts into DB Jiri, I am not familiar with Profiling. Is there one that you can recommend? Thank you, Edward Mendez Also, are there any tests that I can -Original Message- From: Jiří Činčura [mailto:disk...@cincura.net] Sent: Friday, August 8, 2014 1:59 AM To: For users and developers of the Firebird .NET providers Subject: Re: [Firebird-net-provider] Questions with performance metrics doing large inserts into DB Hi, Any chance to do profiling? I would expect .NET be slightly slower that .NET, but this is x-times slower. That's weird. But finding the bottleneck might be helpful. -- Mgr. Jiří Činčura Independent IT Specialist -- Want fast and easy access to all the code in your enterprise? Index and search up to 200,000 lines of code with a free copy of Black Duck Code Sight - the same software that powers the world's largest code search on Ohloh, the Black Duck Open Hub! Try it now. http://p.sf.net/sfu/bds ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.netmailto:Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- Want fast and easy access to all the code in your enterprise? Index and search up to 200,000 lines of code with a free copy of Black Duck Code Sight - the same software that powers the world's largest code search on Ohloh, the Black Duck Open Hub! Try it now. http://p.sf.net/sfu/bds ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.netmailto:Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- Want fast and easy access to all the code in your enterprise? Index and search up to 200,000 lines of code with a free copy of Black Duck Code Sight - the same software that powers the world's largest code search on Ohloh, the Black Duck Open Hub! Try it now. http://p.sf.net/sfu/bds___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Questions with performance metrics doing large inserts into DB
To be honest I’ve never really thought about the transaction settings other than the default. Are there a specific settings I should be using for just reading “stale” data? You should start transaction explicitly. Else it's one transaction per command and in a batch processing that goes out of hand really quickly. I read somewhere that Looping in .NET is somewhat slower than in Delphi, but there are things you can do optimize the .NET loops. I would rather write correct algorithm than spent hours on micro-optimizing loops. BTW did you know asm loops are faster than Delphi and .NET loops? -- 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] Questions with performance metrics doing large inserts into DB
It's roundtrip per some records (depends on size of data), not each record. Putting the records into DataTable will not be faster in any way, as it uses the DataReader internally. -- Mgr. Jiří Činčura Independent IT Specialist From: Paulo Gomes paulo_...@sapo.pt Sent: Saturday, August 09, 2014 4:30:41 PM To: For users and developers of the Firebird .NET providers Subject: Re: [Firebird-net-provider] Questions with performance metrics doing large inserts into DB Hi Edward, I think you answered yourself, the enumerator uses a trip to the database for each record. You should try to break the data in smaller packages (10 for example) and use a DataAdapter to get the data into DataTable. If possible also use several transactions (1 per Package) to keep the memory usage in control. If performance is a must you can always use deal with different Threads(1 for read and 1 for write) , though you will probably add a wanted dead or alive sign on my name for mentioning it. Note: the nº of records should depend on their average size Regards Paulo Gomes Em 09-08-2014 06:56, Edward Mendez escreveu: You should start transaction explicitly. Else it's one transaction per command and in a batch processing that goes out of hand really quickly. I agree with you 100%. The part that I hadn't given much thought was the Isolation levels to pass as the parameter into the transaction object. I would rather write correct algorithm than spent hours on micro-optimizing loops. BTW did you know asm loops are faster than Delphi and .NET loops? Ah ASM, that is definitely a blast from the past. In trying to eliminate certain bottlenecks, I moved a small sample of the source data to a local FB db and ran the .NET test and there it was practically instantaneous reading the data. I think the Network Latency on my corporate network is another factor. Over the weekend, I will move a more sizable sampling to my local DB and attempt the test with the Reads and Write. I downloaded Red-gate (trial) and will profile the App. I will keep everyone posted on the any findings. Thanks, Edward Mendez -- ___ 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 -- ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Questions with performance metrics doing large inserts into DB
There is still some room for improvement on network level. The packets are not batches as much as it could be for server to still understand it. Dmitri Y. reported it to me some months ago. It just needs a lot of time with Wireshark and tweaking the socket until it's same as with fbclient.dll. Maybe somebody could help me with that as well. -- Mgr. Jiří Činčura Independent IT Specialist From: Jiří Činčura disk...@cincura.net Sent: Sunday, August 10, 2014 3:23:14 PM To: For users and developers of the Firebird .NET providers Subject: Re: [Firebird-net-provider] Questions with performance metrics doing large inserts into DB It's roundtrip per some records (depends on size of data), not each record. Putting the records into DataTable will not be faster in any way, as it uses the DataReader internally. -- Mgr. Jiří Činčura Independent IT Specialist From: Paulo Gomes paulo_...@sapo.pt Sent: Saturday, August 09, 2014 4:30:41 PM To: For users and developers of the Firebird .NET providers Subject: Re: [Firebird-net-provider] Questions with performance metrics doing large inserts into DB Hi Edward, I think you answered yourself, the enumerator uses a trip to the database for each record. You should try to break the data in smaller packages (10 for example) and use a DataAdapter to get the data into DataTable. If possible also use several transactions (1 per Package) to keep the memory usage in control. If performance is a must you can always use deal with different Threads(1 for read and 1 for write) , though you will probably add a wanted dead or alive sign on my name for mentioning it. Note: the nº of records should depend on their average size Regards Paulo Gomes Em 09-08-2014 06:56, Edward Mendez escreveu: You should start transaction explicitly. Else it's one transaction per command and in a batch processing that goes out of hand really quickly. I agree with you 100%. The part that I hadn't given much thought was the Isolation levels to pass as the parameter into the transaction object. I would rather write correct algorithm than spent hours on micro-optimizing loops. BTW did you know asm loops are faster than Delphi and .NET loops? Ah ASM, that is definitely a blast from the past. In trying to eliminate certain bottlenecks, I moved a small sample of the source data to a local FB db and ran the .NET test and there it was practically instantaneous reading the data. I think the Network Latency on my corporate network is another factor. Over the weekend, I will move a more sizable sampling to my local DB and attempt the test with the Reads and Write. I downloaded Red-gate (trial) and will profile the App. I will keep everyone posted on the any findings. Thanks, Edward Mendez -- ___ 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 -- ___ 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] Questions with performance metrics doing large inserts into DB
There is still some room for improvement on network level. The packets are not
batches as much as it could be for server to still understand it. Dmitri Y.
reported it to me some months ago.
It just needs a lot of time with Wireshark and tweaking the socket until it's
same as with fbclient.dll.
Maybe somebody could help me with that as well.
--
Mgr. Jiří Činčura
Independent IT Specialist
From: Alexander Muylaert-Gelein amuylaert_gel...@hotmail.com
Sent: Friday, August 08, 2014 11:10:43 PM
To: firebird-net-provider@lists.sourceforge.
Subject: Re: [Firebird-net-provider] Questions with performance metrics doing
large inserts into DB
Hi
Attached some examples of transactions properly set.
If you can put the reader in readonly and the writer in WriteNoUndo, you
gain some speed. But euh, no magic to expect here. It might be interesting to
profile it though and post the results back.
public static class Transaction
{
private static FbTransactionOptions s_WriteTransaction = new
FbTransactionOptions()
{
TransactionBehavior = FbTransactionBehavior.Write |
FbTransactionBehavior.ReadCommitted |
FbTransactionBehavior.RecVersion |
FbTransactionBehavior.Wait,
WaitTimeout = new TimeSpan(0, 0, 0, 10) //seconds
};
public static FbTransactionOptions WriteTransactions
{
get
{
return s_WriteTransaction;
}
}
private static FbTransactionOptions s_WriteNoUndoTransaction = new
FbTransactionOptions()
{
TransactionBehavior = FbTransactionBehavior.Write |
FbTransactionBehavior.ReadCommitted |
FbTransactionBehavior.RecVersion |
FbTransactionBehavior.Wait |
FbTransactionBehavior.NoAutoUndo,
WaitTimeout = new TimeSpan(0, 0, 0, 10) //seconds
};
public static FbTransactionOptions WriteNoUndoTransactions
{
get
{
return s_WriteTransaction;
}
}
private static FbTransactionOptions s_ReadTransaction = new
FbTransactionOptions()
{
TransactionBehavior = FbTransactionBehavior.Read |
FbTransactionBehavior.ReadCommitted |
FbTransactionBehavior.RecVersion |
FbTransactionBehavior.NoWait
};
public static FbTransactionOptions ReadTransactions
{
get
{
return s_ReadTransaction;
}
}
public static FbTransaction BeginReadTransaction(this FbConnection
aConnection)
{
return aConnection.BeginTransaction(s_ReadTransaction);
}
public static FbTransaction BeginWriteTransaction(this FbConnection
aConnection)
{
return aConnection.BeginTransaction(s_WriteTransaction);
}
public static FbTransaction BeginWriteNoUndoTransaction(this FbConnection
aConnection)
{
return aConnection.BeginTransaction(s_WriteTransaction);
}
}
I read somewhere that Looping in .NET is somewhat slower than in Delphi, but
there are things you can do optimize the .NET loops.
Agreed, some tricks might be applied. But that will bring you down from 18.7
seconds to 18.69998 seconds. Optimizing loops is actually not the way to go.
What you could do is make a small test project. with a few simple tables. Add
your simulations to it and make sure it compiles. Then, if you have these
minimal projects building, I would like to receive a copy and I can profile for
you.
Maybe I can already see what is wrong. Like Jiri mentioned. .Net is slower
then this FIB/FBClient (c++) dll. But let us assume that is 10% overhead. So
4 seconds delphi = 5 seconds .net is fine for me. 18 seconds... I'm
interested in speeding things up then :-)
thanks
a
From: emendez...@nc.rr.com
To: firebird-net-provider@lists.sourceforge.net
Date: Fri, 8 Aug 2014 09:41:03 -0400
Subject: Re: [Firebird-net-provider] Questions with performance metrics doing
large inserts into DB
Alexander,
Thank you for the feedback.
Two more things...
1. Your transaction parameters please. How do you create them, what
settings?
To be honest I’ve never really thought about the transaction settings other
than the default. Are there a specific settings I should be using for just
reading “stale” data?
2. Did you check your source-read logic. Cound you maybe fake data, so we
know if it is the insert that is slow. Maybe the materializing of the
source record is slow or fetching it?
I was doing further testing last night and removed the insert logic to see if
it was the reading of the data that was slowing it down. with the removal of
the Insert Logic and just reading and looping for 5000
Re: [Firebird-net-provider] Error when reading from connection
You connection is broken at some point. Maybe something on network? -- 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] SqlQuery is not working
That's known issue in EF (https://entityframework.codeplex.com/workitem/2418). It will be solved in 6.1.2. -- 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] Compiling for mono
Create a PR. -- Mgr. Jiří Činčura Independent IT Specialist From: Ernesto Cullen [mailto:ernestocul...@gmail.com] Sent: Friday, September 5, 2014 4:57 PM To: For users and developers of the Firebird .NET providers Subject: Re: [Firebird-net-provider] Compiling for mono I could get Firebird provider running on Mono, using embedded server. I did some changes to the conditional compilation definitions (#if) and an addition to resources processing. How can I get these integrated in the official code? Ernesto Cullen 2014-07-30 5:36 GMT-03:00 diskuze disk...@cincura.netmailto:disk...@cincura.net: Hi, probably best idea is to use the build for Mono/Linux from firebirdsql.orghttp://firebirdsql.org. Or you can build it yourself, there’s a configuration with same name in project. -- Mgr. Jiri Cincura Independent IT Specialist -- Infragistics Professional Build stunning WinForms apps today! Reboot your WinForms applications with our WinForms controls. Build a bridge from your legacy apps to the future. http://pubads.g.doubleclick.net/gampad/clk?id=153845071iu=/4140/ostg.clktrk ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.netmailto:Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- Either write something worth reading or do something worth writing B. Franklin -- Slashdot TV. Video for Nerds. Stuff that matters. http://tv.slashdot.org/___ 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 4.5.1.0 for Firebird is ready
This is just a small release with contributions on GitHub and so-called ProviderManifestToken resolving improvements (database does not need to exist). High level overview of changes can be found in tracker. You can get the bits from NuGet FirebirdSql.Data.FirebirdClient and EntityFramework.Firebird (or from firebirdsql.org). More info: http://blog.cincura.net/233477-ado-net-provider-4-5-1-0-for-firebird-is-ready/ -- Mgr. Jiří Činčura Independent IT Specialist -- Want excitement? Manually upgrade your production database. When you want reliability, choose Perforce Perforce version control. Predictably reliable. http://pubads.g.doubleclick.net/gampad/clk?id=157508191iu=/4140/ostg.clktrk ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Abbility to use no garbage collect connection parameter
Looks fine. Merged. Thanks. -- Mgr. Jiří Činčura Independent IT Specialist -- Want excitement? Manually upgrade your production database. When you want reliability, choose Perforce Perforce version control. Predictably reliable. http://pubads.g.doubleclick.net/gampad/clk?id=157508191iu=/4140/ostg.clktrk___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] OT: Somebody in Prague
Hi *, Somebody going to Prague to enjoy conference? If so catch me there. Would like to know about your FirebirdClient usage. -- Mgr. Jiří Činčura Independent IT Specialist -- Comprehensive Server Monitoring with Site24x7. Monitor 10 servers for $9/Month. Get alerted through email, SMS, voice calls or mobile push notifications. Take corrective actions from your mobile device. http://p.sf.net/sfu/Zoho ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] FirebirdClient was not found excepction when in use with EF6
You don’t have factory record in machine/app/web.config. -- 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] FirebirdClient was not found excepction when in use with EF6
You’re missing record in system.data DbProviderFactories. -- 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] EF Migrations
Hi *, Anybody here willing to give EF Migrations a try? I'm getting close to first implementation. -- Mgr. Jiří Činčura Independent IT Specialist -- ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] FirebirdClient was not found excepction when in use with EF6
You’re missing a space there. Check the message closely. name 'FirebirdSql.Data. FirebirdClient' Not sure why are you using the space there, maybe to avoid some other conflicts? Anyway, if it's not intentional, just remove the space and you're good to go. -- Mgr. Jiří Činčura Independent IT Specialist -- ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] FirebirdClient was not found excepction when in use with EF6
I would suggest to add it - if it's for application, not your environment - to app/web.config. Easier for deploy. -- Mgr. Jiří Činčura Independent IT Specialist -- ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] FirebirdClient was not found excepction when in use with EF6
It’s the same, only it’s called app.config. -- 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] EF Migrations
Great. Here's http://ge.tt/2Cx9f142?c early implementation. There are two issues which I'm not sure how to do (see below). Rest should work. But there might be some missing space etc. in generated SQL or I might wrote it in different engine's dialect. That's what I'm mostly looking for for this testing. For easiest testing is enough to install EntityFramework.Firebird package and then replace EntityFramework.Firebird.dll reference with the one from above link. The class is FbMigrationSqlGenerator, if you'd like to try it manually. Issues: 1. Not easy to drop NOT NULL constraint in alter table. I can do it with execute block and generate it there, but seems pretty ugly. I wish Firebird 3 was here. 2. Generating identity columns. It's not directly supported in Firebird. I can at least generate #PK_GEN# comment. But I'd like to offer some warning at least that you need to create your own trigger and use/create generator. Maybe some developer-provided factory to create/alter the trigger and create/use generator would work. I'm open for ideas. -- Mgr. Jiří Činčura Independent IT Specialist -- ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] EF Migrations
1. What problem in Execute block? It kind of breaks the notion of altering the table/column with one command. It's a bit of magic with system tables and people might get confused or break it by chaning the script. 2. My opinion for Identity is to copy MSSQL behavior. Create generator for each primary key + trigger before insert. MSSQL has identities. Given that there are at least two widely used schemes in Firebird community and nothing is in the engine itself, I'd like to keep this open, with some default implementation. -- Mgr. Jiří Činčura Independent IT Specialist -- ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] ADO.NET provider 4.5.2.0
More info: http://blog.cincura.net/233487-ado-net-provider-4-5-2-0-for-firebird-is-ready/ . -- Mgr. Jiří Činčura Independent IT Specialist -- ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] EF Migrations
So anybody tested migrations? -- Mgr. Jiří Činčura Independent IT Specialist -- Comprehensive Server Monitoring with Site24x7. Monitor 10 servers for $9/Month. Get alerted through email, SMS, voice calls or mobile push notifications. Take corrective actions from your mobile device. http://pubads.g.doubleclick.net/gampad/clk?id=154624111iu=/4140/ostg.clktrk ___ 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 Migrations
And BTW does anybody has some detailed information about Although this form of EXECUTE STATEMENT can also be used with all kinds of DDL strings (except CREATE/DROP DATABASE), it is generally very, very unwise to use this trick in order to circumvent the no-DDL rule in PSQL., which I'm using to drop NOT NULL constraint? I know it's generally wrong, but any problems on engine's side? -- Mgr. Jiří Činčura Independent IT Specialist -- Comprehensive Server Monitoring with Site24x7. Monitor 10 servers for $9/Month. Get alerted through email, SMS, voice calls or mobile push notifications. Take corrective actions from your mobile device. http://pubads.g.doubleclick.net/gampad/clk?id=154624111iu=/4140/ostg.clktrk ___ 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 Migrations
Except for identity generation should be done: http://ge.tt/3OSvoR42 . Some feedback? -- Mgr. Jiří Činčura Independent IT Specialist -- Comprehensive Server Monitoring with Site24x7. Monitor 10 servers for $9/Month. Get alerted through email, SMS, voice calls or mobile push notifications. Take corrective actions from your mobile device. http://pubads.g.doubleclick.net/gampad/clk?id=154624111iu=/4140/ostg.clktrk ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Special symbols getting converted to something else
You have very likely mismatch in charsets. To prevent it, basically, just use UTF8, everywhere. -- Mgr. Jiří Činčura Independent IT Specialist -- Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate! Instantly Supercharge Your Business Reports and Dashboards with Interactivity, Sharing, Native Excel Exports, App Integration more Get technology previously reserved for billion-dollar corporations, FREE http://pubads.g.doubleclick.net/gampad/clk?id=157005751iu=/4140/ostg.clktrk ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Special symbols getting converted to something else
Hard to say what charset the C++ is actually using. But using NONE on database was *very* bad choice. The encoding might be pretty screwed in. Use UTF8 in .NET, but I expect you’re going to do manual transliteration because of NONE charset used. -- Mgr. Jiří Činčura Independent IT Specialist -- Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate! Instantly Supercharge Your Business Reports and Dashboards with Interactivity, Sharing, Native Excel Exports, App Integration more Get technology previously reserved for billion-dollar corporations, FREE http://pubads.g.doubleclick.net/gampad/clk?id=157005751iu=/4140/ostg.clktrk ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Special symbols getting converted to something else
Absolutely. Put there some text. Dump it in hex to file. Open it in some “smart” editor – a lot of editors have a feature to guess encoding. You can also do it to with encoding tables. But that’s manual and slow. :) -- Mgr. Jiří Činčura Independent IT Specialist -- Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate! Instantly Supercharge Your Business Reports and Dashboards with Interactivity, Sharing, Native Excel Exports, App Integration more Get technology previously reserved for billion-dollar corporations, FREE http://pubads.g.doubleclick.net/gampad/clk?id=157005751iu=/4140/ostg.clktrk ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Special symbols getting converted to something else
isql -- Mgr. Jiří Činčura Independent IT Specialist -- Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate! Instantly Supercharge Your Business Reports and Dashboards with Interactivity, Sharing, Native Excel Exports, App Integration more Get technology previously reserved for billion-dollar corporations, FREE http://pubads.g.doubleclick.net/gampad/clk?id=157005751iu=/4140/ostg.clktrk ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Special symbols getting converted to something else
Study http://www.firebirdsql.org/refdocs/langrefupd25.html . -- Mgr. Jiří Činčura Independent IT Specialist -- Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate! Instantly Supercharge Your Business Reports and Dashboards with Interactivity, Sharing, Native Excel Exports, App Integration more Get technology previously reserved for billion-dollar corporations, FREE http://pubads.g.doubleclick.net/gampad/clk?id=157005751iu=/4140/ostg.clktrk ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Insert into uncommitted table
A) The transaction is handled by EF. B) When the script gets generated, there’s no transaction whatsoever. Crazy world. :) -- Mgr. Jiří Činčura Independent IT Specialist -- Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate! Instantly Supercharge Your Business Reports and Dashboards with Interactivity, Sharing, Native Excel Exports, App Integration more Get technology previously reserved for billion-dollar corporations, FREE http://pubads.g.doubleclick.net/gampad/clk?id=164703151iu=/4140/ostg.clktrk ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Insert into uncommitted table
Something like Seed ? No, not really. :) -- Mgr. Jiří Činčura Independent IT Specialist -- Dive into the World of Parallel Programming! The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Insert into uncommitted table
AFAIK there are more databases that require a commit before a newly created table can be used. The good old magic MS SQL does not. :) -- Mgr. Jiří Činčura Independent IT Specialist -- Dive into the World of Parallel Programming! The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] DNET-570 Pull request
Thanks for PR. I’m on it. I just need to compare it with better tool than https://github.com/cincuranet/NETProvider/pull/18/files?diff=split. For next version it will be done, very likely. -- Mgr. Jiří Činčura Independent IT Specialist -- Dive into the World of Parallel Programming! The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Default pool lifetime
Hi *, Reading the DNET-552 I'm wondering about two items. 1. What the default value for lifetime should be (also see 2.). There's no magic value that fits all. But at least we might try to get something reasonable. From top of my head I proposed 10 seconds. But that's just a value. No real research behing it. Even no argument. Maybe you have some? 2. What the 0 value means. Does it mean really 0, aka no lifetime and hence basically no pooling. Or infinite? Given one can turn off pooling by Pooling=False in connection string I would say infinite is probably better meaning. But I'd like to hear your opinion. -- Mgr. Jiří Činčura Independent IT Specialist -- Dive into the World of Parallel Programming! The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net ___ 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 Migrations
1. Generator ID. One for all is bad options for me. I'll reimplement it to have one for table. That's why it's open. 2. Couple of errors in creating Constraints or Indexes: unsuccessful metadata update Name longer than database column size Constraint names are longer than it can be in system tables: ALTER TABLE ClientGroupAlerts ADD CONSTRAINT FK_ClientGroupAlerts_ClientGroups_ClientGroup_Id. I've figured that maximum name is 31 (!!!) characters. I've implemented SHA1 (maybe I will replace it with something faster) hashing of string names. Yeah. Firebird's 31 characters it's goign to be hard to beat. I can shorten the string, but that will increase collisions. Maybe we can create - similar to generators - open ended method that anybody can override if needed. -- Mgr. Jiří Činčura Independent IT Specialist -- Dive into the World of Parallel Programming! The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net ___ 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 Migrations
Your configuration for context needs to derive from FbDbConfiguration. So far there's no better solution. The migrations are run in serializable transaction and you need to insert into __MigrationHistory right after creation. Disaster. -- Mgr. Jiří Činčura Independent IT Specialist From: Геннадий Забула [mailto:zabulu...@gmail.com] Sent: Tuesday, December 30, 2014 8:19 AM To: For users and developers of the Firebird .NET providers Subject: Re: [Firebird-net-provider] EF Migrations Fall in next query: EXECUTE BLOCK AS BEGIN EXECUTE STATEMENT 'CREATE TABLE __MigrationHistory ( MigrationId VARCHAR(150) NOT NULL, ContextKey VARCHAR(300) NOT NULL, Model BLOB SUB_TYPE BINARY NOT NULL, ProductVersion VARCHAR(32) NOT NULL )' WITH AUTONOMOUS TRANSACTION; END Parameters: With next exception: unsuccessful metadata update STORE RDB$RELATIONS failed lock conflict on no wait transaction 2014-12-30 9:03 GMT+02:00 Геннадий Забула zabulu...@gmail.com: Here are my issues/suggestions: 1. Generator ID. One for all is bad options for me. I'll reimplement it to have one for table. 2. Couple of errors in creating Constraints or Indexes: unsuccessful metadata update Name longer than database column size Constraint names are longer than it can be in system tables: ALTER TABLE ClientGroupAlerts ADD CONSTRAINT FK_ClientGroupAlerts_ClientGroups_ClientGroup_Id. I've figured that maximum name is 31 (!!!) characters. I've implemented SHA1 (maybe I will replace it with something faster) hashing of string names. Will write about further progress. 2014-12-20 8:32 GMT+02:00 Mercea Paul paul.mer...@almexa.ro: On 2014.11.06 3:06 PM, Jiří Činčura wrote: Hi *, Anybody here willing to give EF Migrations a try? I'm getting close to first implementation. I'm trying to add support for Firebird db for existing app on SQL Express, and, first run of the application was with no errors and created the database. I'll going to try migrations steps and give feedback. Thanks Jiri Paul MERCEA ___ E-mail: paul.mer...@almexa.ro ___ -- Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate! Instantly Supercharge Your Business Reports and Dashboards with Interactivity, Sharing, Native Excel Exports, App Integration more Get technology previously reserved for billion-dollar corporations, FREE http://pubads.g.doubleclick.net/gampad/clk?id=164703151iu=/4140/ostg.clktrk ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- Dive into the World of Parallel Programming! The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net ___ 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 4.6.0
More info at: http://blog.cincura.net/233492-ado-net-provider-4-6-0-0-for-firebird-is-ready/ . Enjoy. -- Mgr. Jiří Činčura Independent IT Specialist -- Dive into the World of Parallel Programming! The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net ___ 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 Migrations
That’s not the same as what AddInterceptor call does.
--
Mgr. Jiří Činčura
Independent IT Specialist
From: Геннадий Забула [mailto:zabulu...@gmail.com]
Sent: Tuesday, December 30, 2014 10:36 AM
To: For users and developers of the Firebird .NET providers
Subject: Re: [Firebird-net-provider] EF Migrations
And looks like it works:
public FbProviderServices()
{
#if (EF_6)
AddDependencyResolver(new
SingletonDependencyResolverIDbConnectionFactory(new FbConnectionFactory()));
AddDependencyResolver(new
SingletonDependencyResolverFuncMigrationSqlGenerator(() = new
FbMigrationSqlGenerator(), ProviderInvariantName));
System.Data.Entity.Infrastructure.Interception.DbInterception.Add(new
MigrationsTransactionsInterceptor());
#endif
}
2014-12-30 11:29 GMT+02:00 Геннадий Забула
zabulu...@gmail.commailto:zabulu...@gmail.com:
I've found out that there is the static class:
System.Data.Entity.Infrastructure.Interception.DbInterception, which adds
IDbInterceptor,
2014-12-30 11:23 GMT+02:00 Jiří Činčura
j...@cincura.netmailto:j...@cincura.net:
I'm using the same Context for both MSSQL and Firebird, how deriving from
FbDbConfiguration can affect MSSQL code path? Can we override this somehow
just in Firebird provider?
You can use the same context. It's just configuration. I'm waiting for reply
from EF guys to see what other options are.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Dive into the World of Parallel Programming! The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.netmailto:Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
--
Dive into the World of Parallel Programming! The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net___
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 Migrations
The name for index is created by EF if the explicit value is not provided. -- Mgr. Jiří Činčura Independent IT Specialist -- Dive into the World of Parallel Programming! The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net ___ 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 Migrations
Yeah, but it’s different path. The InternalConfiguration class might or might not like that (now or in the future). It’s problem waiting to happen. And please stop sending HTML emails. -- Mgr. Jiří Činčura Independent IT Specialist -- Dive into the World of Parallel Programming! The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net ___ 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 Migrations
or maybe via AddDependencyResolver(new SingletonDependencyResolverIDbInterceptor()) as suggested in documentation: http://msdn.microsoft.com/ru- ru/library/system.data.entity.dbconfiguration.addinterceptor(v=vs.113).asp x), I'd like to do this. But when I register it in provider services, it does not work. Not sure why. -- Mgr. Jiří Činčura Independent IT Specialist -- Dive into the World of Parallel Programming! The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net ___ 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 Migrations
One more question, how can I register custom implementation of IFbMigrationSqlGeneratorBehavior? Register MigrationSqlGenerator with FbMigrationSqlGenerator and pass the implementation to ctor. Something like: AddDependencyResolver(new SingletonDependencyResolverFuncMigrationSqlGenerator(() = new FbMigrationSqlGenerator(... EF does not allow to plug custom services. :( -- Mgr. Jiří Činčura Independent IT Specialist -- Dive into the World of Parallel Programming! The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net ___ 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 Migrations
I'd like to do this. But when I register it in provider services, it does not work. Not sure why. Ahh. Finally found it. IdbInterceptors are not supported for registration in DbProviderServices. So we're probably left with only DbInterception.Add. I did some research and looks it should work fine. Better than forcing people to derive from custom class, I think. -- Mgr. Jiří Činčura Independent IT Specialist -- Dive into the World of Parallel Programming! The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net ___ 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: Error reading data from the connection
I am still trying to understand why it is being considered expected behavior if due to this issue all of my 122 clients need to be re-start their application every time the Firebird Server is Stop/Start or every time that we have any network issue. You live in a dream. There was never connection resiliency. If the connection is broken you need to reopen it. -- Mgr. Jiří Činčura Independent IT Specialist -- Dive into the World of Parallel Programming. The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Decorators for FbConnectionString properties
In FbConnectionStringBuilder.cs there’s a mix of tabs and spaces. Are there any policy on that? The code I’ve added uses tabs for indentation and I didn’t touch any existing tabs and/or spaces. Should be tabs everywhere. But the codebase remembers something. But as long as the code is correct, it doesn't matter that much. Regarding line-endings, I assume you use Unix LF, right? CR LF. But again. Not much important. Decent editor will handle it. :) -- Mgr. Jiří Činčura Independent IT Specialist -- Dive into the World of Parallel Programming. The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Decorators for FbConnectionString properties
Thanks. Merged. -- Mgr. Jiří Činčura Independent IT Specialist -- Dive into the World of Parallel Programming. The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net/ ___ 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 EF6 DDEX adding Views
But I then would have to add Entities manually, right? No. It's already there. -- Mgr. Jiří Činčura Independent IT Specialist -- Dive into the World of Parallel Programming. The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net/ ___ 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 EF6 DDEX adding Views
The wizard in VS should generate you the CSDL as well. -- Mgr. Jiří Činčura Independent IT Specialist On Mon, Feb 2, 2015 at 11:13 AM -0800, Christoph Gasser christoph.gas...@stranto.commailto:christoph.gas...@stranto.com wrote: * In designer I make Update from database * View is not added, but the error message is shown. * No entity is added under the myViewModel.tt file (in the VS solution). But there is an entity of the previous added table. Also under myViewModel.Context.tt\Entities there is no view entity added. There is no myview.cs class. There is one for the table. * I now save the EDMX file and open it as XML. I'm uncommenting the block for the view (and deleting the error message which is part of the commented block. * Adding part for Key referencing one of the columns of the view. * Saving the EDMX again. * Now I can't open it anymore in the designer. * In XML mode for EDMX file I get the message: Entity type [myview] has no entity set. That's what I meant: I know would have to create (and update) the entities manually. BR C No. It's already there. -- Mgr. Jiří Činčura Independent IT Specialist Thank you for your reply. I found that information already. I also tried that already. But I then would have to add Entities manually, right? Or did I miss a step? This makes it very not handsome to use because during development process the views are changing a lot. Is there any other solution? Like marking columns in the database with #PK_GEN# or something similar? BR C http://blog.cincura.net/230207-what-the-hell-where-s-my-added-view/ -- Mgr. Jiří Činčura Independent IT Specialist -- Dive into the World of Parallel Programming. The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider 845a8f621f6d43b09e7c5f8288e69d35@S05-MBX01-01.S05.local Von: Christoph Gasser Gesendet: Samstag, 31. Jänner 2015 12:47 An: 'firebird-net-provider@lists.sourceforge.net' Betreff: Firebird EF6 DDEX adding Views I'm using VS 2012, Firebird 2.5, EF6. When trying to add a View to my model in the designer I get the message: The table/view 'Firebird.Firebird.V_MYVIEW' does not have a primary key defined and no valid primary key could be inferred. This table/view has been excluded. To use the entity, you will need to review your schema, add the correct keys, and uncomment it. That's because EF need a PK for every table / view. When using MSSQL there is an approach using ISNULL in the view to be able to add the view to the model. But ISNULL is not supported in Firebird. The underlying table of the view has PK which is also marked as #PK_GEN# . And I'm able to add this table to my model. So my question is: Does anyone know how to add a view to a EF6 model in designer? BR C -- Dive into the World of Parallel Programming. The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net/___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] System.Guid
Guid is opaque value. Interpretation in string is just a visual representation. -- Mgr. Jiří Činčura Independent IT Specialist -- New Year. New Location. New Benefits. New Data Center in Ashburn, VA. GigeNET is offering a free month of service with a new server in Ashburn. Choose from 2 high performing configs, both with 100TB of bandwidth. Higher redundancy.Lower latency.Increased capacity.Completely compliant. http://p.sf.net/sfu/gigenet ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] System.Guid
in an application that mixes char(16) character set octets and varchar(36) is not possible currently, why? It's simple. Don't do it. You're mixing binary data with string. Depending on LE or BE system you might get different result. -- Mgr. Jiří Činčura Independent IT Specialist -- New Year. New Location. New Benefits. New Data Center in Ashburn, VA. GigeNET is offering a free month of service with a new server in Ashburn. Choose from 2 high performing configs, both with 100TB of bandwidth. Higher redundancy.Lower latency.Increased capacity.Completely compliant. http://p.sf.net/sfu/gigenet ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] System.Guid
And what’s not clear? -- Mgr. Jiří Činčura Independent IT Specialist -- New Year. New Location. New Benefits. New Data Center in Ashburn, VA. GigeNET is offering a free month of service with a new server in Ashburn. Choose from 2 high performing configs, both with 100TB of bandwidth. Higher redundancy.Lower latency.Increased capacity.Completely compliant. http://p.sf.net/sfu/gigenet ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Make FbNetProvider classes unseal
What are you trying to do that is not possible without it? -- Mgr. Jiří Činčura Independent IT Specialist -- New Year. New Location. New Benefits. New Data Center in Ashburn, VA. GigeNET is offering a free month of service with a new server in Ashburn. Choose from 2 high performing configs, both with 100TB of bandwidth. Higher redundancy.Lower latency.Increased capacity.Completely compliant. http://p.sf.net/sfu/gigenet ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Make FbNetProvider classes unseal
Well, you can do simple: StartTiming(); Execute(); LogElapsed(); Of if you want to do more fancy solution you should wrap all the FbXxx classes into wrappers. That's how other layers work (profilers, O/Rs, ...). -- Mgr. Jiří Činčura Independent IT Specialist -Original Message- From: Lukáš Vykydal [mailto:l.vyky...@gmail.com] Sent: Friday, January 16, 2015 11:03 AM To: firebird-net-provider@lists.sourceforge.net Subject: Re: [Firebird-net-provider] Make FbNetProvider classes unseal We d'like to monitor performance (time to execute) for every statement. We have a lot of code which use only base ADO.NET access to database. With this change we can find performance killers in this code more easly including parameters and plan. That is the main reason for this request. Lukáš Vykydal Dne 1/16/2015 v 10:48 AM Jiří Činčura napsal(a): What are you trying to do that is not possible without it? -- New Year. New Location. New Benefits. New Data Center in Ashburn, VA. GigeNET is offering a free month of service with a new server in Ashburn. Choose from 2 high performing configs, both with 100TB of bandwidth. Higher redundancy.Lower latency.Increased capacity.Completely compliant. http://p.sf.net/sfu/gigenet ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- New Year. New Location. New Benefits. New Data Center in Ashburn, VA. GigeNET is offering a free month of service with a new server in Ashburn. Choose from 2 high performing configs, both with 100TB of bandwidth. Higher redundancy.Lower latency.Increased capacity.Completely compliant. http://p.sf.net/sfu/gigenet ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Error reading data from the connection
That’s expected. The driver is not reopening the connection. -- Mgr. Jiří Činčura Independent IT Specialist From: Nicolas F. Timmers [mailto:nftimm...@hotmail.com] Sent: Friday, January 23, 2015 11:49 AM To: 'For users and developers of the Firebird .NET providers' Subject: [Firebird-net-provider] Error reading data from the connection Hello I am experiencing an error regarding the new version of Firebird Client 4.6.0 In summary the following steps are necessary to generate the error 1) Using a page Ex: Default.aspx, make a connection to the database 2) After made the connection end the firebird service by windows services 3) When you return to the page and try to make a new connection an error is generated 4) Error reading data from the connection What did seems to be is that when the firebird service is stopped the Firebird Client is trying to use the Pooling my question is if an attempt is made in pooling successfully should not the DLL fill the pooling again? -- New Year. New Location. New Benefits. New Data Center in Ashburn, VA. GigeNET is offering a free month of service with a new server in Ashburn. Choose from 2 high performing configs, both with 100TB of bandwidth. Higher redundancy.Lower latency.Increased capacity.Completely compliant. http://p.sf.net/sfu/gigenet___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Error reading data from the connection
Probably the provider pulls a bad connection from the pool and tries to use it despite its being broken. OK, so once more. Provider is not reopening the connection or doing *anything* with it. In fact it's even impossible to do it reliably. -- New Year. New Location. New Benefits. New Data Center in Ashburn, VA. GigeNET is offering a free month of service with a new server in Ashburn. Choose from 2 high performing configs, both with 100TB of bandwidth. Higher redundancy.Lower latency.Increased capacity.Completely compliant. http://p.sf.net/sfu/gigenet ___ 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 4.6.1.0
More info http://blog.cincura.net/233495-ado-net-provider-4-6-1-0-for-firebird-is-ready/ . -- Mgr. Jiří Činčura Independent IT Specialist -- New Year. New Location. New Benefits. New Data Center in Ashburn, VA. GigeNET is offering a free month of service with a new server in Ashburn. Choose from 2 high performing configs, both with 100TB of bandwidth. Higher redundancy.Lower latency.Increased capacity.Completely compliant. http://p.sf.net/sfu/gigenet ___ 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 EF6 DDEX adding Views
http://blog.cincura.net/230207-what-the-hell-where-s-my-added-view/ -- Mgr. Jiří Činčura Independent IT Specialist -- Dive into the World of Parallel Programming. The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Decorators for FbConnectionString properties
Sure. Go ahead. Once done create PR on GitHub and that’s it. -- Mgr. Jiří Činčura Independent IT Specialist From: Hernan Martinez [mailto:hernan.marti...@obi-corp.com] Sent: Tuesday, January 27, 2015 5:06 PM To: Firebird-net-provider@lists.sourceforge.net Subject: [Firebird-net-provider] Decorators for FbConnectionString properties Hi dev(s)! One nice addition would be to decorate FbConnectionString public properties with Attribute decorators like Category, Description, Editor, DefaultValue, etc. It’s a fairly easy mod (if only with English texts) and I can do it by myself. Would you accept patches? Do you expect any problem with regards to Mono? Regards, Hernán Martínez-Foffani _ OBI - on board intelligence Director de Tecnología hernan.marti...@obi-corp.commailto:hernan.marti...@obi-corp.com -- Dive into the World of Parallel Programming. The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net/___ 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: Shutdown - online problem
Even the previous version was cleaning up the pool. It's up to server what it does with connections based on shutdown type specified. -- Mgr. Jiří Činčura Independent IT Specialist -- New Year. New Location. New Benefits. New Data Center in Ashburn, VA. GigeNET is offering a free month of service with a new server in Ashburn. Choose from 2 high performing configs, both with 100TB of bandwidth. Higher redundancy.Lower latency.Increased capacity.Completely compliant. http://p.sf.net/sfu/gigenet ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Shutdown - online problem
Is the call in console app *exactly* the same as in web app? -- Mgr. Jiří Činčura Independent IT Specialist -- New Year. New Location. New Benefits. New Data Center in Ashburn, VA. GigeNET is offering a free month of service with a new server in Ashburn. Choose from 2 high performing configs, both with 100TB of bandwidth. Higher redundancy.Lower latency.Increased capacity.Completely compliant. http://p.sf.net/sfu/gigenet ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Prepare/reprepare?
Do I need to call Prepare() again on each FbCommand after the commit and new transaction assignment? You don't have to. As long as you keep it on same connection and same command. Btw, is there any way to check if a FbCommand is prepared or not? Not directly. -- Mgr. Jiří Činčura Independent IT Specialist -- Dive into the World of Parallel Programming. The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net/ ___ 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 connection very slow
The 10054 means Connection Reset By Peer. Looks like something on the machine is killing the connection. But might be also as you're debugging that you kill your application. Can you maybe create a simple console app and try the connection there. To eliminate stuff around. -- Mgr. Jiří Činčura Independent IT Specialist -- Dive into the World of Parallel Programming! The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net ___ 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 and VS 2015 preview
You mean DDEX? -- Mgr. Jiří Činčura Independent IT Specialist -- Dive into the World of Parallel Programming! The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Connect to Firebird database throws type initializer exception
Then just install it from NuGet and you’re fine. -- Mgr. Jiří Činčura Independent IT Specialist -- Dive into the World of Parallel Programming The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Connect to Firebird database throws type initializer exception
I need the the one for .NET 4.0 and installing from NuGet will give me version 4.5. No. It will not. -- Mgr. Jiří Činčura Independent IT Specialist -- Dive into the World of Parallel Programming The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Connect to Firebird database throws type initializer exception
Is that exception from DDEX/VS or from your application? -- Mgr. Jiří Činčura Independent IT Specialist -- Dive into the World of Parallel Programming The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Help generating an EDMX on EF6
Hi, Your set up looks correct, but EF cannot load the provider for some reason. What I haven’t tried is using embedded FB with EF6 and EDMX – as the provider with embedded needs some IL emit and the provider is now executed in copyied sandboxed environment it might be an issue. Just guessing. Maybe try (for development) use server. Or maybe you can get this https://github.com/cincuranet/EF6_Firebird/tree/master/EDMX and start from it. -- Mgr. Jiří Činčura Independent IT Specialist -- One dashboard for servers and applications across Physical-Virtual-Cloud Widest out-of-the-box monitoring support with 50+ applications Performance metrics, stats and reports that give you Actionable Insights Deep dive visibility with transaction tracing using APM Insight. http://ad.doubleclick.net/ddm/clk/290420510;117567292;y___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Help generating an EDMX on EF6
Nope. -- Mgr. Jiří Činčura Independent IT Specialist From: Brian Liedtke [mailto:lied...@frii.com] Sent: Monday, May 11, 2015 12:50 AM To: For users and developers of the Firebird .NET providers Subject: Re: [Firebird-net-provider] Help generating an EDMX on EF6 So the EF_6 symbol should not be set for FirebirdSql.Data.FirebirdClient? Brian From: Jiří Činčuramailto:j...@cincura.net Sent: Sunday, May 10, 2015 4:34 AM To: For users and developers of the Firebird .NET providersmailto:firebird-net-provider@lists.sourceforge.net Subject: Re: [Firebird-net-provider] Help generating an EDMX on EF6 The EF_6 is there for EntityFramework.Firebird, as there’s some shared code. -- Mgr. Jiří Činčura Independent IT Specialist From: Brian Liedtke [mailto:lied...@frii.com] Sent: Saturday, May 9, 2015 5:32 AM To: For users and developers of the Firebird .NET providers Subject: Re: [Firebird-net-provider] Help generating an EDMX on EF6 Hey Jiri, Thanks for your response. I downloaded the source code (NETProvider-4.6.2.0-src.7z) from the Firebirdsql.org site. Built it, copied the libraries to my projects packages directory. Same thing happened. So I started crawling around the code to see what I can find. First thing I noticed, the conditional compilation symbols in the properties of the FirebirdSql.Data.FirebirdClient project’s Build tab is missing the EF_6 symbol. I’ve added that to my copy and attempted to rebuild it. Got some build errors that I’m trying to resolve concerning using FirebirdSql.Data.Entity; in FirebirdSql.Data.FirebirdClient/FbProviderManifest. While I am working on that, I wanted to check to make sure that the EF_6 compilation symbol was set in the build you made for the NuGet package. It could explain why I am getting the error I receive when trying to generate an edmx. Don’t know how close the source code that I downloaded is to what you used to generate the NuGet package. But it was something that jumped out at me. Brian Liedtke -- One dashboard for servers and applications across Physical-Virtual-Cloud Widest out-of-the-box monitoring support with 50+ applications Performance metrics, stats and reports that give you Actionable Insights Deep dive visibility with transaction tracing using APM Insight. http://ad.doubleclick.net/ddm/clk/290420510;117567292;y___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Help generating an EDMX on EF6
Why? EF6 provider is separate. -- Mgr. Jiří Činčura Independent IT Specialist From: Brian Liedtke [mailto:lied...@frii.com] Sent: Monday, May 11, 2015 6:52 AM To: For users and developers of the Firebird .NET providers Subject: Re: [Firebird-net-provider] Help generating an EDMX on EF6 Interesting. Reason? Would think that FirebirdClient should be compiled for Entity Framework 6. Brian From: Jiří Činčuramailto:j...@cincura.net Sent: Sunday, May 10, 2015 10:30 PM To: For users and developers of the Firebird .NET providersmailto:firebird-net-provider@lists.sourceforge.net Subject: Re: [Firebird-net-provider] Help generating an EDMX on EF6 Nope. -- Mgr. Jiří Činčura Independent IT Specialist From: Brian Liedtke [mailto:lied...@frii.com] Sent: Monday, May 11, 2015 12:50 AM To: For users and developers of the Firebird .NET providers Subject: Re: [Firebird-net-provider] Help generating an EDMX on EF6 So the EF_6 symbol should not be set for FirebirdSql.Data.FirebirdClient? Brian From: Jiří Činčuramailto:j...@cincura.net Sent: Sunday, May 10, 2015 4:34 AM To: For users and developers of the Firebird .NET providersmailto:firebird-net-provider@lists.sourceforge.net Subject: Re: [Firebird-net-provider] Help generating an EDMX on EF6 The EF_6 is there for EntityFramework.Firebird, as there’s some shared code. -- Mgr. Jiří Činčura Independent IT Specialist -- One dashboard for servers and applications across Physical-Virtual-Cloud Widest out-of-the-box monitoring support with 50+ applications Performance metrics, stats and reports that give you Actionable Insights Deep dive visibility with transaction tracing using APM Insight. http://ad.doubleclick.net/ddm/clk/290420510;117567292;y___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Help generating an EDMX on EF6
The EF_6 is there for EntityFramework.Firebird, as there’s some shared code. -- Mgr. Jiří Činčura Independent IT Specialist From: Brian Liedtke [mailto:lied...@frii.com] Sent: Saturday, May 9, 2015 5:32 AM To: For users and developers of the Firebird .NET providers Subject: Re: [Firebird-net-provider] Help generating an EDMX on EF6 Hey Jiri, Thanks for your response. I downloaded the source code (NETProvider-4.6.2.0-src.7z) from the Firebirdsql.org site. Built it, copied the libraries to my projects packages directory. Same thing happened. So I started crawling around the code to see what I can find. First thing I noticed, the conditional compilation symbols in the properties of the FirebirdSql.Data.FirebirdClient project’s Build tab is missing the EF_6 symbol. I’ve added that to my copy and attempted to rebuild it. Got some build errors that I’m trying to resolve concerning using FirebirdSql.Data.Entity; in FirebirdSql.Data.FirebirdClient/FbProviderManifest. While I am working on that, I wanted to check to make sure that the EF_6 compilation symbol was set in the build you made for the NuGet package. It could explain why I am getting the error I receive when trying to generate an edmx. Don’t know how close the source code that I downloaded is to what you used to generate the NuGet package. But it was something that jumped out at me. Brian Liedtke From: Jiří Činčuramailto:j...@cincura.net Sent: Monday, May 4, 2015 12:40 AM To: For users and developers of the Firebird .NET providersmailto:firebird-net-provider@lists.sourceforge.net Subject: Re: [Firebird-net-provider] Help generating an EDMX on EF6 Hi, Your set up looks correct, but EF cannot load the provider for some reason. What I haven’t tried is using embedded FB with EF6 and EDMX – as the provider with embedded needs some IL emit and the provider is now executed in copyied sandboxed environment it might be an issue. Just guessing. Maybe try (for development) use server. Or maybe you can get this https://github.com/cincuranet/EF6_Firebird/tree/master/EDMX and start from it. -- Mgr. Jiří Činčura Independent IT Specialist From: Brian Liedtke [mailto:lied...@frii.com] Sent: Sunday, May 3, 2015 3:45 AM To: firebird-net-provider@lists.sourceforge.netmailto:firebird-net-provider@lists.sourceforge.net Subject: [Firebird-net-provider] Help generating an EDMX on EF6 Hey all, I’ve been beating my head against the wall this past week trying to get this solved. After reading Jiri’s blog on upgrading to EF6 and going through the email archives, I haven’t found a solution. After trying everything I can think of I am out of ideas. Here what is happening. I am trying to upgrade to EF6. Everything looks good on the install. I can build and run but when I try to generate an EDMX, I get the following error. [image] -- One dashboard for servers and applications across Physical-Virtual-Cloud Widest out-of-the-box monitoring support with 50+ applications Performance metrics, stats and reports that give you Actionable Insights Deep dive visibility with transaction tracing using APM Insight. http://ad.doubleclick.net/ddm/clk/290420510;117567292;y___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Deployment for EF6 + Firebird .net Application
Hi, If you installed the FirebirdClient form NuGet the app.config should have been updated for you automatically. -- Mgr. Jiří Činčura Independent IT Specialist -Original Message- From: Parzival [mailto:parzival1...@gmx.at] Sent: Tuesday, May 19, 2015 7:42 AM To: 'For users and developers of the Firebird .NET providers' Subject: Re: [Firebird-net-provider] Deployment for EF6 + Firebird .net Application Hello, I have found a message form Jiri on his webpage that describes and solves the problem: http://blog.cincura.net/7975-deploying-the-asp-net-application-which-is- usin g-firebird-net-data-provider-with-design-time-support/ Niko -Ursprüngliche Nachricht- Von: Victor Bautista [mailto:victor.jac...@gmail.com] Gesendet: Dienstag, 19. Mai 2015 03:21 An: firebird-net-provider@lists.sourceforge.net Betreff: Re: [Firebird-net-provider] Deployment for EF6 + Firebird .net Application Hi Parzival, You need to add the file FBCLIENT.DLL which is found in your C:\Program Files\Firebird\Firebird_2_5\bin (or wherever your Firebird folder is). HTH. -- -- -- One dashboard for servers and applications across Physical-Virtual-Cloud Widest out-of-the-box monitoring support with 50+ applications Performance metrics, stats and reports that give you Actionable Insights Deep dive visibility with transaction tracing using APM Insight. http://ad.doubleclick.net/ddm/clk/290420510;117567292;y ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- One dashboard for servers and applications across Physical-Virtual-Cloud Widest out-of-the-box monitoring support with 50+ applications Performance metrics, stats and reports that give you Actionable Insights Deep dive visibility with transaction tracing using APM Insight. http://ad.doubleclick.net/ddm/clk/290420510;117567292;y ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- One dashboard for servers and applications across Physical-Virtual-Cloud Widest out-of-the-box monitoring support with 50+ applications Performance metrics, stats and reports that give you Actionable Insights Deep dive visibility with transaction tracing using APM Insight. http://ad.doubleclick.net/ddm/clk/290420510;117567292;y ___ 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 4.6.2.0
More info http://blog.cincura.net/233504-ado-net-provider-4-6-2-0-for-firebird-is-ready/ . -- Mgr. Jiří Činčura Independent IT Specialist -- BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT Develop your own process in accordance with the BPMN 2 standard Learn Process modeling best practices with Bonita BPM through live exercises http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_ source=Sourceforge_BPM_Camp_5_6_15utm_medium=emailutm_campaign=VA_SF ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] FbBatchExecution
Hi guys, Looking at FbBatchExecution's ctor I don't see a reason why it takes FbScript. It should rather be FbStatementCollection I think. The FbBatchExecution is doing nothing with the FbScript. It just needs commands. What do you think? I would add another overload to ctor and make the one with FbScript obsolete. -- 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 4.6.3.0
More info http://blog.cincura.net/233510-ado-net-provider-4-6-3-0-for-firebird-is-ready/ . -- Mgr. Jiří Činčura Independent IT Specialist -- Monitor 25 network devices or servers for free with OpManager! OpManager is web-based network management software that monitors network devices and physical virtual servers, alerts via email sms for fault. Monitor 25 devices for free with no restriction. Download now http://ad.doubleclick.net/ddm/clk/292181274;119417398;o ___ 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 4.6.4.0
More info http://blog.cincura.net/233511-ado-net-provider-4-6-4-0-for-firebird-is-ready/ . -- Mgr. Jiří Činčura Independent IT Specialist -- Monitor 25 network devices or servers for free with OpManager! OpManager is web-based network management software that monitors network devices and physical virtual servers, alerts via email sms for fault. Monitor 25 devices for free with no restriction. Download now http://ad.doubleclick.net/ddm/clk/292181274;119417398;o ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Keep-alive packets
Hi *, This is what I read just now: RFC 1122, section 4.2.3.6 indicates that acknowledgements for TCP keepalives without data may not be transmitted reliably by routers; this may cause valid connections to be dropped. Furthermore, TCP/IP stacks are not required to support keepalives at all (and many embedded stacks do not), so this solution may not translate to other platforms. This might explain why still some events (connections) are (sometimes) lost, even though we use keep-alive on that socket. -- 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] FbBatchExecution
Thinking more about it. Maybe the ctor should be only with optional FbConnection and the rest can be done via SqlStatements property. Then it's not tied to FbScript at all. Maybe then the FbStatementCollection can have a simple helper method Add(FbStatementCollection) (or something like that). Then it would look like: var batchExecution = new FbBatchExceution(); batchExecution.Statements.Add(script.Results); //maybe rename Results Statements??? batchExecution.Execute(); Looks good to me. -- Mgr. Jiří Činčura Independent IT Specialist -Original Message- From: Jiří Činčura Sent: Wednesday, June 10, 2015 3:36 PM To: firebird-net-provider@lists.sourceforge.net Subject: FbBatchExecution Hi guys, Looking at FbBatchExecution's ctor I don't see a reason why it takes FbScript. It should rather be FbStatementCollection I think. The FbBatchExecution is doing nothing with the FbScript. It just needs commands. What do you think? I would add another overload to ctor and make the one with FbScript obsolete. -- 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] FbBatchExecution
That breaks the notion of single point for interaction. -- 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] Setting LockTables in FbTransactionOptions with string[] of Tables to Lock
You can’t use string[]. You need to specify the locking, hence the IDictionary. -- 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] DNet 176 and 564
Hi, Create a PR, so it can be commented there. That’s easiest. -- Mgr. Jiří Činčura Independent IT Specialist From: Amro El-Fakharany [mailto:amro00...@gmail.com] Sent: Tuesday, June 2, 2015 4:29 PM To: firebird-net-provider@lists.sourceforge.net Subject: [Firebird-net-provider] DNet 176 and 564 Hi all, I’m trying to provide a patch fort the mentioned Jira issues. The patch can be found here: https://github.com/amroel/NETProvider/commit/576b16bc1afcb5f8373c149f928ef62c597e5373 Would someone please review it before I submit a pull request? Jiri? Thank you Amro -- ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Events on FbBatchExecution firing opinion
Hi *, I would like to hear some opinions on http://tracker.firebirdsql.org/browse/DNET-390?focusedCommentId=29671page=com.atlassian.jira.plugin.system.issuetabpanels%3Acomment-tabpanel#action_29671 . What do you think? -- Mgr. Jiří Činčura Independent IT Specialist -- Don't Limit Your Business. Reach for the Cloud. GigeNET's Cloud Solutions provide you with the tools and support that you need to offload your IT needs and focus on growing your business. Configured For All Businesses. Start Your Cloud Today. https://www.gigenetcloud.com/ ___ 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 6.0 use context.Database.Connection
Is it ok to use the connection of the EF context for this purpose? Cast it to (fbConnection)Context.Database.Connection That's absolutely fine. -- Mgr. Jiří Činčura Independent IT Specialist -- One dashboard for servers and applications across Physical-Virtual-Cloud Widest out-of-the-box monitoring support with 50+ applications Performance metrics, stats and reports that give you Actionable Insights Deep dive visibility with transaction tracing using APM Insight. http://ad.doubleclick.net/ddm/clk/290420510;117567292;y ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Structs
Hi *, Anybody feels like giving me reason why not to make FbTransactionOptions, FbDatabasesInfo and FbServerConfig classes? I don't see a single reason to have struct here. In fact quite contrary. OK, maybe the FbTransactionOptions could make it. -- 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] Problem using embedded version:IDE is waiting to terminate a process up to 7 seconds
Hi, Can you test it with latest provider? 2.7.7 is couple of years old. -- 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] ADO.NET provider 4.7.0.0 and DDEX 3.0.2
Yes, it’s on NuGet. It might take a minute or two before it’s indexed (so it should be done now for sure). -- Mgr. Jiří Činčura Independent IT Specialist From: Alexander Muylaert-Gelein [mailto:amuylaert_gel...@hotmail.com] Sent: Friday, July 24, 2015 9:12 AM To: firebird-net-provider@lists.sourceforge. Subject: Re: [Firebird-net-provider] ADO.NET provider 4.7.0.0 and DDEX 3.0.2 Hi Jiri Thanks, I'll make sure it is tested this weekend on our servers. Already available on nuget, because update-package doesn't work yet? thanks a From: j...@cincura.netmailto:j...@cincura.net To: firebird-net-provider@lists.sourceforge.netmailto:firebird-net-provider@lists.sourceforge.net; firebird-de...@lists.sourceforge.netmailto:firebird-de...@lists.sourceforge.net; firebird-to...@yahoogroups.commailto:firebird-to...@yahoogroups.com Date: Fri, 24 Jul 2015 07:01:39 + Subject: [Firebird-net-provider] ADO.NET provider 4.7.0.0 and DDEX 3.0.2 More info: * http://blog.cincura.net/233515-ado-net-provider-4-7-0-0-for-firebird-is-ready/ * http://blog.cincura.net/233514-ddex-provider-3-0-2-for-firebird-released/ The uploads on SF will be done when SF is back up working. -- Mgr. Jiří Činčura Independent IT Specialist -- ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.netmailto: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] Read allowed despite locking table in transaction
Don’t do that. Database engine (any) people do a great effort to reach maximum
throughput and you want to limit it to basically 1. If you need someething like
that, your design has serious flaw.
--
Mgr. Jiří Činčura
Independent IT Specialist
From: LtColRDSChauhan [mailto:rdsc1...@gmail.com]
Sent: Tuesday, July 21, 2015 12:48 PM
To: firebird-net-provider@lists.sourceforge.net
Subject: [Firebird-net-provider] Read allowed despite locking table in
transaction
Hello,
Earlier, by mistake I sent an incomplete mail on this issue. Apologies for the
same.
1. I want to lock a table then :
(a) read a record from this table and then
(b) write a record to this table.
2. While I do the above, I want to disallow read and write to this table.
3. The below mentioned code allows read while the transaction is in progress.
tx = con.BeginTransaction(
new FbTransactionOptions() {
TransactionBehavior =
FbTransactionBehavior.Consistency | FbTransactionBehavior.NoWait,
LockTables = new Dictionarystring,
FbTransactionBehavior {
{lockTable1, FbTransactionBehavior.Protected |
FbTransactionBehavior.LockRead | FbTransactionBehavior.Exclusive}
}
}
4. Environment :
(a) FirebirdSql.Data.FirebirdClient-4.6.4.0
(b) Firebird-2.5.4.26856_0_Win32
(c) .NET 4.5.2
5. Please help.
Thanks and Regards,
Rajiv
--
Don't Limit Your Business. Reach for the Cloud.
GigeNET's Cloud Solutions provide you with the tools and support that
you need to offload your IT needs and focus on growing your business.
Configured For All Businesses. Start Your Cloud Today.
https://www.gigenetcloud.com/___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] DNET-607
Does the releasing/disposing also require locking on _syncroot? If so: No. -- 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] *** GMX Spamverdacht *** Re: Correct closing of an entity framework connection
On Mon, Oct 26, 2015, at 15:16, Parzival wrote: > _fbConnectionStringBuilder:Pooling := .T. Just for the sake of testing, can you turn it off. Then the connection is closed immediately. And we should see whether there's something dangling or not. -- 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] Stored procedures not added to model
What's the signature of that SP? -- Mgr. Jiří Činčura Independent IT Specialist On Wed, Oct 28, 2015, at 09:53, Mr. John wrote: > HiI'm using FB2.5,VS 2013,FirebirdClient 4.8.1.0,DDEXProvider 3.0.2.0 > When I try to add a stored procedure to model from database using Update > model from database.,I select/check the sp name in the list,but no > procedure is added to model,also in Model Browser nothing added,in > function import no SP name to selectsearching on google for that problem > I found complaining about this problem but no solving clue > thanks > -- > ___ > 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] Correct closing of an entity framework connection
Are you using connection pooling? How was the application closed - regular close or killed from debugger? -- 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] 4.9.0 beta 1 release
Hi * before I'll start cracking on FB 3 support (we have some good PRs) I'd like to get some features out. The list of changes is in http://tracker.firebirdsql.org/browse/DNET/fixforversion/10722 (and also some internal network stuff changes - check the commits if you're interested). Test it. Probably the long awaited is EF Migrations [3] support. You can us the new `FbMigrationSqlGenerator` [1] class. It's registered by default, but if you want to play harder check these lines [2]. Try it, discuss it here. Known issue [5]. The version is available on *NuGet only* [4]. [1]: https://github.com/cincuranet/FirebirdSql.Data.FirebirdClient/blob/master/NETProvider/src/EntityFramework.Firebird/FbMigrationSqlGenerator.cs [2]: https://github.com/cincuranet/FirebirdSql.Data.FirebirdClient/blob/master/NETProvider/src/FirebirdSql.Data.FirebirdClient/FirebirdClient/FbProviderServices.cs#L69,L70 [3]: https://msdn.microsoft.com/en-us/data/jj591621.aspx [4]: https://www.nuget.org/packages/FirebirdSql.Data.FirebirdClient/4.9.0-beta1 [5]: http://entityframework.codeplex.com/workitem/2683 -- 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] Stored procedures not added to model
On Mon, Nov 2, 2015, at 19:16, Mr. John wrote: > and use for stored procedures classic ADO.NET Why? You can still configure the SP in model manually. It's already there. -- 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] *** GMX Spamverdacht *** Re: *** GMX Spamverdacht *** Re: Correct closing of an entity framework connection
On Sun, Nov 1, 2015, at 10:41, Parzival wrote: > I tried now to set the ConnectionPooling to false and the error > message is not shown any more in firebird.log. It's same cause as http://tracker.firebirdsql.org/browse/DNET-632, which is fixed. It will be released with next version. > What does this mean in terms of performance, when I remove the > ConnectionPooling? You might see some slower connection opening if you're on high latency network. > At the moment I am using a gobal context for the whole application. Is > this ok or not ok? If the application is not running 24/7, it's mostly not a problem. -- 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] Stored procedures not added to model
On Wed, Oct 28, 2015, at 12:56, Mr. John wrote: > Hi > > this is the simplest SP I have: > > CREATE OR ALTER PROCEDURE PR_GETCFNAME(id bigint)returns ( NAME > varchar(100))asbegin select first 1 NAME from cf where id=:id into > :NAME; suspend;end > > > > thanks Works fine for me. It imported on a first try. Check http://snag.gy/N9svt.jpg . Because it's selectable in FIrebird it's composable in EF and I can see it dropdown when adding function import (I haven't used the automatic import - sometimes it fucks up). -- 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] Stored procedures not added to model
On Mon, Nov 2, 2015, at 13:51, Mr. John wrote: > indeed it's ok for you,but for me not.I use automatic import,what options > I have to make it works for methanks Just untick it? ... -- 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] *** GMX Spamverdacht *** Re: *** GMX Spamverdacht *** Re: Correct closing of an entity framework connection
On Tue, Nov 3, 2015, at 15:29, Parzival wrote: > when do you plan to release the next version of the .net provider with > this fix? The beta will go out sometime this week or early next week. Beta because of the migrations and some network changes. Although tests are OK, you never know. -- 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] *** GMX Spamverdacht *** Re: *** GMX Spamverdacht *** Re: Correct closing of an entity framework connection
On Tue, Nov 3, 2015, at 15:11, Parzival wrote: > What is the planned schedule for 4.8.x? What do you mean? -- 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] *** GMX Spamverdacht *** Re: *** GMX Spamverdacht *** Re: Correct closing of an entity framework connection
On Tue, Nov 3, 2015, at 14:09, emel wrote: > But only when 'ConnectionPooling is false', is it? No. > Must I unhand a context, if I had got it from pool, when i don't use it? There's no pool for context. Only connections. -- 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
