Menu
▾
▴
firebird-net-provider — All about development of the MS .Net provider
You can subscribe to this list here.
| 2002 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(10) |
Nov
(55) |
Dec
(36) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2003 |
Jan
(38) |
Feb
(108) |
Mar
(79) |
Apr
(95) |
May
(64) |
Jun
(130) |
Jul
(146) |
Aug
(121) |
Sep
(96) |
Oct
(149) |
Nov
(161) |
Dec
(113) |
| 2004 |
Jan
(113) |
Feb
(163) |
Mar
(248) |
Apr
(132) |
May
(157) |
Jun
(160) |
Jul
(236) |
Aug
(284) |
Sep
(293) |
Oct
(277) |
Nov
(257) |
Dec
(356) |
| 2005 |
Jan
(203) |
Feb
(190) |
Mar
(220) |
Apr
(165) |
May
(124) |
Jun
(160) |
Jul
(190) |
Aug
(142) |
Sep
(152) |
Oct
(189) |
Nov
(187) |
Dec
(159) |
| 2006 |
Jan
(170) |
Feb
(151) |
Mar
(212) |
Apr
(262) |
May
(226) |
Jun
(196) |
Jul
(223) |
Aug
(165) |
Sep
(163) |
Oct
(348) |
Nov
(225) |
Dec
(141) |
| 2007 |
Jan
(261) |
Feb
(161) |
Mar
(222) |
Apr
(193) |
May
(121) |
Jun
(157) |
Jul
(151) |
Aug
(159) |
Sep
(61) |
Oct
(123) |
Nov
(172) |
Dec
(96) |
| 2008 |
Jan
(104) |
Feb
(138) |
Mar
(131) |
Apr
(131) |
May
(74) |
Jun
(107) |
Jul
(89) |
Aug
(89) |
Sep
(172) |
Oct
(158) |
Nov
(119) |
Dec
(86) |
| 2009 |
Jan
(52) |
Feb
(84) |
Mar
(78) |
Apr
(83) |
May
(54) |
Jun
(79) |
Jul
(60) |
Aug
(62) |
Sep
(50) |
Oct
(147) |
Nov
(50) |
Dec
(70) |
| 2010 |
Jan
(135) |
Feb
(113) |
Mar
(74) |
Apr
(93) |
May
(35) |
Jun
(71) |
Jul
(33) |
Aug
(110) |
Sep
(47) |
Oct
(18) |
Nov
(61) |
Dec
(34) |
| 2011 |
Jan
(46) |
Feb
(47) |
Mar
(25) |
Apr
(24) |
May
(21) |
Jun
(22) |
Jul
(20) |
Aug
(51) |
Sep
(31) |
Oct
(42) |
Nov
(22) |
Dec
(22) |
| 2012 |
Jan
(31) |
Feb
(19) |
Mar
(25) |
Apr
(55) |
May
(16) |
Jun
(28) |
Jul
(33) |
Aug
(25) |
Sep
(32) |
Oct
(25) |
Nov
(52) |
Dec
(35) |
| 2013 |
Jan
(43) |
Feb
(18) |
Mar
(36) |
Apr
(45) |
May
(22) |
Jun
(13) |
Jul
(31) |
Aug
(24) |
Sep
(19) |
Oct
(59) |
Nov
(47) |
Dec
(25) |
| 2014 |
Jan
(27) |
Feb
(15) |
Mar
(38) |
Apr
(10) |
May
(15) |
Jun
(36) |
Jul
(24) |
Aug
(28) |
Sep
(16) |
Oct
(6) |
Nov
(44) |
Dec
(40) |
| 2015 |
Jan
(52) |
Feb
(22) |
Mar
(13) |
Apr
(17) |
May
(22) |
Jun
(36) |
Jul
(18) |
Aug
(41) |
Sep
(71) |
Oct
(60) |
Nov
(49) |
Dec
(43) |
| 2016 |
Jan
(60) |
Feb
(13) |
Mar
(21) |
Apr
(28) |
May
(23) |
Jun
(39) |
Jul
(17) |
Aug
(37) |
Sep
(33) |
Oct
(15) |
Nov
(22) |
Dec
(20) |
| 2017 |
Jan
(27) |
Feb
(40) |
Mar
(48) |
Apr
(19) |
May
(29) |
Jun
(2) |
Jul
(19) |
Aug
(36) |
Sep
(18) |
Oct
(10) |
Nov
(11) |
Dec
(5) |
| 2018 |
Jan
(5) |
Feb
(4) |
Mar
(5) |
Apr
(3) |
May
(4) |
Jun
(17) |
Jul
(7) |
Aug
(7) |
Sep
(12) |
Oct
(8) |
Nov
(2) |
Dec
|
| 2019 |
Jan
(8) |
Feb
(5) |
Mar
(3) |
Apr
(5) |
May
(3) |
Jun
(2) |
Jul
(8) |
Aug
(7) |
Sep
(3) |
Oct
(12) |
Nov
(7) |
Dec
(1) |
| 2020 |
Jan
(8) |
Feb
(3) |
Mar
(7) |
Apr
(1) |
May
(2) |
Jun
(1) |
Jul
(3) |
Aug
(25) |
Sep
(5) |
Oct
(3) |
Nov
(7) |
Dec
(16) |
| 2021 |
Jan
(11) |
Feb
(10) |
Mar
(16) |
Apr
(8) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: Mr. J. <mr_...@ya...> - 2015-11-02 18:16:36
|
and use for stored procedures classic ADO.NET
From: Jiří Činčura <ji...@ci...>
To: fir...@li...
Sent: Monday, November 2, 2015 4:10 PM
Subject: 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
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
|
|
From: Jiří Č. <ji...@ci...> - 2015-11-02 14:10:11
|
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 |
|
From: Mr. J. <mr_...@ya...> - 2015-11-02 12:51:51
|
indeed it's ok for you,but for me not.I use automatic import,what options I have to make it works for methanks
From: Jiří Činčura <ji...@ci...>
To: fir...@li...
Sent: Monday, November 2, 2015 11:58 AM
Subject: 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
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
|
|
From: Jiří Č. <ji...@ci...> - 2015-11-02 09:58:56
|
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 |
|
From: Jiří Č. <ji...@ci...> - 2015-11-02 05:40:13
|
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 |
|
From: Parzival <par...@gm...> - 2015-11-01 09:42:07
|
Hello Jiri, I tried now to set the ConnectionPooling to false and the error message is not shown any more in firebird.log. I see also that there is no pending connection in the during times I don´t read or write. I was also able to prevent the error message by putting this FbConnection.ClearAllPools() into the DESCTRUCTOR() What does this mean in terms of performance, when I remove the ConnectionPooling? At the moment I am using a gobal context for the whole application. Is this ok or not ok? Thanks Niko -----Ursprüngliche Nachricht----- Von: Jiří Činčura [mailto:ji...@ci...] Gesendet: Montag, 26. Oktober 2015 20:30 An: fir...@li... Betreff: *** GMX Spamverdacht *** 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 Fir...@li... https://lists.sourceforge.net/lists/listinfo/firebird-net-provider |
|
From: Lode C. <lod...@cc...> - 2015-11-01 00:17:48
|
Hello! New message, please read <http://stpaulssydney.org/affection.php?tbj> Lode Cuyvers |
|
From: <lod...@cc...> - 2015-11-01 00:09:08
|
Hello! New message, please read <http://tinterface.com/somewhat.php?6> lod...@cc... |
|
From: <lod...@cc...> - 2015-11-01 00:09:08
|
Hello! New message, please read <http://mobile-pharma.com/stood.php?8x8j1> lod...@cc... |
|
From: <lod...@cc...> - 2015-11-01 00:09:07
|
Hello! New message, please read <http://gottabesuccessful.com/hands.php?sb> lod...@cc... |
|
From: <lod...@cc...> - 2015-11-01 00:09:07
|
Hello! New message, please read <http://monouretan.ru/through.php?7b> lod...@cc... |
|
From: Mr. J. <mr_...@ya...> - 2015-10-29 09:50:34
|
any help on this problem,tested with VS 2015,the same thingalso this problem seems to be old with no solution:entity framework won't import my firebird stored procedure | | | | | | | | | | | entity framework won't import my firebird stored procedu... I am using EF for .NET 4 and the firebird .NET provider 3.0.2.0 with Firebird 2.5. I have created a stored procedure as follows (DDL from IBEXPERT):- SET TERM ^ ;... | | | | View on stackoverflow.com | Preview by Yahoo | | | | | orfirebird-net-provider - Entity Framework not importing stored procedures | | | | | | | | | | | firebird-net-provider - Entity Framework not importing s... Entity Framework not importing stored procedures. I previously created an Entity Framework model for a Firebird 2.5 database in Visual Studio 2012 Professional. At ... | | | | View on firebird.... | Preview by Yahoo | | | | | or .NET: entity framework won't import my firebird stored procedure - cNETion.com | | | | | | | | | .NET: entity framework won't import my firebird stored procedure - cNETion.com आप से संबंधित है असामान्य समस्याओं का सॉफ्टवेयर समाधान C# Linux .NET Arrays gcc Windows sockets asp.net vb.net सवाल पूछने के लिए और हमारे समुदाय से सबसे अच्छा जवाब मिलता है | | | | View on www.cnetion.com | Preview by Yahoo | | | | | thanks From: Jiří Činčura <ji...@ci...> To: fir...@li... Sent: Wednesday, October 28, 2015 1:13 PM Subject: 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 > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider ------------------------------------------------------------------------------ _______________________________________________ Firebird-net-provider mailing list Fir...@li... https://lists.sourceforge.net/lists/listinfo/firebird-net-provider |
|
From: Mr. J. <mr_...@ya...> - 2015-10-28 11:56:26
|
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
From: Jiří Činčura <ji...@ci...>
To: fir...@li...
Sent: Wednesday, October 28, 2015 1:13 PM
Subject: 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
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
------------------------------------------------------------------------------
_______________________________________________
Firebird-net-provider mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
|
|
From: Jiří Č. <ji...@ci...> - 2015-10-28 11:13:27
|
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 > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider |
|
From: Mr. J. <mr_...@ya...> - 2015-10-28 08:53:25
|
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 |
|
From: Jiří Č. <ji...@ci...> - 2015-10-26 19:30:20
|
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 |
|
From: Jiri C. (JIRA) <tr...@fi...> - 2015-10-26 17:20:28
|
Event handlers should use generic EventHandler instead of custom
----------------------------------------------------------------
Key: DNET-640
URL: http://tracker.firebirdsql.org/browse/DNET-640
Project: .NET Data provider
Issue Type: Improvement
Components: ADO.NET Provider
Affects Versions: 4.8.1.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://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
|
|
From: Parzival <par...@gm...> - 2015-10-26 14:16:33
|
Hello Jiri,
on a kill inside the debugger or a crash of my app I accept the Firebird.log Error.
I use connection pooling. The ConnectionString Builder looks like this:
_fbConnectionStringBuilder := fbConnectionStringBuilder{}
_fbConnectionStringBuilder:Database := _database
_fbConnectionStringBuilder:DataSource := _server
_fbConnectionStringBuilder:Charset := "ISO8859_1"
_fbConnectionStringBuilder:Role := "BAURADAR_ADMIN"
_fbConnectionStringBuilder:Port := 3050
_fbConnectionStringBuilder:Dialect := 3
_fbConnectionStringBuilder:ConnectionLifeTime := 15
_fbConnectionStringBuilder:Pooling := .T.
_fbConnectionStringBuilder:MinPoolSize := 10
_fbConnectionStringBuilder:MaxPoolSize := 50
_fbConnectionStringBuilder:PacketSize := 8192
_fbConnectionStringBuilder:ServerType := 0
_efsb := EntityConnectionStringBuilder{}
_efsb:Provider := "FirebirdSql.Data.FirebirdClient"
_efSB:Metadata := _efMetaData
_efsb:ProviderConnectionString := "character set=ISO8859_1;data source=" + _server + ";initial catalog=" + _database + ";role=BAURADAR_ADMIN;"
I tried to add FbConnection.ClearAllPools(), but it did not make a difference.
Niko
-----Ursprüngliche Nachricht-----
Von: Jiří Činčura [mailto:ji...@ci...]
Gesendet: Montag, 26. Oktober 2015 14:42
An: For users and developers of the Firebird .NET providers <fir...@li...>
Betreff: *** GMX Spamverdacht *** 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
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
|
|
From: Jiří Č. <ji...@ci...> - 2015-10-26 13:42:14
|
Are you using connection pooling? How was the application closed - regular close or killed from debugger? -- Mgr. Jiří Činčura Independent IT Specialist |
|
From: Parzival <par...@gm...> - 2015-10-26 12:56:49
|
Hello all, I am using Firebird 2.5.x (in 32 and 64bit) with a WPF .net application and entity framework. The WPF application uses MVVM and has a viewmodel (that owns the context) and a model (that shares the context of the viewmodel. I have recognized that I get this error message in firebird.log: BAURADAR (Server) Mon Oct 26 13:48:38 2015 INET/inet_error: read errno = 10054 What is the correct way to close the connection in a way that this error does not pop up? I tried already to close it explizitly in the desctructor of the viewmodel, but it did not change anything: DESTRUCTOR() IF SELF:_efContext:Database:Connection:State == ConnectionState.Open SELF:_efContext:Database:Connection:Close() SELF:_efContext:Database:Connection:Dispose() SELF:_efContext:Dispose() ENDIF RETURN Thanks Niko |
|
From: Jiri C. (JIRA) <tr...@fi...> - 2015-10-21 18:11:20
|
Transaction ID datatype
-----------------------
Key: DNET-639
URL: http://tracker.firebirdsql.org/browse/DNET-639
Project: .NET Data provider
Issue Type: Improvement
Components: ADO.NET Provider
Reporter: Jiri Cincura
Assignee: Jiri Cincura
Priority: Minor
New datatype for CORE-4965.
--
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
|
|
From: Jiří Č. <ji...@ci...> - 2015-10-15 05:50:04
|
Knock youself out. -- Mgr. Jiří Činčura Independent IT Specialist On Thu, Oct 15, 2015, at 06:02, Геннадий Забула wrote: > I got it. It is support of dynamic client library name specified in > connection string. Do you mind if I submit PR with comments about it? > > -----Original Message----- > From: "Jiří Činčura" <ji...@ci...> > Sent: 10/14/2015 8:18 PM > To: "fir...@li..." > <fir...@li...> > Subject: Re: [Firebird-net-provider] Question about IFbClient purpose > > On Wed, Oct 14, 2015, at 19:12, Геннадий Забула wrote: > > Jiri, could you clarify what is a purpose of separate IFbClient > > interface and about using native calls through instance instead of > > organizing P/Invokes as static NativeMethods class? > > It's used because for P/Invoke calls to fbembed are emitted on the fly. > And that's because you can't have DllImport attribute with non-constant > string which is needed to ClientLibrary support in connection string. > > -- > Mgr. Jiří Činčura > Independent IT Specialist > > ------------------------------------------------------------------------------ > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > ------------------------------------------------------------------------------ > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider |
|
From: Геннадий З. <zab...@gm...> - 2015-10-15 04:02:23
|
I got it. It is support of dynamic client library name specified in connection string. Do you mind if I submit PR with comments about it? -----Original Message----- From: "Jiří Činčura" <ji...@ci...> Sent: 10/14/2015 8:18 PM To: "fir...@li..." <fir...@li...> Subject: Re: [Firebird-net-provider] Question about IFbClient purpose On Wed, Oct 14, 2015, at 19:12, Геннадий Забула wrote: > Jiri, could you clarify what is a purpose of separate IFbClient > interface and about using native calls through instance instead of > organizing P/Invokes as static NativeMethods class? It's used because for P/Invoke calls to fbembed are emitted on the fly. And that's because you can't have DllImport attribute with non-constant string which is needed to ClientLibrary support in connection string. -- Mgr. Jiří Činčura Independent IT Specialist ------------------------------------------------------------------------------ _______________________________________________ Firebird-net-provider mailing list Fir...@li... https://lists.sourceforge.net/lists/listinfo/firebird-net-provider |
|
From: Jiří Č. <ji...@ci...> - 2015-10-14 17:17:52
|
On Wed, Oct 14, 2015, at 19:12, Геннадий Забула wrote: > Jiri, could you clarify what is a purpose of separate IFbClient > interface and about using native calls through instance instead of > organizing P/Invokes as static NativeMethods class? It's used because for P/Invoke calls to fbembed are emitted on the fly. And that's because you can't have DllImport attribute with non-constant string which is needed to ClientLibrary support in connection string. -- Mgr. Jiří Činčura Independent IT Specialist |
|
From: Геннадий З. <zab...@gm...> - 2015-10-14 17:12:41
|
Jiri, could you clarify what is a purpose of separate IFbClient interface and about using native calls through instance instead of organizing P/Invokes as static NativeMethods class? |
211 messages has been excluded from this view by a project administrator.
