[Firebird-net-provider] Using factories in 3.0.2
Hello all, I'm trying to update an application that uses Factories from version 2.1 to 3.0.2 of the provider. I've registered the dll in the gac by using gacutil.exe from VS2010 command line. This is the output of /l option: FirebirdSql.Data.FirebirdClient, Version=3.0.2.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c, processorArchitecture=MSIL I've added the next lines to machine.config from v2 and v4 of the config directory: 2: 4: But my app crashes every time I'm trying to execute it. Could you please help me to fix this issue?? What is wrong? Thanks in advance. Regards, -- Precog is a next-generation analytics platform capable of advanced analytics on semi-structured data. The platform includes APIs for building apps and a phenomenal toolset for data science. Developers can use our toolset for easy data analysis & visualization. Get a free account! http://www2.precog.com/precogplatform/slashdotnewsletter ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] [FB-Tracker] Created: (DNET-497) .Net provider Generates "Outer aplly statement"
.Net provider Generates "Outer aplly statement"
---
Key: DNET-497
URL: http://tracker.firebirdsql.org/browse/DNET-497
Project: .NET Data provider
Issue Type: Bug
Components: Entity Framework support
Affects Versions: 3.0.2.0
Environment: Win 7x64,
Reporter: Wojciech Kmiecik
Assignee: Jiri Cincura
hi.
We are using Database First Approach, after linq query
AIds = (from x in context.RISK_T_ASSESS_HIST
where (x.ID_RISKOBJECT.HasValue && x.F_CREATEDON >=
Freq.StartDate && x.F_CREATEDON <= Freq.EndDate)
group x by x.ID_RISKOBJECT into gr
let lastCreated = gr.Max(p => p.F_CREATEDON)
select new
{
ObjId = gr.Key
,
LastStatus = gr.Where(p => p.F_CREATEDON ==
lastCreated && p.ID_RISKOBJECT == gr.Key).Select(p =>
p.F_STATUS).FirstOrDefault()
}).Where(x => x.LastStatus == 0 || x.LastStatus ==
1).Select(x => x.ObjId.Value).ToArray();
FB receives query with Outer Apply
Query generowane przez EF
SELECT
"Project1"."ID_RISKOBJECT" AS "ID_RISKOBJECT"
FROM (SELECT
"GroupBy1"."A1" AS "C1",
"GroupBy1"."K1" AS "ID_RISKOBJECT"
FROM ( SELECT
"Extent1"."ID_RISKOBJECT" AS "K1",
MAX("Extent1"."F_CREATEDON") AS "A1"
FROM "RISK_T_ASSESS_HIST" AS "Extent1"
WHERE (("Extent1"."ID_RISKOBJECT" IS NOT NULL)
AND ("Extent1"."F_CREATEDON" >= 2013-04-17))
AND ("Extent1"."F_CREATEDON" <= 2013-04-17)
GROUP BY "Extent1"."ID_RISKOBJECT"
) AS "GroupBy1" ) AS "Project1"
OUTER APPLY (SELECT FIRST (1)
"Extent2"."F_STATUS" AS "F_STATUS"
FROM "RISK_T_ASSESS_HIST" AS "Extent2"
WHERE "Extent2"."ID_RISKOBJECT" IS NOT NULL)
AND ("Extent2"."F_CREATEDON" >= 2013-04-17))
AND ("Extent2"."F_CREATEDON" <= @2013-04-17))
AND (("Project1"."ID_RISKOBJECT" = "Extent2"."ID_RISKOBJECT") OR
(("Project1"."ID_RISKOBJECT" IS NULL)
AND ("Extent2"."ID_RISKOBJECT" IS NULL AND (("Extent2"."F_CREATEDON" =
"Project1"."C1")
AND ("Extent2"."ID_RISKOBJECT" = "Project1"."ID_RISKOBJECT")) ) AS "Limit1"
WHERE (0 = "Limit1"."F_STATUS") OR (1 = "Limit1"."F_STATUS")
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
--
Precog is a next-generation analytics platform capable of advanced
analytics on semi-structured data. The platform includes APIs for building
apps and a phenomenal toolset for data science. Developers can use
our toolset for easy data analysis & visualization. Get a free account!
http://www2.precog.com/precogplatform/slashdotnewsletter
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] [FB-Tracker] Created: (DNET-496) Why NETProvider-1.7.2 does not work with Firebird Embedded 2.5?
Why NETProvider-1.7.2 does not work with Firebird Embedded 2.5? Key: DNET-496 URL: http://tracker.firebirdsql.org/browse/DNET-496 Project: .NET Data provider Issue Type: Bug Components: ADO.NET Provider Affects Versions: 1.7.2 Environment: Why NETProvider-1.7.2 does not work with Firebird Embedded 2.5? Reporter: Sergey Prochoghev Assignee: Jiri Cincura Why NETProvider-1.7.2 does not work with Firebird Embedded 2.5? -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira -- Precog is a next-generation analytics platform capable of advanced analytics on semi-structured data. The platform includes APIs for building apps and a phenomenal toolset for data science. Developers can use our toolset for easy data analysis & visualization. Get a free account! http://www2.precog.com/precogplatform/slashdotnewsletter ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] ClearAllPools and opened connections
> On this ^ line you'll get exception as the connection1 was also
> cleared aka closed/disposed. I always used ClearAllPools with all
> connections closed so I had no idea it behaves like that.
Interesting, I also never noticed.
> But do you think is correct? Should the ClearAllPools clear even the
> opened connections?
No, it definitely should not.
It would destroy a great part of the logic at least in *my* code :-)
Forthose connections which are not opened implicitely but
explicitely, I usually check once if their status is OK and then do a
series of commands.
With what you found out it would be possible that some asynchronous
thread would clear the pools in between, right?
Like cutting the branch you sit on in a big tree... no, really, I'd
prefer if this would not be possible :-)
> --
> Jiri {x2} Cincura (x2develop.com founder)
> http://blog.cincura.net/ | http://www.ID3renamer.com
> --
> Precog is a next-generation analytics platform capable of advanced
> analytics on semi-structured data. The platform includes APIs for building
> apps and a phenomenal toolset for data science. Developers can use
> our toolset for easy data analysis & visualization. Get a free account!
> http://www2.precog.com/precogplatform/slashdotnewsletter
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
mit freundlichen Grüßen,
André Knappstein
EDV und Controlling
~~
beta Eigenheim- und Grundstücksverwertungsgesellschaft mbH
Hafenweg 4
59192 Bergkamen-Rünthe
Telefon: +49 2389 9240 140
Telefax: +49 2389 9240 150
e-mail: knappst...@beta-eigenheim.de
Amtsgericht Hamm Nr. B 420
Geschäftsführer: Achim Krähling, Dirk Salewski und Matthias Steinhaus
USt-IDNr.: DE 125215402
--
Precog is a next-generation analytics platform capable of advanced
analytics on semi-structured data. The platform includes APIs for building
apps and a phenomenal toolset for data science. Developers can use
our toolset for easy data analysis & visualization. Get a free account!
http://www2.precog.com/precogplatform/slashdotnewsletter
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] ClearAllPools and opened connections
On Wed, 17 Apr 2013 10:29:57 +0200, Jiri Cincura wrote: > 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 closed/disposed. I always used ClearAllPools with all > connections closed so I had no idea it behaves like that. > > But do you think is correct? Should the ClearAllPools clear even the > opened connections? This behavior matches with my expectations for a method called ClearAllPools(). Maybe you should keep the existing behavior and add a method 'ClearAllPools(bool closeOpenConnections)' which allows explicit control over this behavior. Mark -- Precog is a next-generation analytics platform capable of advanced analytics on semi-structured data. The platform includes APIs for building apps and a phenomenal toolset for data science. Developers can use our toolset for easy data analysis & visualization. Get a free account! http://www2.precog.com/precogplatform/slashdotnewsletter ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] ClearAllPools and opened connections
ClearAllPools should not close/dispose open connections.
A function to close all pooled connections might be useful however for when
you need to close all connections maybe with different name like
CloseAllPooledConnections
On Wed, Apr 17, 2013 at 10:29 AM, Jiri Cincura wrote:
> 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 closed/disposed. I always used ClearAllPools with all
> connections closed so I had no idea it behaves like that.
>
> But do you think is correct? Should the ClearAllPools clear even the
> opened connections?
>
> --
> Jiri {x2} Cincura (x2develop.com founder)
> http://blog.cincura.net/ | http://www.ID3renamer.com
>
>
> --
> Precog is a next-generation analytics platform capable of advanced
> analytics on semi-structured data. The platform includes APIs for building
> apps and a phenomenal toolset for data science. Developers can use
> our toolset for easy data analysis & visualization. Get a free account!
> http://www2.precog.com/precogplatform/slashdotnewsletter
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
--
Gerdus van Zyl
http://about.me/gerdus
--
Precog is a next-generation analytics platform capable of advanced
analytics on semi-structured data. The platform includes APIs for building
apps and a phenomenal toolset for data science. Developers can use
our toolset for easy data analysis & visualization. Get a free account!
http://www2.precog.com/precogplatform/slashdotnewsletter___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] ClearAllPools and opened connections
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 closed/disposed. I always used ClearAllPools with all
connections closed so I had no idea it behaves like that.
But do you think is correct? Should the ClearAllPools clear even the
opened connections?
--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com
--
Precog is a next-generation analytics platform capable of advanced
analytics on semi-structured data. The platform includes APIs for building
apps and a phenomenal toolset for data science. Developers can use
our toolset for easy data analysis & visualization. Get a free account!
http://www2.precog.com/precogplatform/slashdotnewsletter
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
