from:"Геннадий Забула"

> No. You talked about generator/identity columns. Possibly replacing the
interface.
I think I've lose the point in this.

> That's definitely not. You can have one generator for all tables (and
it's even better).
For "Even better" I have doubts. Especially for multithreaded inserts
to different tables case.

> That's definitely not.
I'm talking about "generator creation", it should be hidden in the
provider. Though names yes, user should be allowed to pick a naming
scheme he wants.
In case "one generator for all tables" user specifies one generator
name for all tables and provider should check if it exists - nothing
to do, if not it creates new. After that it binds the generator name
to before insert trigger.

> Well, the default initializers are using different path.
Yep, I'm aware about this. First I've patched one code path. After
merge the migration feature I needed to patch another code path, and
resulting database had differences.

On 1 October 2015 at 14:13, Jiří Činčura <j...@cincura.net> wrote:
> On Thu, Oct 1, 2015, at 11:45, Геннадий Забула wrote:
>> >Do you think the annotations will be better?
>> Better than what? Your concern was about different naming schemes, I
>> suggested how it can be resolved via column annotations and custom
>> name providers. I don't know other options for this.
>
> No. You talked about generator/identity columns. Possibly replacing the
> interface.
>
>> >How is the generator creation (if it does not exists) going to be handled? 
>> >Or are we going to leave that to manual change of Up method in migration?
>> IMO generator creation is an implementation detail that user shouldn't
>> bother about. Generator creation is a part of a table creation.
>
> That's definitely not. You can have one generator for all tables (and
> it's even better).
>
>> >Do you have some more info for this.
>> I'm sure that there were issues about identity columns. The current
>> implementation CreateDatabaseIfExists doesn't create generators in any
>> case, we patched sources to do that. Also, bool fields don't have
>> CHECK IN (0, 1) annotation and so on.
>> I need time to provide additional info for this.
>
> Well, the default initializers are using different path. These existed
> before migrations. The code is different (and also the feature set). It
> also works with EDMX and CF, while migrations are (currently) CF only.
>
> --
> Mgr. Jiří Činčura
> Independent IT Specialist
>
> --
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

--
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Inserting strings problem

Entity:
public sealed class Table
{
public Table()
{
this.Entities1 = new List();
}

public int Id { get; set; }
public string Field1{ get; set; }
public string Field2{get; set; }
public string Field3 { get; set; }
public string Field4 { get; set; }
public string Field5 {get; set; }

public Entities3 Entities3 { get; set; }
public ICollection Entities1{ get; set; }
public ICollection Entities2{ get; set; }
}

On 1 October 2015 at 13:53, Геннадий Забула <zabulu...@gmail.com> wrote:
> We map the entities through EntityTypeConfiguration class:
>
> Src table mapping:
> this.HasKey(t => t.Id);
>
> // Properties
> // Table & Column Mappings
> this.ToTable("TABLE2");
> this.Property(t => t.Id).HasColumnName("ID");
> this.Property(x => x.Field1).HasColumnName("FIELD1");
> this.Property(x => x.Field2).HasColumnName("FIELD2");
> this.Property(x => x.Field3).HasColumnName("FIELD3");
> this.Property(x => x.Field4).HasColumnName("FIELD4");
> this.Property(x => x.Field5).HasColumnName("FIELD5");
>
> Dst table mapping inherits from above:
>
> :base()
> {
> Property(x =>
> x.Id).HasDatabaseGeneratedOption(System.ComponentModel.DataAnnotations.Schema.DatabaseGeneratedOption.None);
> }
>
> On 1 October 2015 at 13:38, Jiří Činčura <j...@cincura.net> wrote:
>> How does the entity and mapping looks like?
>>
>> --
>> Mgr. Jiří Činčura
>> Independent IT Specialist
>>
>>
>> --
>> ___
>> Firebird-net-provider mailing list
>> Firebird-net-provider@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

--
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Inserting strings problem

Hm, looks like it works. Added .HasMaxLength(256) to all fields and it
goes success ahead.
Before I tried only for one field and it doesn't work.
Thx for fast response.


On 1 October 2015 at 13:56, Jiří Činčura <j...@cincura.net> wrote:
> You should specify, at least, the length. Else it's the default and
> that's "unlimited" hence the blob.
>
> --
> Mgr. Jiří Činčura
> Independent IT Specialist
>
> On Thu, Oct 1, 2015, at 12:54, Геннадий Забула wrote:
>> Entity:
>> public sealed class Table
>> {
>> public Table()
>> {
>> this.Entities1 = new List();
>> }
>>
>> public int Id { get; set; }
>> public string Field1{ get; set; }
>> public string Field2{get; set; }
>> public string Field3 { get; set; }
>> public string Field4 { get; set; }
>> public string Field5 {get; set; }
>>
>> public Entities3 Entities3 { get; set; }
>> public ICollection Entities1{ get; set; }
>> public ICollection Entities2{ get; set; }
>> }
>>
>> On 1 October 2015 at 13:53, Геннадий Забула <zabulu...@gmail.com> wrote:
>> > We map the entities through EntityTypeConfiguration class:
>> >
>> > Src table mapping:
>> > this.HasKey(t => t.Id);
>> >
>> > // Properties
>> > // Table & Column Mappings
>> > this.ToTable("TABLE2");
>> > this.Property(t => t.Id).HasColumnName("ID");
>> > this.Property(x => x.Field1).HasColumnName("FIELD1");
>> > this.Property(x => x.Field2).HasColumnName("FIELD2");
>> > this.Property(x => x.Field3).HasColumnName("FIELD3");
>> > this.Property(x => x.Field4).HasColumnName("FIELD4");
>> > this.Property(x => x.Field5).HasColumnName("FIELD5");
>> >
>> > Dst table mapping inherits from above:
>> >
>> > :base()
>> > {
>> > Property(x =>
>> > x.Id).HasDatabaseGeneratedOption(System.ComponentModel.DataAnnotations.Schema.DatabaseGeneratedOption.None);
>> > }
>> >
>> > On 1 October 2015 at 13:38, Jiří Činčura <j...@cincura.net> wrote:
>> >> How does the entity and mapping looks like?
>> >>
>> >> --
>> >> Mgr. Jiří Činčura
>> >> Independent IT Specialist
>> >>
>> >>
>> >> --
>> >> ___
>> >> Firebird-net-provider mailing list
>> >> Firebird-net-provider@lists.sourceforge.net
>> >> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>>
>> --
>> ___
>> Firebird-net-provider mailing list
>> Firebird-net-provider@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
> --
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

--
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Inserting strings problem

We map the entities through EntityTypeConfiguration class:

Src table mapping:
this.HasKey(t => t.Id);

// Properties
// Table & Column Mappings
this.ToTable("TABLE2");
this.Property(t => t.Id).HasColumnName("ID");
this.Property(x => x.Field1).HasColumnName("FIELD1");
this.Property(x => x.Field2).HasColumnName("FIELD2");
this.Property(x => x.Field3).HasColumnName("FIELD3");
this.Property(x => x.Field4).HasColumnName("FIELD4");
this.Property(x => x.Field5).HasColumnName("FIELD5");

Dst table mapping inherits from above:

:base()
{
Property(x =>
x.Id).HasDatabaseGeneratedOption(System.ComponentModel.DataAnnotations.Schema.DatabaseGeneratedOption.None);
}

On 1 October 2015 at 13:38, Jiří Činčura  wrote:
> How does the entity and mapping looks like?
>
> --
> Mgr. Jiří Činčura
> Independent IT Specialist
>
>
> --
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

--
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Migrations

> That's why
the interface with some default implementation is so convenient.
In ModelBuilder you can specify any object as data annotation. In this
case user can provide implementation of the interface.

On 1 October 2015 at 19:01, Jiří Činčura <j...@cincura.net> wrote:
> On Thu, Oct 1, 2015, at 13:38, Геннадий Забула wrote:
>> I'm talking about "generator creation", it should be hidden in the
>> provider. Though names yes, user should be allowed to pick a naming
>> scheme he wants.
>> In case "one generator for all tables" user specifies one generator
>> name for all tables and provider should check if it exists - nothing
>> to do, if not it creates new. After that it binds the generator name
>> to before insert trigger.
>
> Well that's just part of story. You also need to name the trigger. You
> need to have the body. Some people use like `Id is null` clauses. Some
> also include 0 or -1 (for integers) etc. Not sure how to code this using
> annotations (without implementing all possible combinations). That's why
> the interface with some default implementation is so convenient.
>
>> > Well, the default initializers are using different path.
>> Yep, I'm aware about this. First I've patched one code path. After
>> merge the migration feature I needed to patch another code path, and
>> resulting database had differences.
>
> I'd like to eventually re-use parts of migrations code to have (almost)
> same result.
>
> --
> Mgr. Jiří Činčura
> Independent IT Specialist
>
> --
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

--
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

[Firebird-net-provider] Inserting strings problem

I have next table in two databases:

CREATE TABLE TABLE2(
ID INTEGER NOT NULL,
FIELD1 VARCHAR(256),
FIELD2 VARCHAR(256),
FIELD3 VARCHAR(512),
FIELD4 VARCHAR(100),
FIELD5 VARCHAR(2048))

Using EF I'm trying to copy data from one database to another. I want
to copy full data including Ids, so I disabled Identity Generation for
a destination database.

Problem is the next when EF generates insert it looks like the following:
"INSERT INTO \"TABLE2\"(\"ID\", \"FIELD1\", \"FIELD2\", \"FIELD3\",
\"FIELD4\", \"FIELD5\")\r\nVALUES (@p0, @p1, @p2, @p3, @p4, @p5,
NULL)\r\n"

And I have a problem here, parameters for these fields are treated
like SQL_TEXT and it tries to put UTF8 byte array to VARCHAR fields,
which is wrong. And a query fails on some long strings that in utf8
interpretation longer than 256 for example.

When I turn Identity Generation on, query looks like following:
EXECUTE BLOCK (
 p1 BLOB SUB_TYPE TEXT = @p1, p7 BLOB SUB_TYPE TEXT = @p7, p8 BLOB
SUB_TYPE TEXT = @p8, p9 BLOB SUB_TYPE TEXT = @p9
) RETURNS (
"ID" INT)
AS BEGIN
INSERT INTO "TABLE2"("FIELD2",  "FIELD3", "FIELD4", "FIELD5", "FIELD6")
VALUES (:p1, :p7, :p8, :p9, NULL)
RETURNING "ID" INTO :"ID";
SUSPEND;
END

And it doesn't fail.

--
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] [FB-Tracker] Created: (DNET-631) Support for BOOLEAN in FB3

2015-09-25 Thread Геннадий Забула

Jiri, could you take a look at PR.
I've finished bringing support, but stuck with problems running
unit-tests on both servers 2.5/3.0. Both embedded configuration works
fine. I think I'll finish the problems this weekend.

On 24 September 2015 at 19:14, Jiří Činčura <j...@cincura.net> wrote:
> On Thu, Sep 24, 2015, at 18:10, Геннадий Забула wrote:
>> I have several question about Gds protocol. Where can I find
>> documentation about it? I need to know what should I write to send
>> boolean field to server.
>> And also I have doubts about an implementation of reading boolean fields.
>
> The best "documentation" is Firebird's source code. Not the most
> readable form, though. But always up-to-date.
>
> --
> Mgr. Jiří Činčura
> Independent IT Specialist
>
> --
> Monitor Your Dynamic Infrastructure at Any Scale With Datadog!
> Get real-time metrics from all of your servers, apps and tools
> in one place.
> SourceForge users - Click here to start your Free Trial of Datadog now!
> http://pubads.g.doubleclick.net/gampad/clk?id=241902991=/4140
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

--
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] [FB-Tracker] Created: (DNET-631) Support for BOOLEAN in FB3

2015-09-25 Thread Геннадий Забула

Thanks,
I've already got it working. At least tests migrated from Jaybird pass.
As Jiri suggested I took a look at FB core, and found everything I've needed.


On 25 September 2015 at 16:08, Mark Rotteveel <m...@lawinegevaar.nl> wrote:
> On Thu, 24 Sep 2015 19:10:44 +0300, Геннадий Забула <zabulu...@gmail.com>
> wrote:
>> https://github.com/cincuranet/FirebirdSql.Data.FirebirdClient/pull/40
>> WIP about boolean support is here. Only Gds implemented for now.
>>
>> I have several question about Gds protocol. Where can I find
>> documentation about it? I need to know what should I write to send
>> boolean field to server.
>
> There is the Firebird Wire protocol documentation, but it doesn't contain
> all details and is mostly based on reverse engineering the protocol on a
> message level, not so much the content of the messages. You'll have more
> luck looking at the Firebird implementation, or other drivers like Jaybird.
>
> In any case, you need to encode a boolean as a single byte byte-array with
> the value 0 for false or 1 for true. See also:
>
> https://github.com/FirebirdSQL/jaybird/blob/master/src/main/org/firebirdsql/gds/ng/DefaultDatatypeCoder.java#L358
>
> For reading and writing you also need information on the blr calculations:
> https://github.com/FirebirdSQL/jaybird/blob/master/src/main/org/firebirdsql/gds/ng/wire/DefaultBlrCalculator.java
>
> And reading:
> https://github.com/FirebirdSQL/jaybird/blob/master/src/main/org/firebirdsql/gds/ng/wire/version10/V10Statement.java#L516
>
> And writing:
> https://github.com/FirebirdSQL/jaybird/blob/master/src/main/org/firebirdsql/gds/ng/wire/version10/V10Statement.java#L564
>
> I'd also suggest to take a look at the commit for Jaybird I linked in
> ticket, as that includes all the changes you need to get it working.
>
>> And also I have doubts about an implementation of reading boolean
> fields.
>
> See above.
>
> Mark
>
> --
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

--
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] [FB-Tracker] Created: (DNET-631) Support for BOOLEAN in FB3

2015-09-24 Thread Геннадий Забула

https://github.com/cincuranet/FirebirdSql.Data.FirebirdClient/pull/40
WIP about boolean support is here. Only Gds implemented for now.

I have several question about Gds protocol. Where can I find
documentation about it? I need to know what should I write to send
boolean field to server.
And also I have doubts about an implementation of reading boolean fields.

On 14 September 2015 at 18:37, Jiří Činčura <j...@cincura.net> wrote:
> On Mon, Sep 14, 2015, at 17:17, Геннадий Забула wrote:
>> How should this be implemented?
>
> My guess is by typing the code. ;)
>
>> I could take a look at this in the week.
>
> Sure, why not. The BOOLEAN in provider will not take much effort - I was
> checking it last year, quickly.
>
> --
> Mgr. Jiří Činčura
> Independent IT Specialist
>
>
> --
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

--
Monitor Your Dynamic Infrastructure at Any Scale With Datadog!
Get real-time metrics from all of your servers, apps and tools
in one place.
SourceForge users - Click here to start your Free Trial of Datadog now!
http://pubads.g.doubleclick.net/gampad/clk?id=241902991=/4140
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Multithread insert

2015-09-20 Thread Геннадий Забула

I don't think that the issue in the .NET provider. It just forwards
options to fbembed.dll for transactions it just TPB. And do it right.
The problem is in the engine, I've retested it with C API and the
behavior is similar to observed. My case is similar to the described
here: http://www.firebirdfaq.org/faq109/. With just one difference:
values field updated to is not depends on each other. I just update
the same field from several threads. I've crutched this with skipping
the exception because consistency is not a concern for this field. But
IMO, there is an issue in the engine.

On 20 September 2015 at 14:03, LtColRDSChauhan  wrote:
>> Message: 3
>> Date: Thu, 17 Sep 2015 19:56:20 +0200
>> From: Ji?? ?in?ura 
>> Subject: Re: [Firebird-net-provider] Multithread insert
>> To: "For users and developers of the Firebird .NET providers"
>> 
>> Message-ID:
>> <1442512580.927417.386542585.69829...@webmail.messagingengine.com>
>> Content-Type: text/plain; charset="UTF-8"
>>
>> On Thu, Sep 17, 2015, at 17:57,  ?? wrote:
>> > Narrowed the problem. The cause is a multithreaded update of the same
>> > record field. Transactions, as I said don't dispatch the issue.
>>
>> The advice is simple. Don't update same record (not only in .NET;
>> anywhere, anytool). :D
>>
> Transactions issues in .NET Provider  need to be addressed.
> Multithread/parallel programming and transactions enable correct
> exploitation of multicore machines.  I understand Firebird 3.0 takes major
> advances in this area.
>
>
> --
>
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

--
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Multithread insert

2015-09-20 Thread Геннадий Забула

> I don't think there is even an issue here
After taking another view at what happens, I don't think either.

The exception is thrown when similar updates are made for one field,
from several threads, when NO_WAIT specified. Only this flag causes it
to throw. No matter if you specify flags consistent or concurrency. As
I understood this is expected behavior.

NO_WAIT flag is set for any IsolationLevel specified for a
FbTransaction. The behavior of such updates is different from MSSQL
provider (it waits) and discovering this was a kind frustrating and
resulted in this thread.


On 20 September 2015 at 16:30, Alexander Muylaert-Gelein
 wrote:
> I don't think there is even an issue here.  inside two different
> transactions, you simply cannot update the same record.  Who would win in
> the end and what would be the end result.  I'm pretty sure if you can solve
> this, the firebird team would gladly implement this.
>
> a
>
>
>> Date: Sun, 20 Sep 2015 14:12:25 +0300
>> From: zabulu...@gmail.com
>> To: firebird-net-provider@lists.sourceforge.net
>
>> Subject: Re: [Firebird-net-provider] Multithread insert
>>
>> I don't think that the issue in the .NET provider. It just forwards
>> options to fbembed.dll for transactions it just TPB. And do it right.
>> The problem is in the engine, I've retested it with C API and the
>> behavior is similar to observed. My case is similar to the described
>> here: http://www.firebirdfaq.org/faq109/. With just one difference:
>> values field updated to is not depends on each other. I just update
>> the same field from several threads. I've crutched this with skipping
>> the exception because consistency is not a concern for this field. But
>> IMO, there is an issue in the engine.
>>
>> On 20 September 2015 at 14:03, LtColRDSChauhan  wrote:
>> >> Message: 3
>> >> Date: Thu, 17 Sep 2015 19:56:20 +0200
>> >> From: Ji?? ?in?ura 
>> >> Subject: Re: [Firebird-net-provider] Multithread insert
>> >> To: "For users and developers of the Firebird .NET providers"
>> >> 
>> >> Message-ID:
>> >> <1442512580.927417.386542585.69829...@webmail.messagingengine.com>
>> >> Content-Type: text/plain; charset="UTF-8"
>> >>
>> >> On Thu, Sep 17, 2015, at 17:57,  ?? wrote:
>> >> > Narrowed the problem. The cause is a multithreaded update of the same
>> >> > record field. Transactions, as I said don't dispatch the issue.
>> >>
>> >> The advice is simple. Don't update same record (not only in .NET;
>> >> anywhere, anytool). :D
>> >>
>> > Transactions issues in .NET Provider need to be addressed.
>> > Multithread/parallel programming and transactions enable correct
>> > exploitation of multicore machines. I understand Firebird 3.0 takes
>> > major
>> > advances in this area.
>> >
>> >
>> >
>> > --
>> >
>> > ___
>> > Firebird-net-provider mailing list
>> > Firebird-net-provider@lists.sourceforge.net
>> > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>> >
>>
>>
>> --
>> ___
>> Firebird-net-provider mailing list
>> Firebird-net-provider@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
> --
>
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

--
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Multithread insert

2015-09-17 Thread Геннадий Забула

Narrowed the problem. The cause is a multithreaded update of the same
record field. Transactions, as I said don't dispatch the issue.

On 17 September 2015 at 17:38, Геннадий Забула <zabulu...@gmail.com> wrote:
> lock conflict on no wait transaction
> Acquire lock for relation () failed
> ---> FirebirdSql.Data.Common.IscException: lock conflict on no wait
> transaction
> Acquire lock for relation () failed
>
> On 17 September 2015 at 17:38, Геннадий Забула <zabulu...@gmail.com> wrote:
>> I was wrong about IsolationLevel. If use Isolationlevel.Serializable
>> exception message changes to:
>>
>> On 17 September 2015 at 17:32, Геннадий Забула <zabulu...@gmail.com> wrote:
>>> I'm trying to insert to database multiple items at once via following code:
>>>
>>> using (var transaction =
>>> act.Database.BeginTransaction(System.Data.IsolationLevel.RepeatableRead))
>>> {
>>>   // inserting and updating several related entities.
>>>   act.SaveChanges() // Throws exception
>>> }
>>>
>>> Exception message:
>>> lock conflict on no wait transaction
>>> deadlock
>>> update conflicts with concurrent update
>>> concurrent transaction number is 665378
>>>
>>> A problematic query that throws is about updating the entity, that all
>>> my queries update.
>>>
>>> Using any other IsolationLevel doesn't affect the behavior.

--
Monitor Your Dynamic Infrastructure at Any Scale With Datadog!
Get real-time metrics from all of your servers, apps and tools
in one place.
SourceForge users - Click here to start your Free Trial of Datadog now!
http://pubads.g.doubleclick.net/gampad/clk?id=241902991=/4140
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Multithread insert

2015-09-17 Thread Геннадий Забула

lock conflict on no wait transaction
Acquire lock for relation () failed
---> FirebirdSql.Data.Common.IscException: lock conflict on no wait
transaction
Acquire lock for relation () failed

On 17 September 2015 at 17:38, Геннадий Забула <zabulu...@gmail.com> wrote:
> I was wrong about IsolationLevel. If use Isolationlevel.Serializable
> exception message changes to:
>
> On 17 September 2015 at 17:32, Геннадий Забула <zabulu...@gmail.com> wrote:
>> I'm trying to insert to database multiple items at once via following code:
>>
>> using (var transaction =
>> act.Database.BeginTransaction(System.Data.IsolationLevel.RepeatableRead))
>> {
>>   // inserting and updating several related entities.
>>   act.SaveChanges() // Throws exception
>> }
>>
>> Exception message:
>> lock conflict on no wait transaction
>> deadlock
>> update conflicts with concurrent update
>> concurrent transaction number is 665378
>>
>> A problematic query that throws is about updating the entity, that all
>> my queries update.
>>
>> Using any other IsolationLevel doesn't affect the behavior.

--
Monitor Your Dynamic Infrastructure at Any Scale With Datadog!
Get real-time metrics from all of your servers, apps and tools
in one place.
SourceForge users - Click here to start your Free Trial of Datadog now!
http://pubads.g.doubleclick.net/gampad/clk?id=241902991=/4140
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] [FB-Tracker] Created: (DNET-631) Support for BOOLEAN in FB3

2015-09-14 Thread Геннадий Забула

How should this be implemented?
I could take a look at this in the week.

On 14 September 2015 at 17:06, Jiri Cincura (JIRA)
 wrote:
> Support for BOOLEAN in FB3
> --
>
>  Key: DNET-631
>  URL: http://tracker.firebirdsql.org/browse/DNET-631
>  Project: .NET Data provider
>   Issue Type: Sub-task
>   Components: ADO.NET Provider, DDEX Provider, Entity Framework 
> support
> Affects Versions: 4.8.0.0
> Reporter: Jiri Cincura
> Assignee: Jiri Cincura
>
>
>
>
> --
> 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 mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

--
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Migrations

2015-08-30 Thread Геннадий Забула

2. According to this: https://msdn.microsoft.com/en-us/data/dn456841.aspx there 
might be problem with ContextKey field because it is PK. But there is a 
workaround that allows to decrease size of the field. Don't know why this field 
need to be so long.

Do I need to fill tracker issues for described problems to track progress?

-Original Message-
From: Jiří Činčura j...@cincura.net
Sent: ‎8/‎30/‎2015 9:08 AM
To: For users and developers of the Firebird .NET providers 
firebird-net-provider@lists.sourceforge.net
Subject: Re: [Firebird-net-provider] Migrations

1. I think table names need to be preserved. Developer is reponsible for 
checking for that constraint. The name is defined. But I meant generated names, 
like PK name (if not specified). It's same for column names etc. It would be 
pretty confusing to later open that database and see just weird characters.
2. AFAIK you still need 16k database to be able to make PK (or maybe just 8k is 
enough, not 4k for sure).  
4. OK, that might be bug. 

-- 
Mgr. Jiří Činčura
Independent IT Specialist
--
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
--
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Migrations

Can it be merged to master and released as Beta so this won't be used by
everybody?


On Saturday, 29 August 2015, Jiří Činčura j...@cincura.net wrote:

 I do.



 I’m still waiting for EF 6.2 as it contains some fixes we need for proper
 error reporting. It’s already fixed in sources, but not yet released. It
 works but people would complain and given how much stupid questions I get
 about DDEX, I’m not going to do that.



 --

 Mgr. Jiří Činčura

 Independent IT Specialist



 *From:* Геннадий Забула [mailto:zabulu...@gmail.com
 javascript:_e(%7B%7D,'cvml','zabulu...@gmail.com');]
 *Sent:* Saturday, August 29, 2015 5:18 PM
 *To:* For users and developers of the Firebird .NET providers 
 firebird-net-provider@lists.sourceforge.net
 javascript:_e(%7B%7D,'cvml','firebird-net-provider@lists.sourceforge.net');
 
 *Subject:* [Firebird-net-provider] Migrations



 What is the current status of migrations? Last change was 8 month. Do you
 plan to merge it to master?

 We are using branch for almost half year in our project and can give some
 feedback/fixes. And want to port them to upstream.

--
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Migrations

Ok. For now we had such issues:
1. Long names of tables causes foreign key script creation fail with error 
Name exceeded implementation limitation. This caused by 31 characters 
limitation to almost anything not only FK. We crutched this with hashing names  
 with base64 convert. Ugly but works.
2. Second it is drop from support databases with pages less than 16384 because 
of another impl. limitation for max string field length. This breaks creating 
MigrationHistory table. We didn't fixed this, because started using separate 
database. But in near future our previous database would also need to have 
migrations. I think this can be crutched to use blob field only for Model field 
of this table.
3. Issue with sequence generators. Maybe you remember discussion about this on 
github. Looks like I've found good place to configurate particular field. It is 
in OnModelCreating Properties().Configure(x=x.AddAnotation()) for property. 
There user can specify what sequence behavior does he need or provide custom.

Today I tried to add tests for all this to repo but found out that we need to 
add separate test infrastructure for EF tests.

-Original Message-
From: Jiří Činčura j...@cincura.net
Sent: ‎8/‎29/‎2015 7:29 PM
To: For users and developers of the Firebird .NET providers 
firebird-net-provider@lists.sourceforge.net
Subject: Re: [Firebird-net-provider] Migrations

Also if you have some feedback you can discuss it here ahead of time. No 
problem with that.

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

--
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
--
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] fbstreambackup: free disk space exhausted

I'm not sure, but can you check disk space on the remote server where
database is placed?

On Saturday, 29 August 2015, Parzival parzival1...@gmx.at wrote:

 Hallo,



 I try to move from calling gbak as an external tool for backup and use
 fbstreambackup instead.



 Unfortunatly I get an error message free disk space exhausted, which is
 confusing. The disk has enough space to store the backup file. For that
 reason I am guessing that there is something wrong with the way I call the
 backup.



 This is the code (in vulcan.net):



 // declare variables

 LOCAL fsb AS FbStreamingBackup

 LOCAL fs AS System.IO.FileStream



 // create new backup

 fsb := FbStreamingBackup{ sb:ToString() }

 fs := System.IO.FileStream{D:\temp\test.gbk, FileMode.Create }

 fsb:OutputStream := fs



 fsb:Execute() // It fails here



 Can please somebody point out what I am missing here? Maybe the filestream
 is not correct assign to FbStreamingBackup…



 Thanks



 Niko

--
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

[Firebird-net-provider] Migrations

What is the current status of migrations? Last change was 8 month. Do you
plan to merge it to master?

We are using branch for almost half year in our project and can give some
feedback/fixes. And want to port them to upstream.
--
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Migrations

1. I've used hashes from names to avoid dictionaries for mapping name-guid.
2. I think it was about Model field. More precise error I'll tell tomorrow when 
PC will be available. I don't want to constraint page size, because changing 
page size for existing databases is done only via backup-restore AFAIK. In case 
of several GB dbs it's not an option.
3. Yes. Default behavior maybe several pre defined and possibility to provide 
custom.
4. One more issue I remembered. Dbs created with Initial migration and via 
CreateDatabaseIfNotExists have different underlying scheme in part of names. I 
think this should be also fixed.

-Original Message-
From: Jiří Činčura j...@cincura.net
Sent: ‎8/‎29/‎2015 10:08 PM
To: For users and developers of the Firebird .NET providers 
firebird-net-provider@lists.sourceforge.net
Subject: Re: [Firebird-net-provider] Migrations

 1. Long names of tables causes foreign key script creation fail with error 
 Name exceeded implementation limitation. This caused by 31 characters 
 limitation to almost anything not only FK. We crutched this with hashing 
 names   with base64 convert. Ugly but works.

Maybe we can, in case it's longer than 31 characters, simply use GUID. Not nice 
either, though.

 2. Second it is drop from support databases with pages less than 16384 
 because of another impl. limitation for max string field length. This breaks 
 creating MigrationHistory table. We didn't fixed this, because started using 
 separate database. But in near future our previous database would also need 
 to have migrations. I think this can be crutched to use blob field only for 
 Model field of this table.

You mean the PK on MigrationHistory? We can specify 16k page size as a 
requirement. There's not much to invent on the PK.

 3. Issue with sequence generators. Maybe you remember discussion about this 
 on github. Looks like I've found good place to configurate particular field. 
 It is in OnModelCreating Properties().Configure(x=x.AddAnotation()) for 
 property. There user can specify what sequence behavior does he need or 
 provide custom.

True. And with custom convention it's not even needed to specify it explicitly 
for every column.

 Today I tried to add tests for all this to repo but found out that we need to 
 add separate test infrastructure for EF tests.

There's few tests I wrote. Using CF as that's easy to set up. But maybe the 
migrations would need deeper setup.

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


--
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
--
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] DNET-532

Fresh PR for this issue:
https://github.com/cincuranet/FirebirdSql.Data.FirebirdClient/pull/35

On 27 August 2015 at 07:58, Jiří Činčura j...@cincura.net wrote:
 One more question about string.Equals. Comparison type used in IndexOf
 calls is StringComparison.CurrentCultureIgnoreCase. My question why this
 used instead of OrdinalIgnoreCase?
 My current optimization, including StringComparison change decreased
 timings to 22 (names) vs 6 (indexes) seconds.

 Because of national characters. Somebody might use these in parameter name. 
 Although it's pretty weird, I had similar issue in DDEX.
 --
 Mgr. Jiří Činčura
 Independent IT Specialist


 --
 ___
 Firebird-net-provider mailing list
 Firebird-net-provider@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

--
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] DNET-532

2015-08-26 Thread Геннадий Забула

About Equals call I'm not sure it can be optimized somehow.
But decreasing cost of NormalizeParameterName should significantly
reduce overall case execution time.

On 26 August 2015 at 20:27, Геннадий Забула zabulu...@gmail.com wrote:
 I've profiled case and found out next hot paths:

 get_Item: 54,56%
 1. 30.30%
 return this.parameters.FindIndex((PredicateFbParameter) (x =
 x.InternalParameterName.Equals(normalizedParameterName,
 StringComparison.CurrentCultureIgnoreCase)));
 Equals call
 2. 21,51%
 internal static string NormalizeParameterName(string parameterName)
 {
   if (string.IsNullOrEmpty(parameterName) || 
 parameterName.StartsWith(@))
 return parameterName;
   return string.Format(@{0}, (object) parameterName);
 }
 This method also can be optmized.
 StartsWith - parameterName[0] == '@'
 string.Format - string.Concat(@, parameterName)

 On 26 August 2015 at 16:45, Jiří Činčura j...@cincura.net wrote:
 Can you share profiler report?

 There's a test app attached to the ticket. It clearly shows the hot spot. I 
 can share only times (from my machine).

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


 --
 ___
 Firebird-net-provider mailing list
 Firebird-net-provider@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

--
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] DNET-532

2015-08-26 Thread Геннадий Забула

Before doing any optimizations, there should be done some profiling to
find hot paths in particular cases.
I think need to start with sample that demonstrates the issue. After
that start running it in a loop under profiler.


On 26 August 2015 at 15:39, Jiří Činčura j...@cincura.net wrote:
 Hi *,

 May I bring to your attention the 
 http://tracker.firebirdsql.org/browse/DNET-532 ? I'd like to know others' 
 view as well.

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

 --
 ___
 Firebird-net-provider mailing list
 Firebird-net-provider@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

--
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] DNET-532

2015-08-26 Thread Геннадий Забула

Can you share profiler report?

On 26 August 2015 at 16:05, Jiří Činčura j...@cincura.net wrote:
 Before doing any optimizations, there should be done some profiling to
 find hot paths in particular cases.
 I think need to start with sample that demonstrates the issue. After that
 start running it in a loop under profiler.

 Done that already.

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


 --
 ___
 Firebird-net-provider mailing list
 Firebird-net-provider@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

--
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Handling of boolean in .Net Provider 4.6.2

2015-06-26 Thread Геннадий Забула

We are using SMALLINT type in our project.
FB EF provider also generates tables with SMALLINT fields for
code-first class fields.

On 26 June 2015 at 14:49, Christian Waldmann
christian.waldm...@rte-ag.ch wrote:
 I am using Firebird 2.5.4, superServer and embedded, Visula Studio 2013,
 .Net Framework 4.5.1, .Net Provider 4.6.2

 //==
 =
 I have defined a table with CyclePassed CHAR(1) to store a boolean result

 CREATE TABLE SampleSummaries (
 UniqueIdBIGINT DEFAULT 0 NOT NULL,
 EndTestRunIdBIGINT NOT NULL,
 Cycle   BIGINT NOT NULL,
 LoadPressureFLOAT,
 LoadPressureMin FLOAT,
 LoadPressureMax FLOAT,
 ShutoffPressure FLOAT,
 ShutoffPressureMin  FLOAT,
 ShutoffPressureMax  FLOAT,
 TravelTime  FLOAT,
 TravelTimeMin   FLOAT,
 TravelTimeMax   FLOAT,
 CyclePassed CHAR(1)
 );


 //==
 =
 // access to table from C#

 bool cyclePassed = true;
 FbCommand command = new FbCommand();

 command.CommandText =
 INSERT INTO \SampleSummaries\ ( +
   \EndTestRunId\, \Cycle\,  +
   \LoadPressure\, \LoadPressureMin\, \LoadPressureMax\,  +
   \ShutoffPressure\, \ShutoffPressureMin\, \ShutoffPressureMax\,
  +
   \TravelTime\, \TravelTimeMin\, \TravelTimeMax\,
 \CyclePassed\ +
   ) VALUES  (@EndTestRunId, @Cycle,  +
   @LoadPressure, @LoadPressureMin, @LoadPressureMax,  +
   @ShutoffPressure, @ShutoffPressureMin, @ShutoffPressureMax, +
   @TravelTime, @TravelTimeMin, @TravelTimeMax, @CyclePassed );

 command.Connection = samplesTableAdapter.Connection;
 command.Transaction = transaction;

 command.Parameters.Add(@EndTestRunId, FbDbType.BigInt).Value = channelId;
 ...

 // PROBLEM A:
 
 ==
 // works with stand alone server,
 // but SQL error string conversion error '49'
 // {Remark: 49 is the decimal ASCII code of '1'}
 command.Parameters.Add(@CyclePassed, FbDbType.Boolean).Value = cyclePassed
 ? '1' : '0';

 // PROBLEM B:
 
 ==
 // works with embedded server,
 // but string truncation error with stand alone server
 command.Parameters.Add(@CyclePassed, FbDbType.Boolean).Value =
 cyclePassed;

 // REMARK:
 
 ==
 // works with embedded server and standalone server Firebird 2.5.3, with
 .Net Provider 2.0, .Net Framework 2.0, Visual Studio 2008
 command.Parameters.Add(@CyclePassed, FbDbType.Boolean).Value =
 cyclePassed;

 // QUESTION
 
 
 Is this a bug or am I missing the correct usage of storing a 'bool'?

 Happy coding
 Christian Waldmann


 --
 Monitor 25 network devices or servers for free with OpManager!
 OpManager is web-based network management software that monitors
 network devices and physical  virtual servers, alerts via email  sms
 for fault. Monitor 25 devices for free with no restriction. Download now
 http://ad.doubleclick.net/ddm/clk/292181274;119417398;o
 ___
 Firebird-net-provider mailing list
 Firebird-net-provider@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

--
Monitor 25 network devices or servers for free with OpManager!
OpManager is web-based network management software that monitors 
network devices and physical  virtual servers, alerts via email  sms 
for fault. Monitor 25 devices for free with no restriction. Download now
http://ad.doubleclick.net/ddm/clk/292181274;119417398;o
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] OutOfMemoryException

2015-06-19 Thread Геннадий Забула

can you make a dump of your test-process in a moment of OOM exception
(if there is no sensitive information of course), so we can take a
look what and where had leaked.

On 19 June 2015 at 08:35, Alexander Muylaert-Gelein
amuylaert_gel...@hotmail.com wrote:
 You might already have expected this.  I don't think Jiri is aware of any
 leaks inside the provider, otherwise they would have been resolved.

 Can you make a reproducible scenario?

 thanks

 a

 From: lo...@nucleo.co.za
 To: firebird-net-provider@lists.sourceforge.net
 Date: Thu, 18 Jun 2015 16:34:36 +0200
 Subject: [Firebird-net-provider] OutOfMemoryException


 Hello, I have an application that runs on .NET 4.5.1 against FB 2.5.2. Up
 to
 now I have been using FirebirdClient 2.0.1. I have just migrated to using
 FirebirdClient 4.6.2 with the view of getting some performance gains.

 When I run my application's automated test suite of around 1500 tests
 using
 client 2.0.1, the test suite runs through. However, when I run the test
 suite against client 4.6.2, I get OutOfMemoryException at around 80% mark.

 The first question is whether client 4.6.2 will give me performance gains.
 Second question is why would I run out of memory with 4.6.2 and not 2.0.1?

 Thanks
 Louis



 --
 ___
 Firebird-net-provider mailing list
 Firebird-net-provider@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

 --

 ___
 Firebird-net-provider mailing list
 Firebird-net-provider@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/firebird-net-provider


--
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Setting LockTables in FbTransactionOptions with string[] of Tables to Lock

2015-06-16 Thread Геннадий Забула

Use Linq^
string[] tables = 

LockTables = tables.ToDictionary(x=x, FbTransactionBehavior.LockRead
| FbTransactionBehavior.Exclusive)
But this will cause all table to have same FbTransactionBehavior.

On Tue, Jun 16, 2015 at 7:50 AM, Jiří Činčura j...@cincura.net wrote:
 You can’t use string[]. You need to specify the locking, hence the 
 IDictionary.

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

 --
 ___
 Firebird-net-provider mailing list
 Firebird-net-provider@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

--
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] FbBatchExecution

2015-06-16 Thread Геннадий Забула

you can also add helper method Add(FbScript scrip) to support current ctor.


On Tue, Jun 16, 2015 at 7:57 AM, Jiří Činčura j...@cincura.net wrote:
 Thinking more about it. Maybe the ctor should be only with optional 
 FbConnection and the rest can be done via SqlStatements property. Then it's 
 not tied to FbScript at all.

 Maybe then the FbStatementCollection can have a simple helper method 
 Add(FbStatementCollection) (or something like that). Then it would look 
 like:

 var batchExecution = new FbBatchExceution();
 batchExecution.Statements.Add(script.Results); //maybe rename Results  
 Statements???
 batchExecution.Execute();

 Looks good to me.

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

 -Original Message-
 From: Jiří Činčura
 Sent: Wednesday, June 10, 2015 3:36 PM
 To: firebird-net-provider@lists.sourceforge.net
 Subject: FbBatchExecution

 Hi guys,

 Looking at FbBatchExecution's ctor I don't see a reason why it takes
 FbScript. It should rather be FbStatementCollection I think. The
 FbBatchExecution is doing nothing with the FbScript. It just needs
 commands.

 What do you think? I would add another overload to ctor and make the one
 with FbScript obsolete.

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

 --
 ___
 Firebird-net-provider mailing list
 Firebird-net-provider@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

--
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] FbBatchExecution

2015-06-10 Thread Геннадий Забула

I don't use this. Though, propose looks good to me.

On Wed, Jun 10, 2015 at 6:37 PM, Ivan Arabadzhiev
intelru...@unrealsoft.net wrote:
 I did once suggest it should take raw String, a long time ago (did a lot of
 magic to embed text files to run...). Still think it has uses, but I've
 mostly moved away from .net now

 2015-06-10 16:36 GMT+03:00 Jiří Činčura j...@cincura.net:

 Hi guys,

 Looking at FbBatchExecution's ctor I don't see a reason why it takes
 FbScript. It should rather be FbStatementCollection I think. The
 FbBatchExecution is doing nothing with the FbScript. It just needs commands.

 What do you think? I would add another overload to ctor and make the one
 with FbScript obsolete.

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


 --
 ___
 Firebird-net-provider mailing list
 Firebird-net-provider@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/firebird-net-provider



 --

 ___
 Firebird-net-provider mailing list
 Firebird-net-provider@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/firebird-net-provider


--
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Random crashes in Finalizers

2015-04-09 Thread Геннадий Забула

That's why I think my suggested changes won't impact most users of Dnet
provider.

On Thursday, April 9, 2015, Alexander Muylaert-Gelein 
amuylaert_gel...@hotmail.com wrote:

 Hi

 No, I have to admit I've abondoned EF long time ago.  Too much magic
 behind the scenes for me.  I couldn't predict the behavior of EF and that
 was too hard to manage.  I also don't use embedded.  I have a lot of pooled
 connections on cs and ss and normal stay open long connections on mostly
 ss.  For mapping I prefer LLBLGEN pro, because it is dumb and thus does
 what I want and nothing extra.

 thanks

 a

  Date: Wed, 8 Apr 2015 18:16:36 +0300
  From: zabulu...@gmail.com
 javascript:_e(%7B%7D,'cvml','zabulu...@gmail.com');
  To: firebird-net-provider@lists.sourceforge.net
 javascript:_e(%7B%7D,'cvml','firebird-net-provider@lists.sourceforge.net');
  Subject: Re: [Firebird-net-provider] Random crashes in Finalizers
 
  We use FbConnection in EF. EF does not always calls Dispose on classes
  provided by the FB Data provider.
  Alexander, what server do you use? For example, we use embedded
  configuration in our production. And code of the Fes* namespace
  doesn't work well in finalizers as we see.
 
  On Wed, Apr 8, 2015 at 6:12 PM, Alexander Muylaert-Gelein
  amuylaert_gel...@hotmail.com
 javascript:_e(%7B%7D,'cvml','amuylaert_gel...@hotmail.com'); wrote:
   Hi
  
   I intensively use firebird and provider... I always use the dispose
 method
   (using) and I don't depend on the GC for this. I never had any of the
   exceptions refererred to.
  
   Wouldn't it be better *not* to depend on something horrible as the gc
 for
   something as important as your db connectivity? Isn't it better to
 prevent
   then to cure?
  
   thanks
  
   a
  
  
   Date: Wed, 8 Apr 2015 18:00:26 +0300
   From: zabulu...@gmail.com
 javascript:_e(%7B%7D,'cvml','zabulu...@gmail.com');
   To: firebird-net-provider@lists.sourceforge.net
 javascript:_e(%7B%7D,'cvml','firebird-net-provider@lists.sourceforge.net');
   Subject: [Firebird-net-provider] Random crashes in Finalizers
  
  
   Hello everyone.
  
   I want to discuss changes in finalizers regarding a couple of crashes
   we experience in our FB using.
  
   Issues in tracker:
   http://tracker.firebirdsql.org/browse/DNET-582
   http://tracker.firebirdsql.org/browse/DNET-597
  
   As for 582 we have discussion in PR that crutches it on GitHub:
   https://github.com/cincuranet/FirebirdSql.Data.FirebirdClient/pull/19
  
   As for 597 try...catch doesn't work, it is a more complicated problem.
  
   My suggestion is to refactor Dispose/Finalizer methods to not use
   managed objects which might be already disposed.
  
   Maybe anyone have another thought?
   JIri, what do you think?
  
  
  
 --
   BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
   Develop your own process in accordance with the BPMN 2 standard
   Learn Process modeling best practices with Bonita BPM through live
   exercises
   http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual-
   event?utm_
   source=Sourceforge_BPM_Camp_5_6_15utm_medium=emailutm_campaign=VA_SF
   ___
   Firebird-net-provider mailing list
   Firebird-net-provider@lists.sourceforge.net
 javascript:_e(%7B%7D,'cvml','Firebird-net-provider@lists.sourceforge.net');
   https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
  
  
 --
   BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
   Develop your own process in accordance with the BPMN 2 standard
   Learn Process modeling best practices with Bonita BPM through live
 exercises
   http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual-
 event?utm_
   source=Sourceforge_BPM_Camp_5_6_15utm_medium=emailutm_campaign=VA_SF
   ___
   Firebird-net-provider mailing list
   Firebird-net-provider@lists.sourceforge.net
 javascript:_e(%7B%7D,'cvml','Firebird-net-provider@lists.sourceforge.net');
   https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
  
 
 
 --
  BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
  Develop your own process in accordance with the BPMN 2 standard
  Learn Process modeling best practices with Bonita BPM through live
 exercises
  http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual-
 event?utm_
  source=Sourceforge_BPM_Camp_5_6_15utm_medium=emailutm_campaign=VA_SF
  ___
  Firebird-net-provider mailing list
  Firebird-net-provider@lists.sourceforge.net
 javascript:_e(%7B%7D,'cvml','Firebird-net-provider@lists.sourceforge.net');
  https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Random crashes in Finalizers

2015-04-08 Thread Геннадий Забула

We use FbConnection in EF. EF does not always calls Dispose on classes
provided by the FB Data provider.
Alexander, what server do you use? For example, we use embedded
configuration in our production. And code of the Fes* namespace
doesn't work well in finalizers as we see.

On Wed, Apr 8, 2015 at 6:12 PM, Alexander Muylaert-Gelein
amuylaert_gel...@hotmail.com wrote:
 Hi

 I intensively use firebird and provider... I always use the dispose method
 (using) and I don't depend on the GC for this.  I never had any of the
 exceptions refererred to.

 Wouldn't it be better *not* to depend on something horrible as the gc for
 something as important as your db connectivity?  Isn't it better to prevent
 then to cure?

 thanks

 a


 Date: Wed, 8 Apr 2015 18:00:26 +0300
 From: zabulu...@gmail.com
 To: firebird-net-provider@lists.sourceforge.net
 Subject: [Firebird-net-provider] Random crashes in Finalizers


 Hello everyone.

 I want to discuss changes in finalizers regarding a couple of crashes
 we experience in our FB using.

 Issues in tracker:
 http://tracker.firebirdsql.org/browse/DNET-582
 http://tracker.firebirdsql.org/browse/DNET-597

 As for 582 we have discussion in PR that crutches it on GitHub:
 https://github.com/cincuranet/FirebirdSql.Data.FirebirdClient/pull/19

 As for 597 try...catch doesn't work, it is a more complicated problem.

 My suggestion is to refactor Dispose/Finalizer methods to not use
 managed objects which might be already disposed.

 Maybe anyone have another thought?
 JIri, what do you think?


 --
 BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
 Develop your own process in accordance with the BPMN 2 standard
 Learn Process modeling best practices with Bonita BPM through live
 exercises
 http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual-
 event?utm_
 source=Sourceforge_BPM_Camp_5_6_15utm_medium=emailutm_campaign=VA_SF
 ___
 Firebird-net-provider mailing list
 Firebird-net-provider@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

 --
 BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
 Develop your own process in accordance with the BPMN 2 standard
 Learn Process modeling best practices with Bonita BPM through live exercises
 http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
 source=Sourceforge_BPM_Camp_5_6_15utm_medium=emailutm_campaign=VA_SF
 ___
 Firebird-net-provider mailing list
 Firebird-net-provider@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/firebird-net-provider


--
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15utm_medium=emailutm_campaign=VA_SF
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

[Firebird-net-provider] Random crashes in Finalizers

2015-04-08 Thread Геннадий Забула

Hello everyone.

I want to discuss changes in finalizers regarding a couple of crashes
we experience in our FB using.

Issues in tracker:
http://tracker.firebirdsql.org/browse/DNET-582
http://tracker.firebirdsql.org/browse/DNET-597

As for 582 we have discussion in PR that crutches it on GitHub:
https://github.com/cincuranet/FirebirdSql.Data.FirebirdClient/pull/19

As for 597 try...catch doesn't work, it is a more complicated problem.

My suggestion is to refactor Dispose/Finalizer methods to not use
managed objects which might be already disposed.

Maybe anyone have another thought?
JIri, what do you think?

--
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15utm_medium=emailutm_campaign=VA_SF
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Make FbNetProvider classes unseal

2015-01-17 Thread Геннадий Забула

have you tried real profiler tools? i.e. studio performance analyzer
or its analogues?

On Fri, Jan 16, 2015 at 6:24 PM, Lukáš Vykydal l.vyky...@gmail.com wrote:
 Well thank you for sugestions.

 After some thinking we'll use soultion with wrapper classes.

 Thank for your time

 Lukáš Vykydal
 Dne 1/16/2015 v 11:24 AM Jiří Činčura napsal(a):
 Well, you can do simple:
 StartTiming();
 Execute();
 LogElapsed();

 Of if you want to do more fancy solution you should wrap all the FbXxx 
 classes into wrappers. That's how other layers work (profilers, O/Rs, ...).



 --
 New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
 GigeNET is offering a free month of service with a new server in Ashburn.
 Choose from 2 high performing configs, both with 100TB of bandwidth.
 Higher redundancy.Lower latency.Increased capacity.Completely compliant.
 http://p.sf.net/sfu/gigenet
 ___
 Firebird-net-provider mailing list
 Firebird-net-provider@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

--
New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
GigeNET is offering a free month of service with a new server in Ashburn.
Choose from 2 high performing configs, both with 100TB of bandwidth.
Higher redundancy.Lower latency.Increased capacity.Completely compliant.
http://p.sf.net/sfu/gigenet
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] EF Migrations

 Your configuration for context needs to derive from FbDbConfiguration. So
far there's no better solution. The migrations are run in serializable
transaction and you need to insert into __MigrationHistory right after
creation. Disaster.

I'm using the same Context for both MSSQL and Firebird, how deriving from
FbDbConfiguration can affect MSSQL code path? Can we override this somehow
just in Firebird provider?

 Yeah. Firebird's 31 characters it's goign to be hard to beat. I can
shorten the string, but that will increase collisions. Maybe we can create
- similar to generators - open ended method that anybody can override if
needed.

I like this.


2014-12-30 10:06 GMT+02:00 Jiří Činčura j...@cincura.net:

 Your configuration for context needs to derive from FbDbConfiguration. So
 far there's no better solution. The migrations are run in serializable
 transaction and you need to insert into __MigrationHistory right after
 creation. Disaster.

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

 From: Геннадий Забула [mailto:zabulu...@gmail.com]
 Sent: Tuesday, December 30, 2014 8:19 AM
 To: For users and developers of the Firebird .NET providers
 Subject: Re: [Firebird-net-provider] EF Migrations

 Fall in next query:
 EXECUTE BLOCK
 AS
 BEGIN
 EXECUTE STATEMENT
 'CREATE TABLE __MigrationHistory (
 MigrationId VARCHAR(150) NOT NULL,
 ContextKey VARCHAR(300) NOT NULL,
 Model BLOB SUB_TYPE BINARY NOT NULL,
 ProductVersion VARCHAR(32) NOT NULL
 )'
 WITH AUTONOMOUS TRANSACTION;
 END
 Parameters:
 With next exception:
 unsuccessful metadata update
 STORE RDB$RELATIONS failed
 lock conflict on no wait transaction

 2014-12-30 9:03 GMT+02:00 Геннадий Забула zabulu...@gmail.com:
 Here are my issues/suggestions:
 1. Generator ID. One for all is bad options for me. I'll reimplement it to
 have one for table.
 2. Couple of errors in creating Constraints or Indexes:
 unsuccessful metadata update
 Name longer than database column size
 Constraint names are longer than it can be in system tables: ALTER TABLE
 ClientGroupAlerts ADD CONSTRAINT
 FK_ClientGroupAlerts_ClientGroups_ClientGroup_Id. I've figured that
 maximum name is 31 (!!!) characters. I've implemented SHA1 (maybe I will
 replace it with something faster) hashing of string names.

 Will write about further progress.

 2014-12-20 8:32 GMT+02:00 Mercea Paul paul.mer...@almexa.ro:
 On 2014.11.06 3:06 PM, Jiří Činčura wrote:
  Hi *,
 
  Anybody here willing to give EF Migrations a try? I'm getting close to
 first implementation.
 
 I'm trying to add support for Firebird db for existing app on SQL
 Express, and, first run of the application was with no errors and
 created the database.
 I'll going to try migrations steps and give feedback.

 Thanks Jiri

 Paul MERCEA
 ___
 E-mail: paul.mer...@almexa.ro
 ___



 --
 Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
 from Actuate! Instantly Supercharge Your Business Reports and Dashboards
 with Interactivity, Sharing, Native Excel Exports, App Integration  more
 Get technology previously reserved for billion-dollar corporations, FREE

 http://pubads.g.doubleclick.net/gampad/clk?id=164703151iu=/4140/ostg.clktrk
 ___
 Firebird-net-provider mailing list
 Firebird-net-provider@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/firebird-net-provider



 --
 Dive into the World of Parallel Programming! The Go Parallel Website,
 sponsored by Intel and developed in partnership with Slashdot Media, is
 your
 hub for all things parallel software development, from weekly thought
 leadership blogs to news, videos, case studies, tutorials and more. Take a
 look and join the conversation now. http://goparallel.sourceforge.net
 ___
 Firebird-net-provider mailing list
 Firebird-net-provider@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

--
Dive into the World of Parallel Programming! The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] EF Migrations

I've found out that there is the static class:
System.Data.Entity.Infrastructure.Interception.DbInterception, which adds
IDbInterceptor,

2014-12-30 11:23 GMT+02:00 Jiří Činčura j...@cincura.net:

  I'm using the same Context for both MSSQL and Firebird, how deriving
 from FbDbConfiguration can affect MSSQL code path? Can we override this
 somehow just in Firebird provider?

 You can use the same context. It's just configuration. I'm waiting for
 reply from EF guys to see what other options are.

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



 --
 Dive into the World of Parallel Programming! The Go Parallel Website,
 sponsored by Intel and developed in partnership with Slashdot Media, is
 your
 hub for all things parallel software development, from weekly thought
 leadership blogs to news, videos, case studies, tutorials and more. Take a
 look and join the conversation now. http://goparallel.sourceforge.net
 ___
 Firebird-net-provider mailing list
 Firebird-net-provider@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

--
Dive into the World of Parallel Programming! The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] EF Migrations

One more thing about naming indexes conventions. Indexes namespace is
global. So if you have several same fields in different tables, you'll have
the same name index for both. Good example in three entities with N:M
relations:
Entity1: eid, name
Entity2: eid, name
Entity3: eid, name
Entity1Entity3: Entity1_eid, Entity3_eid
Entity1Entity2: Entity1_eid, Entity2_eid
Will try to create index IX_Entity1_eid for both tables and fail on this.
I've added the table name to the index name: IX_Entity1Entity3_Entity1_eid,
and as I mentioned before I've experienced long name error.

2014-12-30 11:35 GMT+02:00 Геннадий Забула zabulu...@gmail.com:

 And looks like it works:
 public FbProviderServices()
 {
 #if (EF_6)
 AddDependencyResolver(new
 SingletonDependencyResolverIDbConnectionFactory(new
 FbConnectionFactory()));
 AddDependencyResolver(new
 SingletonDependencyResolverFuncMigrationSqlGenerator(() = new
 FbMigrationSqlGenerator(), ProviderInvariantName));

 System.Data.Entity.Infrastructure.Interception.DbInterception.Add(new
 MigrationsTransactionsInterceptor());
 #endif
 }

 2014-12-30 11:29 GMT+02:00 Геннадий Забула zabulu...@gmail.com:

 I've found out that there is the static class:
 System.Data.Entity.Infrastructure.Interception.DbInterception, which adds
 IDbInterceptor,

 2014-12-30 11:23 GMT+02:00 Jiří Činčura j...@cincura.net:

  I'm using the same Context for both MSSQL and Firebird, how deriving
 from FbDbConfiguration can affect MSSQL code path? Can we override this
 somehow just in Firebird provider?

 You can use the same context. It's just configuration. I'm waiting for
 reply from EF guys to see what other options are.

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



 --
 Dive into the World of Parallel Programming! The Go Parallel Website,
 sponsored by Intel and developed in partnership with Slashdot Media, is
 your
 hub for all things parallel software development, from weekly thought
 leadership blogs to news, videos, case studies, tutorials and more. Take
 a
 look and join the conversation now. http://goparallel.sourceforge.net
 ___
 Firebird-net-provider mailing list
 Firebird-net-provider@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/firebird-net-provider




--
Dive into the World of Parallel Programming! The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] EF Migrations

 That’s not the same as what AddInterceptor call does.
As far as I see in the debugger, MigrationsTransactionsInterceptor is
called successfully and failed tests are going further. I've added just one
fix to filter just Firebird connections:
public void BeginningTransaction(DbConnection connection,
BeginTransactionInterceptionContext interceptionContext)
{
if (connection is FbConnection
 interceptionContext.IsolationLevel ==
IsolationLevel.Serializable
 IsInMigrations())
{
interceptionContext.Result =
connection.BeginTransaction(IsolationLevel.ReadCommitted);
}
}
 The name for index is created by EF if the explicit value is not provided.
Name conventions of EF is slightly different from Firebird. We need to
override this in the provider.

2014-12-30 11:57 GMT+02:00 Jiří Činčura j...@cincura.net:

 The name for index is created by EF if the explicit value is not provided.

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


 --
 Dive into the World of Parallel Programming! The Go Parallel Website,
 sponsored by Intel and developed in partnership with Slashdot Media, is
 your
 hub for all things parallel software development, from weekly thought
 leadership blogs to news, videos, case studies, tutorials and more. Take a
 look and join the conversation now. http://goparallel.sourceforge.net
 ___
 Firebird-net-provider mailing list
 Firebird-net-provider@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

--
Dive into the World of Parallel Programming! The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] EF Migrations

According to this:
http://entityframework.codeplex.com/wikipage?title=Interception
As I understand DbConfiguration.AddInterceptor is for context instance
interceptions.
And DbInterceptors.AddInterceptor is for global-wide interceptions.
I suggest moving registration MigrationsTransactionsInterceptor to the
DbInterceptors (or maybe via AddDependencyResolver(new
SingletonDependencyResolverIDbInterceptor()) as suggested in
documentation:
http://msdn.microsoft.com/ru-ru/library/system.data.entity.dbconfiguration.addinterceptor(v=vs.113).aspx),
because it is provider-specific crutch.

On Tue, Dec 30, 2014 at 12:15 PM, Jiří Činčura j...@cincura.net wrote:

Yeah, but it’s different path. The InternalConfiguration class might or might
not like that (now or in the future). It’s problem waiting to happen.

And please stop sending HTML emails.

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

--
Dive into the World of Parallel Programming! The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] EF Migrations