firebird-net-provider — All about development of the MS .Net provider

Re: [Firebird-net-provider] [FB-Tracker] Created: (DNET-571) Firebird DDEX Provider Visual Studio 2013 SP3 - Connection dialog disappears immediately

[Wolfgang L. <lem...@ps...>]

Hi Jens,

http://delphitutorials.de/VerbindungsdialogGehtZu

open Machine.config in 
C:\Windows\Microsoft.NET\Framework\v4.0.30319\config (or your config) 
and search for

<system.data>
     <DbProviderFactories>

there are more than one Entry for the Firebird Client:
<add name="FirebirdClient Data Provider" 
invariant="FirebirdSql.Data.FirebirdClient" description=".NET Framework 
Data Provider for Firebird" 
type="FirebirdSql.Data.FirebirdClient.FirebirdClientFactory, 
FirebirdSql.Data.FirebirdClient, Version=4.5.0.0, Culture=neutral, 
PublicKeyToken=3750abcc3150b00c"/></DbProviderFactories>

delete one of the Entry....

Regards
Wolfgang

Am 15.10.2014 13:02, schrieb Jens Warkentin (JIRA):
> Firebird DDEX Provider Visual Studio 2013 SP3 - Connection dialog disappears immediately
> ----------------------------------------------------------------------------------------
>
>                   Key: DNET-571
>                   URL: http://tracker.firebirdsql.org/browse/DNET-571
>               Project: .NET Data provider
>            Issue Type: Bug
>            Components: DDEX Provider
>      Affects Versions: 4.5.1.0
>           Environment: Windows 8.1 Pro x64, Visual Studio 2013 Professional SP3
>              Reporter: Jens Warkentin
>              Assignee: Jiri Cincura
>              Priority: Blocker
>
>
> see Cross-Post: StackOverflow: http://stackoverflow.com/questions/26377689/firebird-ddex-provider-visual-studio-2013-sp3-connection-dialog-disappears-imm
>
> I've installed the latest Firebird ADO.Net Provider (FirebirdSql.Data.FirebirdClient-4.5.1.0.msi) and the latest Firebird DDEX Provider (DDEXProvider-3.0.1.0.msi).
>
> Both providers are registered in GAC.
> FirebirdSql.VisualStudio.DataTools, Version=3.0.1.0, Culture=neutral, PublicKeyToken=bae6c78ccb0fcdb3, processorArchitecture=MSIL
> FirebirdSql.Data.FirebirdClient, Version=4.5.1.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c, processorArchitecture=MSIL
>
> The Firebird ADO.Net Provider is also registered in the "DbProviderFactories" Node of the machine.config (for both x86 and x64).
>
> <add name="FirebirdClient Data Provider" invariant="FirebirdSql.Data.FirebirdClient" description=".NET Framework Data Provider for Firebird" type="FirebirdSql.Data.FirebirdClient.FirebirdClientFactory, FirebirdSql.Data.FirebirdClient, Version=4.5.1.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c"/>
>
> I'm trying to create a new Database Connection using the DDEX Provider in VS2013 SP3, but it's not working. When I change any values in the "Firebird Data Source" connection dialog, the dialog disappears.
>
> I debugged VS2013 in background with a 2nd VS2013 Instance and got this Output messages, while the connection dialog disappears:
>
> FbDataConnectionUIControl::LoadProperties()
> Eine Ausnahme (erste Chance) des Typs "System.NullReferenceException" ist in FirebirdSql.VisualStudio.DataTools.dll aufgetreten.
>
> System.NullReferenceException: Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt.
>     bei FirebirdSql.VisualStudio.DataTools.FbDataConnectionUIControl.LoadProperties()
> FbDataConnectionUIControl::LoadProperties()
>
> Eine Ausnahme (erste Chance) des Typs "System.NullReferenceException" ist in FirebirdSql.VisualStudio.DataTools.dll aufgetreten.
>
> System.NullReferenceException: Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt.
>     bei FirebirdSql.VisualStudio.DataTools.FbDataConnectionUIControl.LoadProperties()
>
> Eine Ausnahme (erste Chance) des Typs "System.NullReferenceException" ist in FirebirdSql.VisualStudio.DataTools.dll aufgetreten.
>
> Any ideas how I can get the provider to run or where I can look for other prerequisites?
>

[Firebird-net-provider] [FB-Tracker] Created: (DNET-571) Firebird DDEX Provider Visual Studio 2013 SP3 - Connection dialog disappears immediately

[Jens W. (JIRA) <tr...@fi...>]

Firebird DDEX Provider Visual Studio 2013 SP3 - Connection dialog disappears immediately
----------------------------------------------------------------------------------------

                 Key: DNET-571
                 URL: http://tracker.firebirdsql.org/browse/DNET-571
             Project: .NET Data provider
          Issue Type: Bug
          Components: DDEX Provider
    Affects Versions: 4.5.1.0
         Environment: Windows 8.1 Pro x64, Visual Studio 2013 Professional SP3
            Reporter: Jens Warkentin
            Assignee: Jiri Cincura
            Priority: Blocker


see Cross-Post: StackOverflow: http://stackoverflow.com/questions/26377689/firebird-ddex-provider-visual-studio-2013-sp3-connection-dialog-disappears-imm

I've installed the latest Firebird ADO.Net Provider (FirebirdSql.Data.FirebirdClient-4.5.1.0.msi) and the latest Firebird DDEX Provider (DDEXProvider-3.0.1.0.msi).

Both providers are registered in GAC.
FirebirdSql.VisualStudio.DataTools, Version=3.0.1.0, Culture=neutral, PublicKeyToken=bae6c78ccb0fcdb3, processorArchitecture=MSIL
FirebirdSql.Data.FirebirdClient, Version=4.5.1.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c, processorArchitecture=MSIL

The Firebird ADO.Net Provider is also registered in the "DbProviderFactories" Node of the machine.config (for both x86 and x64).

<add name="FirebirdClient Data Provider" invariant="FirebirdSql.Data.FirebirdClient" description=".NET Framework Data Provider for Firebird" type="FirebirdSql.Data.FirebirdClient.FirebirdClientFactory, FirebirdSql.Data.FirebirdClient, Version=4.5.1.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c"/>

I'm trying to create a new Database Connection using the DDEX Provider in VS2013 SP3, but it's not working. When I change any values in the "Firebird Data Source" connection dialog, the dialog disappears.

I debugged VS2013 in background with a 2nd VS2013 Instance and got this Output messages, while the connection dialog disappears:

FbDataConnectionUIControl::LoadProperties()
Eine Ausnahme (erste Chance) des Typs "System.NullReferenceException" ist in FirebirdSql.VisualStudio.DataTools.dll aufgetreten.

System.NullReferenceException: Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt.
   bei FirebirdSql.VisualStudio.DataTools.FbDataConnectionUIControl.LoadProperties()
FbDataConnectionUIControl::LoadProperties()

Eine Ausnahme (erste Chance) des Typs "System.NullReferenceException" ist in FirebirdSql.VisualStudio.DataTools.dll aufgetreten.

System.NullReferenceException: Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt.
   bei FirebirdSql.VisualStudio.DataTools.FbDataConnectionUIControl.LoadProperties()

Eine Ausnahme (erste Chance) des Typs "System.NullReferenceException" ist in FirebirdSql.VisualStudio.DataTools.dll aufgetreten.

Any ideas how I can get the provider to run or where I can look for other prerequisites?

-- 
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

        

[Firebird-net-provider] [FB-Tracker] Created: (DNET-570) Loading error messages from a manifest resource fails on mono

[Michał Z. (J. <tr...@fi...>]

Loading error messages from a manifest resource fails on mono
-------------------------------------------------------------

                 Key: DNET-570
                 URL: http://tracker.firebirdsql.org/browse/DNET-570
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 4.5.1.0
         Environment: mono 3.10 x64
            Reporter: Michał Ziemski
            Assignee: Jiri Cincura


In method: FirebirdSql.Data.Common.IscException.CreateResourceSet(string resourceName)
the resourcestream is disposed before returning the resourceset. This doesn't work on mono (mono initializes the resourceset (reads the resourcestream) on
the first call to GetObject rather than in constructor).

Those resource set should be IMHO static properties initialized in the static constructor of IscException. In the current implementation at each iscexception a call is made to read the resource from disk, and a full resource dictionary is constructed. This is on aoverkill especially for server usages.


-- 
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

       

[Firebird-net-provider] [FB-Tracker] Created: (DNET-569) FbBulkCopy

[Bert H. (JIRA) <tr...@fi...>]

FbBulkCopy
----------

                 Key: DNET-569
                 URL: http://tracker.firebirdsql.org/browse/DNET-569
             Project: .NET Data provider
          Issue Type: New Feature
            Reporter: Bert Herngreen
            Assignee: Jiri Cincura


I would be nice to have support for a SqlBulkCopy-like functionality, using a IDataReader with a WriteToServer method.
Even if simple Insert's would be used underneath.

This would ease datapumping very much.


-- 
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

        

[Firebird-net-provider] [FB-Tracker] Created: (DNET-568) FbConnection.ClearPool (cnn) doesn't work

[Fernando N. (J. <tr...@fi...>]

FbConnection.ClearPool (cnn) doesn't work
-----------------------------------------

                 Key: DNET-568
                 URL: http://tracker.firebirdsql.org/browse/DNET-568
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 4.5.1.0
            Reporter: Fernando Nájera
            Assignee: Jiri Cincura


I think there's an error in the implementation of FbConnection.ClearPool(cnn).

It is currently implemented as FbConnectionPoolManager.Instance.ClearPool(connection.ConnectionString);

I think it should be FbConnectionPoolManager.Instance.ClearPool(connection.NormalizedConnectionString);

FbConnectionPoolManager keeps internally a dictionary based on normalized cnn strings, and if you pass just the cnn string, it won't find the corresponding pool, and the call to ClearPool() will be basically a NOP.

The workaround is to call ClearAllPools() instead, but that does clean more than requested/needed.

-- 
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

       

Re: [Firebird-net-provider] Firebird-net-provider Digest, Vol 101, Issue 2

[<da...@na...>]

Sorry I missed you e-mail but I'm currently on leave. I will return to the office on Monday the 15th of September

For all support inquiries please contact the office on +353 (0)1 5253600 or +44 (0)203 4681247 

Alternatively please email su...@na... .

 Kind Regards,
 David

Re: [Firebird-net-provider] Abbility to use "no garbage collect" connection parameter

[Jiří Č. <di...@ci...>]

Looks fine. Merged. Thanks.

--
Mgr. Jiří Činčura
Independent IT Specialist

Re: [Firebird-net-provider] Abbility to use "no garbage collect" connection parameter

[Lukáš V. <l.v...@gm...>]

Hi,

 

i just issued PR on GitHub. The PR is: https://github.com/cincuranet/NETProvider/pull/17

I hope it'll be ok this time.

 

 

Lukáš Vykydal

 

Od: Lukáš Vykydal [mailto:l.v...@gm...] 
Odesláno: Saturday, September 13, 2014 5:09 PM
Komu: For users and developers of the Firebird .NET providers
Předmět: Re: [Firebird-net-provider] Abbility to use "no garbage collect" connection parameter

 

Hi,

 sorry for late answer, i wasn't on internet for last 5 days.

 

Yes it sholud be. Tomorrow i'll try to do it on Github.

 

 

 

2014-09-10 10:08 GMT+02:00 Jiří Činčura <di...@ci...>:

Hi,

Is that your PR: https://sourceforge.net/p/firebird/NETProvider/merge-requests/1/ ? Because SF tells there's 0 commits. Maybe it's just broken (as usual) SF. Although looks like there's no branch for that.

Anyhow. Feel free to send patch via email, it's not big. Or do it on GitHub, that one works fine.

--
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=157508191 <http://pubads.g.doubleclick.net/gampad/clk?id=157508191&iu=/4140/ostg.clktrk> &iu=/4140/ostg.clktrk

_______________________________________________
Firebird-net-provider mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

 

Re: [Firebird-net-provider] Abbility to use "no garbage collect" connection parameter

[Lukáš V. <l.v...@gm...>]

Hi,
 sorry for late answer, i wasn't on internet for last 5 days.

Yes it sholud be. Tomorrow i'll try to do it on Github.



2014-09-10 10:08 GMT+02:00 Jiří Činčura <di...@ci...>:

> Hi,
>
> Is that your PR:
> https://sourceforge.net/p/firebird/NETProvider/merge-requests/1/ ?
> Because SF tells there's 0 commits. Maybe it's just broken (as usual) SF.
> Although looks like there's no branch for that.
>
> Anyhow. Feel free to send patch via email, it's not big. Or do it on
> GitHub, that one works fine.
>
> --
> 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=157508191&iu=/4140/ostg.clktrk
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

Re: [Firebird-net-provider] Abbility to use "no garbage collect" connection parameter

[Jiří Č. <di...@ci...>]

Hi,

Is that your PR: https://sourceforge.net/p/firebird/NETProvider/merge-requests/1/ ? Because SF tells there's 0 commits. Maybe it's just broken (as usual) SF. Although looks like there's no branch for that.

Anyhow. Feel free to send patch via email, it's not big. Or do it on GitHub, that one works fine.

-- 
Mgr. Jiří Činčura
Independent IT Specialist

[Firebird-net-provider] ADO.NET provider 4.5.1.0 for Firebird is ready

[Jiří Č. <di...@ci...>]

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

[Firebird-net-provider] [FB-Tracker] Created: (DNET-566) Pointer fixes

[Jiri C. (JIRA) <tr...@fi...>]

Pointer fixes
-------------

                 Key: DNET-566
                 URL: http://tracker.firebirdsql.org/browse/DNET-566
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 4.5.0.0
            Reporter: Jiri Cincura
            Assignee: Jiri Cincura


Contributed by PR https://github.com/cincuranet/NETProvider/pull/6#issuecomment-54961159.

-- 
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

        

[Firebird-net-provider] [FB-Tracker] Created: (DNET-567) TimeStamp fixed in embedded

[Jiri C. (JIRA) <tr...@fi...>]

TimeStamp fixed in embedded
---------------------------

                 Key: DNET-567
                 URL: http://tracker.firebirdsql.org/browse/DNET-567
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 4.5.0.0
            Reporter: Jiri Cincura
            Assignee: Jiri Cincura


Contributed by PR https://github.com/cincuranet/NETProvider/pull/6#issuecomment-54961159.

-- 
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

        

[Firebird-net-provider] [FB-Tracker] Created: (DNET-565) Improve getting ProvierManifestToken also for non-existing databases

[Jiri C. (JIRA) <tr...@fi...>]

Improve getting ProvierManifestToken also for non-existing databases
--------------------------------------------------------------------

                 Key: DNET-565
                 URL: http://tracker.firebirdsql.org/browse/DNET-565
             Project: .NET Data provider
          Issue Type: Improvement
          Components: Entity Framework support
    Affects Versions: 4.5.0.0
            Reporter: Jiri Cincura
            Assignee: Jiri Cincura


Improve getting ProvierManifestToken also for non-existing databases. It's needed i.e. for database initialization.

-- 
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

        

Re: [Firebird-net-provider] Compiling for mono

[Jiří Č. <di...@ci...>]

Create a PR.

--
Mgr. Jiří Činčura
Independent IT Specialist

From: Ernesto Cullen [mailto:ern...@gm...]
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 <di...@ci...<mailto:di...@ci...>>:
Hi, probably best idea is to use the build for Mono/Linux from firebirdsql.org<http://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=153845071&iu=/4140/ostg.clktrk
_______________________________________________
Firebird-net-provider mailing list
Fir...@li...<mailto:Fir...@li...>
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider



--
"Either write something worth reading or do something worth writing" B. Franklin

Re: [Firebird-net-provider] Compiling for mono

[Ernesto C. <ern...@gm...>]

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 <di...@ci...>:

>  Hi, probably best idea is to use the build for Mono/Linux from
> 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=153845071&iu=/4140/ostg.clktrk
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
>


-- 
"Either write something worth reading or do something worth writing" B.
Franklin

Re: [Firebird-net-provider] Casting Text BLOB to null

[Scott M. <bl...@bl...>]

On 05/09/14 12:34, Mark Rotteveel wrote:
> A quick workaround is to use:
> 
> string text = reader["LONG_TEXT"] as string;
> 
> This will perform the cast, but return null if the cast failed.

That's perfect, thanks. Knew I was missing something simple.

Scott

Re: [Firebird-net-provider] Casting Text BLOB to null

[Mark R. <ma...@la...>]

On Fri, 05 Sep 2014 12:08:33 +0100, Scott Morgan <bl...@bl...>
wrote:
> Am I missing a trick here? I'm reading from a BLOB SUB_TYPE 1 column
> using the following:
> 
> FbDataReader reader = /* blah */
> string text = (string)reader["LONG_TEXT"];
> 
> It's okay when there is data, but if the column happens to be NULL I get
> an error ("Unable to cast object of type 'System.DBNull' to type
> 'System.String'"), where I'd ideally like to get a plain null.
> 
> FbDataReader.GetString doesn't work for me as it just returns ""
> 
> So I'm left with a messy lump of GetOrdinal, IsDBNull, code. There's got
> to be a better way, but I'm not seeing it.

A quick workaround is to use:

string text = reader["LONG_TEXT"] as string;

This will perform the cast, but return null if the cast failed.

Mark

[Firebird-net-provider] Casting Text BLOB to null

[Scott M. <bl...@bl...>]

Am I missing a trick here? I'm reading from a BLOB SUB_TYPE 1 column
using the following:

FbDataReader reader = /* blah */
string text = (string)reader["LONG_TEXT"];

It's okay when there is data, but if the column happens to be NULL I get
an error ("Unable to cast object of type 'System.DBNull' to type
'System.String'"), where I'd ideally like to get a plain null.

FbDataReader.GetString doesn't work for me as it just returns ""

So I'm left with a messy lump of GetOrdinal, IsDBNull, code. There's got
to be a better way, but I'm not seeing it.

Scott

Re: [Firebird-net-provider] Catching Exception

[LtColRDSChauhan <rds...@gm...>]

On Sun, Aug 17, 2014 at 7:14 AM, LtColRDSChauhan <rds...@gm...> wrote:

> Hi,
>
> 1.  When I run my application, in Release configuration, through
> SharpDevelop IDE, the application catches "Handled Exception" -  "FirebirdSql.Data.Common.IscException:
> OVER_ALLOCATED_BED" thrown by Firebird stored procedure .
>
> 2.  Without debugger, the exception is not caught.  I do have catch blocks
> for : FbException, ApplicationException and Exception.
>
> Apologies.
My code was overwriting the exception message.  Please ignore this help
request.


> 3.  Complication fails on adding catch block for
> FirebirdSql.Data.Common.IscException (appears to be internal).
>
> 4.  Please help.
>
> Thanks and Regards,
> Lt Col (Retd) Rajiv D.S. Chauhan
>

[Firebird-net-provider] Catching Exception

[LtColRDSChauhan <rds...@gm...>]

Hi,

1.  When I run my application, in Release configuration, through
SharpDevelop IDE, the application catches "Handled Exception" -
"FirebirdSql.Data.Common.IscException:
OVER_ALLOCATED_BED" thrown by Firebird stored procedure .

2.  Without debugger, the exception is not caught.  I do have catch blocks
for : FbException, ApplicationException and Exception.

3.  Complication fails on adding catch block for
FirebirdSql.Data.Common.IscException (appears to be internal).

4.  Please help.

Thanks and Regards,
Lt Col (Retd) Rajiv D.S. Chauhan

[Firebird-net-provider] [FB-Tracker] Created: (DNET-564) Parameters are ignored if a comment in a query contains a single or double quote

[Amro El-F. (JIRA) <tr...@fi...>]

Parameters are ignored if a comment in a query contains a single or double quote
--------------------------------------------------------------------------------

                 Key: DNET-564
                 URL: http://tracker.firebirdsql.org/browse/DNET-564
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
            Reporter: Amro El-Fakharany
            Assignee: Jiri Cincura
            Priority: Minor


The following query fails with an unknown token exception:
select int_field
from test
-- a comment with ' 
where varchar_field = @field

-- 
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

        

Re: [Firebird-net-provider] SqlQuery is not working

[Jiří Č. <di...@ci...>]

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] SqlQuery is not working

[Marco C. <mc...@mc...>]

Hello,

This procedure seems to be not working. I tried in MSSQL provider and it 
worked.

var r = entity.Database.SqlQuery<counter>( 
  "Select Gen_id(COUNTER, 1) cnt from rdb$database", new object[]{});

When I try to read "r" it returns this message:

Invalid attempt of read when the reader is closed.

Thanks,
Marco Castro

Re: [Firebird-net-provider] Error when reading from connection

[Jiří Č. <di...@ci...>]

You connection is broken at some point. Maybe something on network?

-- 
Mgr. Jiří Činčura
Independent IT Specialist