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

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

[Jiri C. <di...@ci...>]

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. But you'd have to deal with tombstoning, suspend
states, ... to make it ACID. To just cache/store data locally you can
use Isolated Storage.

And of course, the Firebird itself doesn't run on WP - partly because
MS doesn't allow you native code and partly because it was not
compiled for this platform.


--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com

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

[André K. <Kna...@be...>]

Thank you very much, Michael.
I  will  do some more research. I knew about SQL Server CE before, but
rather  would  stick  with Firebird. Maybe I will put it all off until
next year.

Right  now,  there  is  no  VPN  available for WP8. If that finally is
available,  our  new  WP-devices will start to be interesting for real
business  use,  and of course I'd like to provide my colleagues with a
mobile subset of our application.



> André Knappstein schrieb am 17.07.2013 um 17:31 (+0200):

>> Before  I  start  writing  apps for Windows Phone 8, can anybody
>> confirm that I can use FB Embed and the .net provider or that I can
>> not use it?

> Did some Google research on this question:

> Apps offered on the App Store are restricted to WP8 SDK APIs, and they
> are screened. You may not ship random native or other code on a WP8.
> Ans AFAIK, WP8 does not ship fbembed.dll itself. :)

> Firebird client or server code would probably have to be *ported* to
> one of the WP8 APIs in order for you to use it there.

> Porting Existing C++ Code to Windows 8/Windows Phone 8
> http://www.infoq.com/news/2012/10/Porting-Cpp-WinRT

> SQLite has been ported to WinRT and WP8, and/or is otherwise supported
> by Microsoft.

> Using SQLite in a Metro style app
> http://timheuer.com/blog/archive/2012/05/20/using-sqlite-in-metro-style-app.aspx

> Windows Phone 8 und SQLite | MSDN Online
> http://www.microsoft.com/germany/msdn/aktuell/news/show.aspx?id=msdn_de_48779

> It seems WP8 ships sqlite3.dll with appropriate wrappers to be called by
> app code. Or maybe an app has to ship its own copy, I don't know.

> SQLite-WinRT: Database programming on Windows Phone and Windows 8
> Andy Wigley's Blog
> http://andywigley.com/2013/06/06/sqlite-winrt-database-programming-on-windows-phone-and-windows-8/

> An alternative to SQLite would be SQL Server CE.

> Sql Server CE is the Database That WinPhone Uses by Default | Mobile Zone
> http://mobile.dzone.com/articles/sql-server-ce-database

> Michael

> ------------------------------------------------------------------------------
> See everything from the browser to the database with AppDynamics
> Get end-to-end visibility with application monitoring from AppDynamics
> Isolate bottlenecks and diagnose root cause in seconds.
> Start your free trial of AppDynamics Pro today!
> http://pubads.g.doubleclick.net/gampad/clk?id=48808831&iu=/4140/ostg.clktrk
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> 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:  kna...@be...

Amtsgericht Hamm Nr. B 420
Geschäftsführer: Achim Krähling, Dirk Salewski und Matthias Steinhaus

USt-IDNr.: DE 125215402

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

[Michael L. <mi...@gm...>]

André Knappstein schrieb am 17.07.2013 um 17:31 (+0200):

> Before  I  start  writing  apps for Windows Phone 8, can anybody
> confirm that I can use FB Embed and the .net provider or that I can
> not use it?

Did some Google research on this question:

Apps offered on the App Store are restricted to WP8 SDK APIs, and they
are screened. You may not ship random native or other code on a WP8.
Ans AFAIK, WP8 does not ship fbembed.dll itself. :)

Firebird client or server code would probably have to be *ported* to
one of the WP8 APIs in order for you to use it there.

Porting Existing C++ Code to Windows 8/Windows Phone 8
http://www.infoq.com/news/2012/10/Porting-Cpp-WinRT

SQLite has been ported to WinRT and WP8, and/or is otherwise supported
by Microsoft.

Using SQLite in a Metro style app
http://timheuer.com/blog/archive/2012/05/20/using-sqlite-in-metro-style-app.aspx

Windows Phone 8 und SQLite | MSDN Online
http://www.microsoft.com/germany/msdn/aktuell/news/show.aspx?id=msdn_de_48779

It seems WP8 ships sqlite3.dll with appropriate wrappers to be called by
app code. Or maybe an app has to ship its own copy, I don't know.

SQLite-WinRT: Database programming on Windows Phone and Windows 8
Andy Wigley's Blog
http://andywigley.com/2013/06/06/sqlite-winrt-database-programming-on-windows-phone-and-windows-8/

An alternative to SQLite would be SQL Server CE.

Sql Server CE is the Database That WinPhone Uses by Default | Mobile Zone
http://mobile.dzone.com/articles/sql-server-ce-database

Michael

[Firebird-net-provider] Windows Phone 8

[André K. <Kna...@be...>]

I  google'd  and Bing'd through some index pages, but either my search
combination  was  too poor or there really is not a useful page to be found.

Here   goes:  Before  I  start  writing  apps for Windows Phone 8, can
anybody  confirm that I can use FB Embed and the .net provider or that
I can not use it?

No way for me writing apps based on other databases at the moment.

Thanks!
André


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:  kna...@be...

Amtsgericht Hamm Nr. B 420
Geschäftsführer: Achim Krähling, Dirk Salewski und Matthias Steinhaus

USt-IDNr.: DE 125215402

[Firebird-net-provider] [FB-Tracker] Created: (DNET-511) Firebird ADO.NET Data Provider Version 3.0.2 does not support .Net Framework 4?

[NoPyGod (JIRA) <tr...@fi...>]

Firebird ADO.NET Data Provider Version 3.0.2 does not support .Net Framework 4?
-------------------------------------------------------------------------------

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


I downloaded Firebird ADO.NET Data Provider 3.0.2 from the Firdbird website.

    http://www.firebirdsql.org/en/net-provider/

I start a new visual studio project, specifying .Net Framework 4 (not client profile)

At the top of one of my source files I put

    using FirebirdSql.Data.FirebirdClient

Then I try to build the project, and it gives the following error -

    The type or namespace name 'FirebirdSql' could not be found (are you missing a using directive or an assembly reference?)

However if I download version 2.6 of the Firebird ADO.NET Data Provider, it works just fine.

Am I understanding this correctly, version 3.0.2 does not support .NET Framework 4.0?

Unfortunately Windows Xp doesn't support .NET 4.5 so I hope that's not the case.

-- 
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] Cancel in FB embedded slow?

[Jiri C. <di...@ci...>]

Yes, this is fine for Firebird.


--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com

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

[HERNAN M. F. <her...@ob...>]

> On Wed, Jul 3, 2013 at 12:36 PM, HERNAN MARTINEZ FOFFANI
> <her...@ob...> 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 records up to the end. So as a sanity measure I added a Cancel()
> 
> That might be a lot of wasting, in case of huge resultset and blobs.

Care to elaborate? You mean the check I mentioned in the next paragraph
or something else?

Some pseudo code

     canceling = false;
     reader = command.ExecuteQuery();
     foreach ( row in reader ) {
         
         canceling = process ( row );

         // someone sets canceling, doesn't need the rest of the resultset.
         if (canceling)
             break;
     }
     if (canceling)                    // <- this check is what I added today.
         command.Cancel();    // <- this call was unconditionally before.
     reader.Close();
     command.Close();

Close() …etc… goes in a finally clause. In real code I'm catching exceptions
to quit cleanly.

The Cancel() is needed because closing a data reader with pending data
keeps reading until the end of the data set. I don't remember which provider
did that (SqlServer or Oracle?)

> 
>> in the Dispose() method of the wrapper.
>> 
>> I've just modified the wrapper and instead of calling Cancel() unconditionally
>> it first check if the DataReader was consumed or not and only cancel if it
>> wasn't.
> 
> That's first step. ;)


Ugh.

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

[Jiri C. <di...@ci...>]

On Wed, Jul 3, 2013 at 12:36 PM, HERNAN MARTINEZ FOFFANI
<her...@ob...> 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 records up to the end. So as a sanity measure I added a Cancel()

That might be a lot of wasting, in case of huge resultset and blobs.

> in the Dispose() method of the wrapper.
>
> I've just modified the wrapper and instead of calling Cancel() unconditionally
> it first check if the DataReader was consumed or not and only cancel if it
> wasn't.

That's first step. ;)

--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com

Re: [Firebird-net-provider] Improving

[Jiri C. <di...@ci...>]

On Wed, Jul 3, 2013 at 2:02 PM, Mark Rotteveel <ma...@la...> 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

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

On Wed, 3 Jul 2013 13:36:58 +0200, Jiri Cincura <di...@ci...>
wrote:
> 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).

SourceForge also provides a Git repo. Have you looked into that?

Mark

Re: [Firebird-net-provider] Improving

[Jiri C. <di...@ci...>]

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 not interested, just because
> we  do  not  actively take part in the discussion. Most of us probably
> are   convinced   that "no objection == full approval" and prefer keep
> on  just  lurking  and not to choke the mailing list when there is not
> really much to say.
>
> But maybe from time to time it is good if someone like me *is* choking
> the line to show that we are still alive :-)
>
> Working with the source code is something I would personally not do in
> the   near   future.  I certainly would be able to, I have to do so in
> more  situations  than  I'd like (with other software packages). But I
> only  do  so  if there is absolutely no other way. Developers of those
> packages  usually  post  the  code on their own websites, or even send
> them via e-mail.
>
> The only time I tried to download the source for a personal rebuild
> concerning Firebird (about 8 months ago) I found that doing so from
> SourceForge was too complicated and I had to give it up. But it does
> not necessarily mean that I could manage this better from Git.
>
> Your  arguments  sound very reasonable in any case, and most of all it
> makes  your work easier. When your work is easier it helps you to help
> me in the future, so I certainly approve this idea.
>
> I  see  a potential problem only where a generalist developer is quite
> used  to SF and still finds all his other sources there and would have
> to acquaint another source location just for the .net provider.
> But,  then  again, nobody said that life as a developer has to be free
> from  obstacles  all  the  time,  and if you never change anything you
> won't ever improve something.
>
> best regards,
> André Knappstein
>
>
>
> > 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 feel my pain. So first
> > part of the improving I'd like to offer moving to Git on GitHub. I'm
> > not a fan of GitHub (I like BitBucket, if somebody asks), but it's a
> > de-facto standard in OSS.
>
> > With this we will also gain benefits like downloading the sources
> > packed, downloadig specific version etc.
>
> > Also I'd like to release *only* on NuGet and latest version for latest
> > framework as MSI (on website). The rest can be downloaded/extracted
> > from NuGet. We now support just .NET 3.5 SP1 and later, thus at least
> > VS2010 and so NuGet is available to everybody. And even that, you can
> > grab NuGet.exe and download from command line, if you want (i.e.
> > you're hard-core developer using Notepad and csc only :)). Both these
> > with higher cadence, shorter release loop as mentioned in previous
> > thread.
>
> > Maybe I'm too optimistic, so please let me know what you think and
> > what you think is going not work. ;)
>
> > JC
>
> > --
> > 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
> > _______________________________________________
> > Firebird-net-provider mailing list
> > Fir...@li... <javascript:;>
> > 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:  kna...@be... <javascript:;>
>
> Amtsgericht Hamm Nr. B 420
> Geschäftsführer: Achim Krähling, Dirk Salewski und Matthias Steinhaus
>
> USt-IDNr.: DE 125215402
>
>
>
> ------------------------------------------------------------------------------
> This SF.net email is sponsored by Windows:
>
> Build for Windows Store.
>
> http://p.sf.net/sfu/windows-dev2dev
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li... <javascript:;>
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>


-- 
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com

Re: [Firebird-net-provider] Improving

[Jiri C. <di...@ci...>]

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
> 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 feel my pain. So first
> part of the improving I'd like to offer moving to Git on GitHub. I'm
> not a fan of GitHub (I like BitBucket, if somebody asks), but it's a
> de-facto standard in OSS.
>
> With this we will also gain benefits like downloading the sources
> packed, downloadig specific version etc.
>
> Also I'd like to release *only* on NuGet and latest version for latest
> framework as MSI (on website). The rest can be downloaded/extracted
> from NuGet. We now support just .NET 3.5 SP1 and later, thus at least
> VS2010 and so NuGet is available to everybody. And even that, you can
> grab NuGet.exe and download from command line, if you want (i.e.
> you're hard-core developer using Notepad and csc only :)). Both these
> with higher cadence, shorter release loop as mentioned in previous
> thread.
>
> Maybe I'm too optimistic, so please let me know what you think and
> what you think is going not work. ;)
>
> JC
>
> --
> Jiri {x2} Cincura (x2develop.com founder)
> http://blog.cincura.net/ | http://www.ID3renamer.com
>


-- 
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com

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

[HERNAN M. F. <her...@ob...>]

>> 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 the Cancel?
> 

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 records up to the end. So as a sanity measure I added a Cancel()
in the Dispose() method of the wrapper.

I've just modified the wrapper and instead of calling Cancel() unconditionally
it first check if the DataReader was consumed or not and only cancel if it
wasn't.

Re: [Firebird-net-provider] Improving

[André K. <Kna...@be...>]

Jiri,

not so that you get an impression we were not interested, just because
we  do  not  actively take part in the discussion. Most of us probably
are   convinced   that "no objection == full approval" and prefer keep
on  just  lurking  and not to choke the mailing list when there is not
really much to say. 

But maybe from time to time it is good if someone like me *is* choking
the line to show that we are still alive :-)

Working with the source code is something I would personally not do in
the   near   future.  I certainly would be able to, I have to do so in
more  situations  than  I'd like (with other software packages). But I
only  do  so  if there is absolutely no other way. Developers of those
packages  usually  post  the  code on their own websites, or even send
them via e-mail.

The only time I tried to download the source for a personal rebuild
concerning Firebird (about 8 months ago) I found that doing so from
SourceForge was too complicated and I had to give it up. But it does
not necessarily mean that I could manage this better from Git.

Your  arguments  sound very reasonable in any case, and most of all it
makes  your work easier. When your work is easier it helps you to help
me in the future, so I certainly approve this idea.

I  see  a potential problem only where a generalist developer is quite
used  to SF and still finds all his other sources there and would have
to acquaint another source location just for the .net provider.
But,  then  again, nobody said that life as a developer has to be free
from  obstacles  all  the  time,  and if you never change anything you
won't ever improve something.

best regards,
André Knappstein



> 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 feel my pain. So first
> part of the improving I'd like to offer moving to Git on GitHub. I'm
> not a fan of GitHub (I like BitBucket, if somebody asks), but it's a
> de-facto standard in OSS.

> With this we will also gain benefits like downloading the sources
> packed, downloadig specific version etc.

> Also I'd like to release *only* on NuGet and latest version for latest
> framework as MSI (on website). The rest can be downloaded/extracted
> from NuGet. We now support just .NET 3.5 SP1 and later, thus at least
> VS2010 and so NuGet is available to everybody. And even that, you can
> grab NuGet.exe and download from command line, if you want (i.e.
> you're hard-core developer using Notepad and csc only :)). Both these
> with higher cadence, shorter release loop as mentioned in previous
> thread.

> Maybe I'm too optimistic, so please let me know what you think and
> what you think is going not work. ;)

> JC

> --
> 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
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> 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:  kna...@be...

Amtsgericht Hamm Nr. B 420
Geschäftsführer: Achim Krähling, Dirk Salewski und Matthias Steinhaus

USt-IDNr.: DE 125215402

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

[Jiri C. <di...@ci...>]

On Wed, Jul 3, 2013 at 11:28 AM, HERNAN MARTINEZ FOFFANI
<her...@ob...> 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 the Cancel?


--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com

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

[HERNAN M. F. <her...@ob...>]

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

I was profiling my application to look up where to apply our optimization efforts.

The process I was measuring is a big loop with reads and updates. I was
hoping to see that most of the time was expended in I/O and if it was not to
optimize the rest of my code.

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.

>> finished to read all the rows).
>> Is this an expected behavior? I'm asking because it may very well be a bug
> 
> You didn't described the behavior.
> 
>> If it helps, the profiler marks the methods BuildSqlState() and
>> BuildExceptionMessage() from FirebirdSql.Data.Common.IscException.
> 
> Marks with what? Why?

It's a profiler, it just says 'HOT'. It doesn't really matter the actual label, it just
reports that those methods take most of the time.

I know nothing about Firebird .Net provider so it could be very well the correct
behavior. I were just telling what I saw.

> 
> Also providing the test case/code in your question would help others
> understand what you're trying to do.

Fair enough.

[Firebird-net-provider] Improving

[Jiri C. <di...@ci...>]

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 feel my pain. So first
part of the improving I'd like to offer moving to Git on GitHub. I'm
not a fan of GitHub (I like BitBucket, if somebody asks), but it's a
de-facto standard in OSS.

With this we will also gain benefits like downloading the sources
packed, downloadig specific version etc.

Also I'd like to release *only* on NuGet and latest version for latest
framework as MSI (on website). The rest can be downloaded/extracted
from NuGet. We now support just .NET 3.5 SP1 and later, thus at least
VS2010 and so NuGet is available to everybody. And even that, you can
grab NuGet.exe and download from command line, if you want (i.e.
you're hard-core developer using Notepad and csc only :)). Both these
with higher cadence, shorter release loop as mentioned in previous
thread.

Maybe I'm too optimistic, so please let me know what you think and
what you think is going not work. ;)

JC

--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com

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

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

Support Database.Exists
-----------------------

                 Key: DNET-510
                 URL: http://tracker.firebirdsql.org/browse/DNET-510
             Project: .NET Data provider
          Issue Type: Improvement
          Components: Entity Framework support
    Affects Versions: 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 administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

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

[Jiri C. <di...@ci...>]

OK, DNET-510.

--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com

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

[Jiri C. <di...@ci...>]

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?

[Jiri C. <di...@ci...>]

On Tue, Jul 2, 2013 at 6:21 PM, HERNAN MARTINEZ FOFFANI
<her...@ob...> 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'm asking because it may very well be a bug

You didn't described the behavior.

> If it helps, the profiler marks the methods BuildSqlState() and
> BuildExceptionMessage() from FirebirdSql.Data.Common.IscException.

Marks with what? Why?

Also providing the test case/code in your question would help others
understand what you're trying to do.

--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com

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

[HERNAN M. F. <her...@ob...>]

Hi,

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., finished to read all the rows).
Is this an expected behavior? I'm asking because it may very well be a bug in our data layers. I might also avoid the command.Cancel() call when a cursor is consumed if that is better practice.

My platform:
.NET 4.0
FirebirdClient 3.0.2.0
Firebird Server 2.5.1.26531 (embedded)

If it helps, the profiler marks the methods BuildSqlState() and BuildExceptionMessage() from FirebirdSql.Data.Common.IscException.

Regards,

Hernán Martínez-Foffani

[Firebird-net-provider] Checking if FireBird Server is running

[gregosborne <gos...@st...>]

Since FB did not implement the connectiontimeout property of the
FbConnection, I neeeded a way to get around the @30 second delay when
connection to a FB server. Below is my solution.
using System.Net;
using System.Net.Sockets;
using System.Configuration;

private bool TestPort(string address, int port)
{
    int timeout = 500;
    if(ConfigurationManager.AppSettings["RemoteTestTimeout"]
!= null)
        timeout =
int.Parse(ConfigurationManager.AppSettings["RemoteTestTimeout"]);
    var result = false;
    try
    {
        using(var socket = new
Socket(AddressFamily.InterNetwork, SocketType.Stream, ProtocolType.Tcp))
        {
            IAsyncResult
asyncResult = socket.BeginConnect(address, port, null, null);
            result
= asyncResult.AsyncWaitHandle.WaitOne(timeout, true);
            socket.Close();
        }
        return result;
    }
    catch { return false; }
}
This method tries to open a tcp connection to the FB server and if
successful, immediately returns, otherwise it waits until the timeout
specified and then returns. Just make the call using the servername or ip of
the FB server, with the port. Just make sure the timeout you specify is
tuned to your own network speed, or you may receive false negatives.
Hope this helps others who are frustrated by the lack of a timeout.




--
View this message in context: http://firebird.1100200.n4.nabble.com/Checking-if-FireBird-Server-is-running-tp4633459.html
Sent from the firebird-net-provider mailing list archive at Nabble.com.

Re: [Firebird-net-provider] Is boolean type (Firebird 3.0) supported by .NETProvider-3.0.2.0?

[Thomas B. <Tho...@As...>]

> On 18-6-2013 11:26, Thomas Beckmann wrote:
> > Fields of this type show "unknown" type in Entity Developer, but I don't
> > know whether this is a problem of ED or of the .NET Provider.
> 
> As far as I know the Firebird .NET provider 3.0 doesn't provide (full) 
> support for Firebird 3.0 (that fact that both have version number 3.0 is 
> just coincidence).

Thank you again, Mark, do you know whether a beta is available or a roadmap,
when this support is planend?

Re: [Firebird-net-provider] Is boolean type (Firebird 3.0) supported by .NETProvider-3.0.2.0?

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

On 18-6-2013 11:26, Thomas Beckmann wrote:
> Fields of this type show "unknown" type in Entity Developer, but I don't
> know whether this is a problem of ED or of the .NET Provider.
>
> Thank you for any hints! Thomas

As far as I know the Firebird .NET provider 3.0 doesn't provide (full) 
support for Firebird 3.0 (that fact that both have version number 3.0 is 
just coincidence).

Mark
-- 
Mark Rotteveel