Re: [Firebird-net-provider] Connection pool bug

2013-11-14 Thread Jiri Cincura
On Thu, Nov 14, 2013 at 5:50 PM, Danny Gorton wrote: > However, that shouldn't really affect what you're doing much since we're Yeah, I just like to hear what are others doing and thinking. > also not considering updating the Firebird provider at this time either. > The version we have seems t

Re: [Firebird-net-provider] Connection pool bug

2013-11-14 Thread Jiri Cincura
On Thu, Nov 14, 2013 at 11:46 AM, Zvjezdan Tomičević wrote: > Polling with default value I'm asking to know what "resolution" should the cleanup routine have. Like if everybody uses lifetime 10s, than resolution 5s is fine, even 10s is fine, though the connection might be in a pool little longer.

Re: [Firebird-net-provider] Connection pool bug

2013-11-14 Thread Jiri Cincura
And just a one quick "research" question. What's your common connection lifetime value for pooling? Do you change it or do you use the default one? -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com -

Re: [Firebird-net-provider] Connection pool bug

2013-11-14 Thread Jiri Cincura
Hi, On Wed, Nov 13, 2013 at 8:34 PM, Danny Gorton wrote: > If 4.0 backward compatibility is > OK, then it would be OK It's probbaly not 100%, but in case you're not relying on some "weird" behavior you found, you should be OK. You can read: http://msdn.microsoft.com/en-us/library/ee941656%28VS.1

Re: [Firebird-net-provider] Connection pool bug

2013-11-13 Thread Jiri Cincura
OK guys. First thanks for the support. It's not an easy change and there's a lot of code already and I need to squeeze myself in, with my concept. But here are some first numbers: * [1] With connection pooling ON and OLD provider the application gained about 276KB in ~30 minutes. * [2] With connec

Re: [Firebird-net-provider] DDEX VS2013 Support

2013-11-13 Thread Jiri Cincura
Hi, 2013/11/13 Kevin Schmitz > > add DDEX support for VS2013 the DDEX provider supports VS2013. You can use it without any limitation. You only need to (currently) install it manually (at least changing registry keys). I'm planning to update the installer soon, but now I'm in the connection pool

[Firebird-net-provider] Connection pool bug

2013-11-12 Thread Jiri Cincura
Hi *, I found a bug in connection pool. I *don't* know the root cause. But anyway I think the code there isn't "good" or "nice", so to speak. But I currently have an application in front of me, that escalates the problem, some memory leaks. I think I might go to rewrite the pooling (I implemented

Re: [Firebird-net-provider] Locking rework

2013-11-05 Thread Jiri Cincura
On Mon, Nov 4, 2013 at 4:35 PM, André Knappstein wrote: > I am definitely incapable of inventing sophisticated test suites by > myself, but I am always willing to help if I can. > > I have some spare machines running different Windows versions and > surely won't need them for several da

Re: [Firebird-net-provider] Locking rework

2013-11-02 Thread Jiri Cincura
Oh, maybe good to know. In 99% there will be no data corruption or something like that. It'll just run fine or crash in huge fire. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com ---

[Firebird-net-provider] Locking rework

2013-11-02 Thread Jiri Cincura
Hi *, is here anybody who I'd like to put FirebirdClient into (long) test under (preferably) some load? I started work on async support and with that I'll also have to redo all the lock-ing there. Because these are either wrong or not necessary (and often both). But there's also a lot of magic ha

Re: [Firebird-net-provider] DbProviderServices

2013-10-23 Thread Jiri Cincura
Read this http://blog.cincura.net/233426-entity-framework-6-with-firebird/ and *understand* it. Then you should be able to go thru tooling as well. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com -

Re: [Firebird-net-provider] DbProviderServices

2013-10-23 Thread Jiri Cincura
On Wed, Oct 23, 2013 at 10:47 AM, Rand Random wrote: > Do you know a way to figure out what application is using the 3.0.2.0 > version that cant be uninstalled threw the gacutil -u command? Process Explorer and then close the application. -- Jiri {x2} Cincura (x2develop.com founder) http://blog

Re: [Firebird-net-provider] NullReferenceException in my web service application

2013-10-23 Thread Jiri Cincura
On Tue, Oct 22, 2013 at 4:54 PM, Halim Boumedjirek wrote: > I was able to upgrade to 3.2.0 and test again but still no luck. > We are getting the same exceptions. Good. So *create a test case* and report it. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3

Re: [Firebird-net-provider] DbProviderServices

2013-10-23 Thread Jiri Cincura
On Tue, Oct 22, 2013 at 4:18 PM, Rand Random wrote: > When I run the application EntityModel gets initialized successful, but when > I try to run a simple LINQ query I am getting the following message: > > An exception of type 'System.InvalidOperationException' occurred in > System.Data.dll but wa

Re: [Firebird-net-provider] DbProviderServices

2013-10-22 Thread Jiri Cincura
Yes, in config you're missing the DbProviderFactories, that also means, given the error, that the provider is loaded from somewhere else, very likely GAC, -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com --

Re: [Firebird-net-provider] DbProviderServices

2013-10-22 Thread Jiri Cincura
On Tue, Oct 22, 2013 at 11:25 AM, Rand Random wrote: > type="FirebirdSql.Data.FirebirdClient.FirebirdClientFactory, > FirebirdSql.Data.FirebirdClient" /> Now I see it. This line is wrong. It should be And I suppose you have proper record in DbProviderFactories. -- Jiri {x2} Cincura (x2develo

Re: [Firebird-net-provider] DbProviderServices

2013-10-22 Thread Jiri Cincura
Check gacutil. And also procmon will tell you what's loading and from where. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com -- October Webinars: Code for Performance Fr

Re: [Firebird-net-provider] DbProviderServices

2013-10-22 Thread Jiri Cincura
On Tue, Oct 22, 2013 at 11:52 AM, Rand Random wrote: > I have the NETProvider-3.2.0.0.msi and DDEXProvider-3.0.0.0.msi installed, > is it recommended to deinstall them and losing the feature of modeling the > EDMX in VS? If you're using VS2013 and EF6 you need EF6 provider. DDEX can be left untou

Re: [Firebird-net-provider] DbProviderServices

2013-10-22 Thread Jiri Cincura
On Tue, Oct 22, 2013 at 11:35 AM, Rand Random wrote: > And how can I load the EF6 version of provider, when I look at my references > in solution its telling me the correct path to the NuGet Package. Probably you have other version somewhere. Maybe GAC, bin, ... -- Jiri {x2} Cincura (x2develop.

Re: [Firebird-net-provider] DbProviderServices

2013-10-22 Thread Jiri Cincura
You're not loading EF6 version of provider. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com -- October Webinars: Code for Performance Free Intel webinars can help you ac

Re: [Firebird-net-provider] Backup with fbembed cannot open database file

2013-10-21 Thread Jiri Cincura
On Sun, Oct 20, 2013 at 10:40 PM, Pierre Arnaud wrote: > It's an FbException wrapping an IscException with the following message: > > I/O error during "CreateFile (open)" operation for file > "C:\PROGRAMDATA\FOO\BAR.FIREBIRD" > Error while trying to open file Well, this is more or less gene

Re: [Firebird-net-provider] Backup with fbembed cannot open database file

2013-10-20 Thread Jiri Cincura
On Sun, Oct 20, 2013 at 9:02 PM, Pierre Arnaud wrote: > Calling FbBackup.Execute throws the exception because of the sharing > violation. What's the message exactly? -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com -

Re: [Firebird-net-provider] Backup with fbembed cannot open database file

2013-10-20 Thread Jiri Cincura
You mean FbBackup? -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com -- October Webinars: Code for Performance Free Intel webinars can help you accelerate application perf

Re: [Firebird-net-provider] NullReferenceException in my web service application

2013-10-16 Thread Jiri Cincura
You should first update to 3.2.0. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com -- October Webinars: Code for Performance Free Intel webinars can help you accelerate a

Re: [Firebird-net-provider] Provider 3.2.0.0 EF6 Exception

2013-10-14 Thread Jiri Cincura
On Mon, Oct 14, 2013 at 5:03 AM, Muthu Annamalai wrote: > Make sure that the assembly-qualified name is used and that > the assembly is available to the running application. The runtime is unable to load the assembly. See ^. It should be in GAC, near application etc. -- Jiri {x2} Cincura (x2de

Re: [Firebird-net-provider] Provider 3.2.0.0 EF6 Exception

2013-10-07 Thread Jiri Cincura
Looks like you're not using EF6 version. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com -- October Webinars: Code for Performance Free Intel webinars can help you accele

[Firebird-net-provider] .NET provider 3.2.0.0 released

2013-10-05 Thread Jiri Cincura
More info at http://blog.cincura.net/233420-ado-net-provider-for-firebird-3-2-0-0-is-ready/ . -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com -- October Webinars: Code f

Re: [Firebird-net-provider] fbdataadapter: fill() converting to uppercase?

2013-10-04 Thread Jiri Cincura
On Fri, Oct 4, 2013 at 2:03 PM, André Knappstein wrote: > When I help people migrating from dBase to C#, I show them how easy > you can drag/drop your tables on the form and get running in about no > time. Big "h! Fine!". > Then I show them the code that's been generated, some 4.000 line

Re: [Firebird-net-provider] fbdataadapter: fill() converting to uppercase?

2013-10-02 Thread Jiri Cincura
On Wed, Oct 2, 2013 at 1:28 PM, André Knappstein wrote: > OK, thank you anyway. > I think I will be telling them to re-create the databases, this time > using a character set *and* *not* the quoted identifiers. I think removing the quoted identifiers is a better way anyway. For the future etc.

Re: [Firebird-net-provider] fbdataadapter: fill() converting to uppercase?

2013-10-02 Thread Jiri Cincura
Not 100% sure, but I think it's something in the DbDataAdapter the FbDataAdapter derives from. I don't know a place where this casing etc. in FirebirdClient would happen. :( On Wed, Oct 2, 2013 at 10:47 AM, André Knappstein wrote: > Yes. > > >> Are you creating the FbDataAdapter in code? > > > >

Re: [Firebird-net-provider] fbdataadapter: fill() converting to uppercase?

2013-10-01 Thread Jiri Cincura
Are you creating the FbDataAdapter in code? -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com -- October Webinars: Code for Performance Free Intel webinars can help you ac

Re: [Firebird-net-provider] what is the correct way to close the trace api service?

2013-08-30 Thread Jiri Cincura
You need to close it via another instance of FbTrace. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com -- Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012,

[Firebird-net-provider] [FB-Tracker] Reopened: (DNET-516) Installer fails on 32bit systems

2013-08-24 Thread Jiri Cincura (JIRA)
[ http://tracker.firebirdsql.org/browse/DNET-516?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiri Cincura reopened DNET-516: --- > Installer fails on 32bit systems > > > K

[Firebird-net-provider] ADO.NET provider for Firebird 3.1.1.0

2013-08-18 Thread Jiri Cincura
Hi *, The version 3.1.1.0 of ADO.NET provider for Firebird is ready for your download! More info: http://blog.cincura.net/233399-ado-net-provider-for-firebird-3-1-1-0-is-ready/ . -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com

Re: [Firebird-net-provider] Releasing more often???

2013-07-29 Thread Jiri Cincura
http://blog.cincura.net/233371-firebirds-ado-net-provider-sources-has-a-new-home/ and http://blog.cincura.net/233379-ado-net-provider-for-firebird-3-1-0-0-is-ready/ . First steps. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com

Re: [Firebird-net-provider] Improving

2013-07-29 Thread Jiri Cincura
http://blog.cincura.net/233371-firebirds-ado-net-provider-sources-has-a-new-home/ -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com -- Get your SQL database under version c

[Firebird-net-provider] ADO.NET provider for Firebird 3.1.0.0

2013-07-29 Thread Jiri Cincura
Hi *, The version 3.1.0.0 of ADO.NET provider for Firebird is ready for your download! More info: http://blog.cincura.net/233379-ado-net-provider-for-firebird-3-1-0-0-is-ready/ . -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com

Re: [Firebird-net-provider] Windows Phone 8

2013-07-18 Thread Jiri Cincura
I think the root is even deeper. WP does not contain ADO.NET stack at all. You're not expected to connect to local database, rather use some "data service" and connect via network (which makes sense today). Yes, of course, you can always do your own ADO.NET clone and run some database of your own.

Re: [Firebird-net-provider] Cancel in FB embedded slow?

2013-07-04 Thread Jiri Cincura
Yes, this is fine for Firebird. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com -- This SF.net email is sponsored by Windows: Build for Windows Store. http://p.sf.net/s

Re: [Firebird-net-provider] Cancel in FB embedded slow?

2013-07-03 Thread Jiri Cincura
On Wed, Jul 3, 2013 at 12:36 PM, HERNAN MARTINEZ FOFFANI wrote: > I have a wrapper class that abstracts some layers and on some database > engines (I don't remember which one, it might be SQLServer) if you call > Close() on a command whose reader weren't consumed the Close() keeps > reading the re

Re: [Firebird-net-provider] Improving

2013-07-03 Thread Jiri Cincura
On Wed, Jul 3, 2013 at 2:02 PM, Mark Rotteveel wrote: > SourceForge also provides a Git repo. Have you looked into that? Yes. No way I'm going that direction. Almost no features. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com --

Re: [Firebird-net-provider] Improving

2013-07-03 Thread Jiri Cincura
Yeah. I would need to discuss this with other project admins. So it might not work at all. GitHub has support for organisations so that's even better for project (the repo would be official). On Wednesday, July 3, 2013, André Knappstein wrote: > Jiri, > > not so that you get an impression we were

Re: [Firebird-net-provider] Improving

2013-07-03 Thread Jiri Cincura
And today even better https://github.com/blog/1547-release-your-software . On Wednesday, July 3, 2013, Jiri Cincura wrote: > Hi *, > > maybe you remember the thread "Releasing more often???". Yeah and > nothing happened. :) Because there was not a strong protest, I think &

Re: [Firebird-net-provider] Cancel in FB embedded slow?

2013-07-03 Thread Jiri Cincura
On Wed, Jul 3, 2013 at 11:28 AM, HERNAN MARTINEZ FOFFANI wrote: > What I didn't expect was that all command.Cancel()'s to take (as reported by > the profiler) more than 50% of the time. Such command is an ExecuteQuery > and the DataReader had already read all the records. And why are you calling

[Firebird-net-provider] Improving

2013-07-03 Thread Jiri Cincura
Hi *, maybe you remember the thread "Releasing more often???". Yeah and nothing happened. :) Because there was not a strong protest, I think it's something we all 'd like to have. I was lately really pissed of by SF's SVN. If you worked with it, not just committing, I think just using it, you can

[Firebird-net-provider] [FB-Tracker] Created: (DNET-510) Support Database.Exists

2013-07-03 Thread Jiri Cincura (JIRA)
: 3.0.2.0 Reporter: Jiri Cincura Assignee: Jiri Cincura Priority: Minor Support Database.Exists by just trying to open the connection. As agreed in list. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the

Re: [Firebird-net-provider] Checking database existence

2013-07-03 Thread Jiri Cincura
OK, DNET-510. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com -- This SF.net email is sponsored by Windows: Build for Windows Store. http://p.sf.net/sfu/windows-dev2dev

Re: [Firebird-net-provider] ClearAllPools and opened connections

2013-07-03 Thread Jiri Cincura
Well, because we don't have a strong agreement how it should behave AND nobody even cared until today :D, I'll leave it as is. We can always revisit this later. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com --

Re: [Firebird-net-provider] Cancel in FB embedded slow?

2013-07-03 Thread Jiri Cincura
On Tue, Jul 2, 2013 at 6:21 PM, HERNAN MARTINEZ FOFFANI wrote: > Profiling my application I found that one bottleneck seems to be when > canceling a cursor. It also happens even if it was already consumed (i.e., What bottleneck? > finished to read all the rows). > Is this an expected behavior? I

[Firebird-net-provider] Checking database existence

2013-06-05 Thread Jiri Cincura
Hi *, I was recently rethinking some stuff we do (or not) support for Entity Framework. One think we don't support is checking database existence (migrations, initializers, ...). I know the API itself doesn't support it, but as I checked how other tools and products are solving it it's basically a

Re: [Firebird-net-provider] Deprecating T4 template for EF's Model First

2013-06-04 Thread Jiri Cincura
Done. DNET-507 -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com -- How ServiceNow helps IT people transform IT departments: 1. A cloud service to automate IT design, transi

[Firebird-net-provider] [FB-Tracker] Created: (DNET-507) Remove T4 SSDL to FB template and rework it to pure C# code

2013-06-04 Thread Jiri Cincura (JIRA)
Components: ADO.NET Provider Affects Versions: 3.0.2.0 Reporter: Jiri Cincura Assignee: Jiri Cincura -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure

[Firebird-net-provider] [FB-Tracker] Created: (DNET-506) Support for EF's Migrations

2013-05-31 Thread Jiri Cincura (JIRA)
pport Reporter: Jiri Cincura Assignee: Jiri Cincura Priority: Minor -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on

[Firebird-net-provider] [FB-Tracker] Reopened: (DNET-499) Backup problem in Windows 7

2013-05-31 Thread Jiri Cincura (JIRA)
[ http://tracker.firebirdsql.org/browse/DNET-499?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiri Cincura reopened DNET-499: --- > Backup problem in Windows 7 > --- > > K

[Firebird-net-provider] [FB-Tracker] Created: (DNET-504) Implement IDbConnectionFactory

2013-05-31 Thread Jiri Cincura (JIRA)
: Jiri Cincura Assignee: Jiri Cincura -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com

[Firebird-net-provider] [FB-Tracker] Created: (DNET-505) Async support

2013-05-31 Thread Jiri Cincura (JIRA)
Async support - Key: DNET-505 URL: http://tracker.firebirdsql.org/browse/DNET-505 Project: .NET Data provider Issue Type: Sub-task Components: ADO.NET Provider Reporter: Jiri Cincura Assignee

[Firebird-net-provider] [FB-Tracker] Created: (DNET-503) Support for EF6

2013-05-31 Thread Jiri Cincura (JIRA)
Cincura Assignee: Jiri Cincura -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software

[Firebird-net-provider] Deprecating T4 template for EF's Model First

2013-05-31 Thread Jiri Cincura
Hi *, I'm thinking about deprecating T4 template that is available for Model First when you want to generate the model. It's a PIA to maintain it. It needs to be completely independent from other code (because you need only it when running it inside VS). The T4 is a good for templating. But thanks

Re: [Firebird-net-provider] Unable to find the requested .Net Framework Data Provider

2013-05-20 Thread Jiri Cincura
The provider factory is not registered in app.config (or machine.config). -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com -- Try New Relic Now & We'll Send You this Cool

Re: [Firebird-net-provider] LINQ Outer Error

2013-05-08 Thread Jiri Cincura
On Thu, May 9, 2013 at 5:34 AM, Muthu Annamalai wrote: > Firebird is throwing this exception > > > > SQL error code = -104 > > Token unknown - line 35, column 4 > > OUTER ---> Dynamic SQL Error > > SQL error code = -104 > > Token unknown - line 35, column 4 > > OUTER > >at > FirebirdSql.Dat

Re: [Firebird-net-provider] NET Provider that requires only .NET 2.0 and not 3.5?

2013-05-04 Thread Jiri Cincura
On Fri, May 3, 2013 at 4:17 PM, Yiannis Bourkelis wrote: > v2.7.7 is the most recent version that requires only NET Framework 2.0? > (file: NETProvider-2.7.7-NET20.7z) Yes. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com

Re: [Firebird-net-provider] NET Provider that requires only .NET 2.0 and not 3.5?

2013-05-03 Thread Jiri Cincura
On Fri, May 3, 2013 at 8:22 AM, Yiannis Bourkelis wrote: > I see a NETProvider-3.0.2.0-NET35.7z file but does this require NET 3.5 > installed? Yes, it does. The .NET 2.0 only version was deprecated few months ago. Now the oldest supported version is .NET 3.5 SP1. -- Jiri {x2} Cincura (x2develo

Re: [Firebird-net-provider] EF Code First Attempted Update of read-only Column

2013-05-01 Thread Jiri Cincura
You have to mark the property as store generated. It's not Firebird related, you have to do it in EF no matter what DB you use. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com ---

Re: [Firebird-net-provider] Exception on exit application

2013-04-25 Thread Jiri Cincura
What's the call stack? Isn't it same as DNET-476? -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com -- Try New Relic Now & We'll Send You this Cool Shirt New Relic is the o

Re: [Firebird-net-provider] ClearAllPools and opened connections

2013-04-25 Thread Jiri Cincura
On Thu, Apr 25, 2013 at 10:27 AM, Mark Rotteveel wrote: > You could also see it from a different point: some part of your code is > misbehaving (ie not releasing connections back to the pool in a timely Interesting. I would say why your code isn't going to be fixed in first place? And should the

Re: [Firebird-net-provider] ClearAllPools and opened connections

2013-04-25 Thread Jiri Cincura
How I'm thinking. The connections are normally in pool, when you're using some, it's not in pool (actually it's still in the pool's collection, but "marked as used") logically. When you're cleaning all pools you are cleaning connections that are pooled (in pool). Hence connections not in pool shoul

Re: [Firebird-net-provider] Migrations

2013-04-20 Thread Jiri Cincura
On Sat, Apr 20, 2013 at 7:49 PM, Mercea Paul wrote: > I think is necessary to take care about 255 DDL metadata changes allowed > per table. That's impossible. Because sometimes you don't know what database exactly you'll be running against. It's not needed to connect to it. OTOH what the provide

[Firebird-net-provider] Migrations

2013-04-19 Thread Jiri Cincura
Hi *, is there an interest in Migrations provider (for EF) for Firebird? -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com -- Precog is a next-generation analytics platform

Re: [Firebird-net-provider] Using factories in 3.0.2

2013-04-18 Thread Jiri Cincura
It's what it says. Maybe you forgot to modify 64bit version of machine.config (or vice versa) or maybe you're on .NET 4.0 and installed .NET 4.5 version of provider or maybe the factory is removed in app.config or maybe ... -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | ht

Re: [Firebird-net-provider] Using factories in 3.0.2

2013-04-18 Thread Jiri Cincura
> But my app crashes every time I'm trying to execute it. Can you provide us exception and other details? -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com -- Precog is a n

[Firebird-net-provider] ClearAllPools and opened connections

2013-04-17 Thread Jiri Cincura
Hi *, I just found behavior that surprised me. Suppose pooling is on and (all connections to same database): Open connection1. Open connection2. Close connection2. FbConnection.ClearAllPools(); Try to use connection1. On this ^ line you'll get exception as the connection1 was also cleared aka clo

Re: [Firebird-net-provider] Question on FbBatchExecution

2013-04-04 Thread Jiri Cincura
On Fri, Apr 5, 2013 at 7:43 AM, Brian Liedtke wrote: > Is anyone working on this? If not, I may take a stab at it if I can find the > time. I'm not aware of anybody. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com --

Re: [Firebird-net-provider] Question on FbBatchExecution

2013-04-04 Thread Jiri Cincura
On Fri, Apr 5, 2013 at 7:50 AM, Brian Liedtke wrote: > I assume you refer to the JIRA issue tracking software? Yes. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com -- Mi

Re: [Firebird-net-provider] Question on FbBatchExecution

2013-04-04 Thread Jiri Cincura
On Fri, Apr 5, 2013 at 3:07 AM, Brian Liedtke wrote: > Any reason for this? Because it's implemented like this. :) It's probably bug. It should close the connection only if it opened it. Create a tracker item for this. I'll fix it into next release. -- Jiri {x2} Cincura (x2develop.com founder) h

Re: [Firebird-net-provider] Sweep

2013-04-03 Thread Jiri Cincura
On Wed, Apr 3, 2013 at 2:20 AM, Nicolas Timmers wrote: > There is a method on firebord data provider to perform database sweep?? Yes. Services namespace. FbValidationFlags.SweepDatabase flag. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com -

[Firebird-net-provider] [FB-Tracker] Created: (DNET-489) Wrong parameters usage when using restriction on catalogr/schema on non-table schema tables

2013-03-25 Thread Jiri Cincura (JIRA)
Project: .NET Data provider Issue Type: Bug Components: ADO.NET Provider Affects Versions: 3.0.2.0 Reporter: Jiri Cincura Assignee: Jiri Cincura Calling ".GetSchema("Procedures", new[] { null, "dbo",

Re: [Firebird-net-provider] Cannot "Update Model from Database" in Visual Studio 2012 Pro

2013-03-24 Thread Jiri Cincura
On Mon, Mar 11, 2013 at 8:29 PM, Michael Eubanks wrote: > Also, when I attempt to connect to a Firebird database using the "Server > Explorer", Firebird is not listed. Any ideas?? DDEX not installed correctly. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID

Re: [Firebird-net-provider] Code First Error

2013-03-24 Thread Jiri Cincura
On Sun, Mar 24, 2013 at 7:51 PM, Muthu Annamalai wrote: > if you can help me This part looks good. But hard to guess without the whole code. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com ---

Re: [Firebird-net-provider] Code First Error

2013-03-22 Thread Jiri Cincura
On Fri, Mar 22, 2013 at 3:05 AM, Muthu Annamalai wrote: > > System.Data.Entity.Edm.EdmEntityType: EntityType ‘Image’ has no key > defined. Define the key for this EntityType. > > System.Data.Entity.Edm.EdmEntitySet: EntityType EntitySet ‘Images is > based on the type ‘Image’ that has no key defin

Re: [Firebird-net-provider] DDEX 3.0 upgrade problem

2013-03-19 Thread Jiri Cincura
On Tue, Mar 19, 2013 at 12:46 PM, André Knappstein wrote: > A common question and usually always the same answer. > > You probably have this: > http://sourceforge.net/projects/firebird/files/firebird-net-provider/3.0.2/NETProvider-3.0.2.0.msi/download > > But what you need is this: > http://source

Re: [Firebird-net-provider] DDEX 3.0 upgrade problem

2013-03-18 Thread Jiri Cincura
You're using version for .NET 4.5 very likely, but you're developing for previous version. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com -- Everyone hates slow website

Re: [Firebird-net-provider] VS2012 Express and DDEX

2013-03-11 Thread Jiri Cincura
On Mon, Mar 11, 2013 at 4:12 PM, eMeL wrote: > I have known in VS2010 the Express version can't use DDEX Provider. > > Is it same in VS2012 Express? > > eMeL > As you asked already on my blog, I answered first there: http://blog.cincura.net/233086-ado-net-provider-for-firebird-3-0-2-released/#com

Re: [Firebird-net-provider] Strange behaviour when running FbBatchExecution on script file

2013-03-04 Thread Jiri Cincura
On Mon, Mar 4, 2013 at 9:43 AM, Glenn Thomas Hvidsten wrote: > I hope you’ll be able to help me with this. Hardly without any information. Firebird version? Provider version? Script itself? ... -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com --

Re: [Firebird-net-provider] Exception using Firebird .NET provider and SimpleMembershipProvider in MVC4

2013-02-27 Thread Jiri Cincura
I think you're better writing your own membership, simply username/password, maybe roles. It will give you more flexibility and benefits. Membership providers are not that much fun in 2013. :) But if you want to use it anyway, you have to create the database yourself using the scripts provided. Als

Re: [Firebird-net-provider] Cannot get DDEX provider to work on Visual Studio 2010

2013-02-21 Thread Jiri Cincura
Probably the easiest is to fill all manually. There are some cases, where the default MS SQL presumption (i.e. statement validation) kicks in. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com ---

Re: [Firebird-net-provider] Deploy: Unable to find the requested .Net Framework Data Provider

2013-02-20 Thread Jiri Cincura
On Tue, Feb 19, 2013 at 7:39 PM, mateuslisot wrote: > I tried to access the link that solved your problem, but it is not working. Blog should be back online now. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com -

Re: [Firebird-net-provider] Creating an Entity Data Model is very slow with many Tables

2013-02-13 Thread Jiri Cincura
On Wed, Feb 13, 2013 at 4:19 PM, Reinhard Gunacker wrote: > The point is, that I selected only one single Table but it is slow anyhow! Yes, the query is same. Only amount of data transfered is not that huge. If you're on a fast line that will not make a difference. -- Jiri {x2} Cincura (x2devel

Re: [Firebird-net-provider] Creating an Entity Data Model is very slow with many Tables

2013-02-13 Thread Jiri Cincura
On Wed, Feb 13, 2013 at 11:31 AM, Reinhard Gunacker wrote: > Any Ideas how to speed up the creation of the Model? With 650 tables it will be always slow. It's a huge query being generated and Firebird doesn't like that. Basically only option is to select only tables you're interested in. -- Jir

Re: [Firebird-net-provider] [FB-Tracker] Created: (DNET-483) New behavior for implicit transactions

2013-01-24 Thread Jiri Cincura
On Thu, Jan 24, 2013 at 5:34 PM, André Knappstein wrote: > Yes-Sir! As soon as I find out where and how this works :-) Hack the tracker.firebirdsql.org. :) -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com ---

Re: [Firebird-net-provider] [FB-Tracker] Created: (DNET-483) New behavior for implicit transactions

2013-01-23 Thread Jiri Cincura
On Wed, Jan 23, 2013 at 2:18 PM, André Knappstein wrote: > If my opinion also counts: Maybe better to comment in tracker, because this email is from tracker. :) -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com --

Re: [Firebird-net-provider] Using FBConnect to retrieve TWO output parameters from stored procedure

2013-01-11 Thread Jiri Cincura
On Fri, Jan 11, 2013 at 4:24 PM, Joseph Martinez wrote: > How would I call the above SP and retrieve both the values of NEW_QTY and > AVG_COST? Define output parameters, as with any other ADO.NET. Nothing specific here for Firebird. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincu

[Firebird-net-provider] [FB-Tracker] Created: (DNET-481) Installer should modify also x64 machine config

2013-01-11 Thread Jiri Cincura (JIRA)
: ADO.NET Provider Affects Versions: 3.0.2.0, 3.0.1.0, 3.0.0.0 Reporter: Jiri Cincura Assignee: Jiri Cincura Priority: Minor -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http

Re: [Firebird-net-provider] Trouble retrieving stored procedure result with ExecuteStoreQuery

2013-01-10 Thread Jiri Cincura
On Fri, Jan 11, 2013 at 8:00 AM, Joseph Martinez wrote: > Is there any way possible in .NET to call a stored procedure and retrieve > the output parameter? Sure. Just use FbCommand. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com --

Re: [Firebird-net-provider] Entity Framework not importing stored procedures

2013-01-10 Thread Jiri Cincura
On Wed, Jan 9, 2013 at 7:27 PM, Joseph Martinez wrote: > Do you see anything about it that may cause it to not get imported? The procedure is not selectable. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com --

Re: [Firebird-net-provider] Trouble retrieving stored procedure result with ExecuteStoreQuery

2013-01-10 Thread Jiri Cincura
On Thu, Jan 10, 2013 at 6:24 PM, Joseph Martinez wrote: > Ok, so you're saying that without changing the SP, there's no way to > retrieve the result via ExecuteStoreQuery? If that's the case, do you know > of any other method to run the query and retrieve the scalar result from > .NET? This is

Re: [Firebird-net-provider] Entity Framework not importing stored procedures

2013-01-10 Thread Jiri Cincura
On Wed, Jan 9, 2013 at 6:03 PM, Joseph Martinez wrote: > What output log would I look at, and how? Output from FirebirdClient, it uses TraceSource, so you can see it in attached listeners. If you attach VS, the default listener is going to write to Output Window. -- Jiri {x2} Cincura (x2develop

Re: [Firebird-net-provider] Trouble retrieving stored procedure result with ExecuteStoreQuery

2013-01-10 Thread Jiri Cincura
The procedure needs to be selectable. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com -- Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS, MVC, Window

Re: [Firebird-net-provider] Entity Framework not importing stored procedures

2013-01-09 Thread Jiri Cincura
Without any further clue, it's hard to guess. Is the database queried for SPs? Do you see the query (TraceAPI, Output log, ...)? -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com -

Re: [Firebird-net-provider] Entity Framework not importing stored procedures

2013-01-08 Thread Jiri Cincura
On Tue, Jan 8, 2013 at 6:55 PM, Joseph Martinez wrote: > Ok, I found the SSDL file, and there are no references to the stored > procedures in it. Then SPs were not imported. Probably there's a message in error/output window. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/

Re: [Firebird-net-provider] Entity Framework not importing stored procedures

2013-01-08 Thread Jiri Cincura
SSDL part of EDM. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com -- Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS and more. Get SQL Server skill

<    1   2   3   4   5   6   7   8   9   10   >