Re: [Firebird-net-provider] About GUIDs in Firebird

[Jiří Činčura]

> I may have missed the point or I'm not aware of all the details here but
> trying to use a GUID in its string representation is a failure by itself. 

Thank you!

> Is there a case where this is needed because doing it right (using a Guid
> as its type and not as string) and use parameters isn't possible? 

I'm not aware of any. Except when you want to show the Guid for some
logging/debugging purposes and you're looking for it in database. But
still...

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

--
Developer Access Program for Intel Xeon Phi Processors
Access to Intel Xeon Phi processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today. http://sdm.link/xeonphi
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Entity Framework 5

[Jiří Činčura]

> Too much effort?

Correct. 

Currently MS's story is only EF6 and EFCore so I don't want to waste too
much of my free time on anything extra. Considering the move to EF6 from
EF5 is not that difficult I don't see much reasons to keep it (and there
has been plenty of time to do it). And of course there are always
previous versions available.

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

--
Developer Access Program for Intel Xeon Phi Processors
Access to Intel Xeon Phi processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today. http://sdm.link/xeonphi
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] About GUIDs in Firebird

[Ralf Jansen]

I may have missed the point or I'm not aware of all the details here but trying 
to use a GUID in its string representation is a failure by itself. 
I see no benefit in making something work that isn't advisable in the first 
place. Like trying to move a datetime as string to the db and hoping it get 
interpreted correctly. 

Is there a case where this is needed because doing it right (using a Guid as 
its type and not as string) and use parameters isn't possible? 

-Ursprüngliche Nachricht-
Von: Jiří Činčura [mailto:j...@cincura.net] 
Gesendet: Dienstag, 10. Januar 2017 15:20
An: For users & developers of the Firebird .NET providers 

Betreff: [Firebird-net-provider] About GUIDs in Firebird

Hi *,

we have this ticket DNET-509 in tracker. Although I agree the change would be 
nice, it's also a breaking change as huge as it can get. What's your take on 
it? Or do you see clean way out?

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

--
Developer Access Program for Intel Xeon Phi Processors Access to Intel Xeon Phi 
processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today. http://sdm.link/xeonphi 
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
--
Developer Access Program for Intel Xeon Phi Processors
Access to Intel Xeon Phi processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today. http://sdm.link/xeonphi
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Entity Framework 5

[Геннадий Забула]

Too much effort?


On 10 January 2017 at 19:21, Jiří Činčura  wrote:
>> Have you considered supporting two separate libraries? In two separate
>> branches/nuget and so on?
>
> Not really.
>
> --
> Mgr. Jiří Činčura
> Independent IT Specialist
>
> --
> Developer Access Program for Intel Xeon Phi Processors
> Access to Intel Xeon Phi processor-based developer platforms.
> With one year of Intel Parallel Studio XE.
> Training and support from Colfax.
> Order your platform today. http://sdm.link/xeonphi
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

--
Developer Access Program for Intel Xeon Phi Processors
Access to Intel Xeon Phi processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today. http://sdm.link/xeonphi
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] About GUIDs in Firebird

[Геннадий Забула]

We had encountered this one in our migration to .net provider, it
caused us much pain, because divergence with other SQL providers.

I'd vote for changing this and declaring it as breaking change. With
supplied fixes for existing code, of course.

On 10 January 2017 at 16:20, Jiří Činčura  wrote:
> Hi *,
>
> we have this ticket DNET-509 in tracker. Although I agree the change
> would be nice, it's also a breaking change as huge as it can get. What's
> your take on it? Or do you see clean way out?
>
> --
> Mgr. Jiří Činčura
> Independent IT Specialist
>
> --
> Developer Access Program for Intel Xeon Phi Processors
> Access to Intel Xeon Phi processor-based developer platforms.
> With one year of Intel Parallel Studio XE.
> Training and support from Colfax.
> Order your platform today. http://sdm.link/xeonphi
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

--
Developer Access Program for Intel Xeon Phi Processors
Access to Intel Xeon Phi processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today. http://sdm.link/xeonphi
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Entity Framework 5

[Jiří Činčura]

> Have you considered supporting two separate libraries? In two separate
> branches/nuget and so on?

Not really. 

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

--
Developer Access Program for Intel Xeon Phi Processors
Access to Intel Xeon Phi processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today. http://sdm.link/xeonphi
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Entity Framework 5

[Геннадий Забула]

Have you considered supporting two separate libraries? In two separate
branches/nuget and so on?

On 9 January 2017 at 16:55, Jiří Činčura  wrote:
> Hi *,
>
> anybody still using EF5 (or even EF4)? Or is everybody on EF6...
> Thinking about slimming the FirebirdSql.Data.FirebirdClient and removing
> the old EF support and keeping only EF6 (EntityFramework.Firebird).
>
> --
> Mgr. Jiří Činčura
> Independent IT Specialist
>
> --
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, SlashDot.org! http://sdm.link/slashdot
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

--
Developer Access Program for Intel Xeon Phi Processors
Access to Intel Xeon Phi processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today. http://sdm.link/xeonphi
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

[Firebird-net-provider] About GUIDs in Firebird

[Jiří Činčura]

Hi *,

we have this ticket DNET-509 in tracker. Although I agree the change
would be nice, it's also a breaking change as huge as it can get. What's
your take on it? Or do you see clean way out?

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

--
Developer Access Program for Intel Xeon Phi Processors
Access to Intel Xeon Phi processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today. http://sdm.link/xeonphi
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Fill Method of FbDataAdapter fails

[Jiří Činčura]

> I think I am running out of memory which leads to the connection being
> terminated.
> In such a case the Exception should be Out of Memory.
> Possibly the Exception caught is incorrect.
> Can this be confirmed please.

Yes it can.

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

--
Developer Access Program for Intel Xeon Phi Processors
Access to Intel Xeon Phi processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today. http://sdm.link/xeonphi
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Events

[Nikolaus Kern]

Hello Jiri,

is it neccessary or recommended to dispose a FbRemoteEvent with this new 
release? (I assume it should be disposed)

Number of events: Is this the number the program can listen to or something 
different?

Thanks

Niko

-Ursprüngliche Nachricht-
Von: Jiří Činčura [mailto:j...@cincura.net] 
Gesendet: Dienstag, 10. Jänner 2017 11:32
An: For users & developers of the Firebird .NET providers 

Betreff: [Firebird-net-provider] Events

Hi *,

The events code was not much reliable and I recently got time to work on it to 
improve it. So in foreseeable future the changes from `events` branch will be 
merged and new version will be released. Given it's breaking changes it's going 
to be very very likely new major version.

Here's a simple demo code to see how it works now:
https://github.com/cincuranet/FirebirdSql.Data.FirebirdClient/blob/events/Provider/src/FirebirdSql.Data.UnitTests/FbRemoteEventTests.cs#L40

The major changes are:
* Number of events is now limited to ushort.MaxValue. FTW!
* FbRemoteEvent now takes connection string instead of FbConnection (so it's 
connection independent).
* It implements IDisposable.
* The RemoteEventCounts event is fired for every event fired with some count 
(aka Count > 0).
* There's a new event RemoteEventError allowing you to be notified in case i.e. 
the events channel is broken and exception is thrown.
* No extra threads are created or used.

That's about it. Questions?

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

--
Developer Access Program for Intel Xeon Phi Processors Access to Intel Xeon Phi 
processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today. http://sdm.link/xeonphi 
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider


--
Developer Access Program for Intel Xeon Phi Processors
Access to Intel Xeon Phi processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today. http://sdm.link/xeonphi
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

[Firebird-net-provider] Events

[Jiří Činčura]

Hi *,

The events code was not much reliable and I recently got time to work on
it to improve it. So in foreseeable future the changes from `events`
branch will be merged and new version will be released. Given it's
breaking changes it's going to be very very likely new major version.

Here's a simple demo code to see how it works now:
https://github.com/cincuranet/FirebirdSql.Data.FirebirdClient/blob/events/Provider/src/FirebirdSql.Data.UnitTests/FbRemoteEventTests.cs#L40

The major changes are:
* Number of events is now limited to ushort.MaxValue. FTW!
* FbRemoteEvent now takes connection string instead of FbConnection (so
it's connection independent).
* It implements IDisposable.
* The RemoteEventCounts event is fired for every event fired with some
count (aka Count > 0).
* There's a new event RemoteEventError allowing you to be notified in
case i.e. the events channel is broken and exception is thrown.
* No extra threads are created or used.

That's about it. Questions?

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

--
Developer Access Program for Intel Xeon Phi Processors
Access to Intel Xeon Phi processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today. http://sdm.link/xeonphi
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider