Sure, waiting for this.
2014-11-06 15:06 GMT+02:00 Jiří Činčura j...@cincura.net:
Hi *,
Anybody here willing to give EF Migrations a try? I'm getting close to
first implementation.
--
Mgr. Jiří Činčura
Independent IT Specialist
Can you provide it on github, so I can patch my copy of FB library to use
in our project?
1. What problem in Execute block?
2. My opinion for Identity is to copy MSSQL behavior. Create generator
for each primary key + trigger before insert.
2014-11-08 14:38 GMT+02:00 Jiří Činčura
I've asked about mutual exclusive of schemes.
If schemes can be applied in one model you can use custom attributes on
primary keys.
If schemes are mutual exclusive, you can use custom extension method for
model builder.
2014-11-09 13:12 GMT+02:00 Jiří Činčura j...@cincura.net:
The update
Don't have enough time to merge and test it. I look forward to test it and
write some feedback on next week.
2014-11-13 18:31 GMT+02:00 Jiří Činčura j...@cincura.net:
Except for identity generation should be done: http://ge.tt/3OSvoR42 .
Some feedback?
--
Mgr. Jiří Činčura
Independent IT
What the problem with inserting in different transactions?
Have you tried Read uncommited/Consistent read?
2014-12-22 14:08 GMT+02:00 Jiří Činčura j...@cincura.net:
Hi *,
Anybody knows a trick how to insert into freshly created table without
commiting that DDL first. It's kind of fucking up
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
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
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
+02:00 Геннадий Забула zabulu...@gmail.com:
And looks like it works:
public FbProviderServices()
{
#if (EF_6)
AddDependencyResolver(new
SingletonDependencyResolverIDbConnectionFactory(new
FbConnectionFactory()));
AddDependencyResolver(new
SingletonDependencyResolverFuncMigrationSqlGenerator
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
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
One more question, how can I register custom implementation of
IFbMigrationSqlGeneratorBehavior?
On Tue, Dec 30, 2014 at 12:55 PM, Геннадий Забула zabulu...@gmail.com wrote:
According to this:
http://entityframework.codeplex.com/wikipage?title=Interception
As I understand
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
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
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
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:
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 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
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
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
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
Here is my comments about Migration:
1. readonly IFbMigrationSqlGeneratorBehavior _behavior;
Is used only in migration operations DropColumn/AlterColumn, not used
in AddColumn.
2. We have additional implementation of Check in (0,1) for boolean
fields like implemented in SsdlToSql.cs
3.
PR on github was updated
On 7 October 2015 at 10:36, Hennadii Zabula (JIRA)
wrote:
> Add exception when FbConnectionPoolManager.ClearPools used inapropriately
> -
>
> Key: DNET-638
>
Jiri, could you clarify what is a purpose of separate IFbClient
interface and about using native calls through instance instead of
organizing P/Invokes as static NativeMethods class?
--
forge.net"
<firebird-net-provider@lists.sourceforge.net>
Subject: Re: [Firebird-net-provider] Question about IFbClient purpose
On Wed, Oct 14, 2015, at 19:12, Геннадий Забула wrote:
> Jiri, could you clarify what is a purpose of separate IFbClient
> interface and about using
On Tue, Oct 6, 2015, at 15:46, Геннадий Забула wrote:
>> I have a question about method implementation.
>> CleanConnectionsImpl
>> It cleans connections in pool.
>> But why _busy dictionary connections are disposed as well?
>> Isn't it a trouble maker for inappropriate
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
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
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.
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
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.
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
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
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
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 *,
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
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:
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 relati
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
ge 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?
>> Be
; }
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.
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
>> {
>> publ
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");
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 spe
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
enerators for these exceptional tables.
On 1 October 2015 at 22:26, Daniel Rail <dan...@accra.ca> wrote:
> Hi,
>
> At October 1, 2015, 2:21 PM, Jiří Činčura wrote:
>
>> On Thu, Oct 1, 2015, at 19:00, Геннадий Забула wrote:
>>> In ModelBuilder you can specify any object as
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:
> 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
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. ;)
>
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 impleme
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, Геннадий Забул
http://entityframework.codeplex.com/SourceControl/latest#src/EntityFramework/Core/Common/EntitySql/GenerateParser.cmd
On 5 October 2015 at 17:22, Геннадий Забула <zabulu...@gmail.com> wrote:
> EF uses yacc and lex for EntityTree parsing.
> They both produce C# class that can
EF uses yacc and lex for EntityTree parsing.
They both produce C# class that can be compiled into the assembly.
On 5 October 2015 at 16:30, Jiří Činčura wrote:
> Hi,
>
> I'm working on a bug fix for DNET-266. And the more and more I tweak the
> parser I wrote this morning to
> Do you think it should throw exception? I would rather let that for
> Firebird. Somebody might tweak the script or something like that.
> I know you proposed hashing the name, but that's not reasonable general
> solution. The database would look gibberish for outside view. Nobody
> would know
I think it should be ArgumentOutOfRange
On 9 December 2015 at 15:13, Jiří Činčura <j...@cincura.net> wrote:
> On Wed, Dec 9, 2015, at 13:43, Jiří Činčura wrote:
>> On Sun, Dec 6, 2015, at 18:29, Геннадий Забула wrote:
>> > I think the earlier it will be thrown the be
The name '{name}' is longer than Firebird's {LengthLimit} characters
limit for objects names.
On 9 December 2015 at 15:42, Jiří Činčura wrote:
> Be my guest:
>
It is implemented in PR:
https://github.com/cincuranet/FirebirdSql.Data.FirebirdClient/pull/40
But since there is no overall support for FB 3.0 (especially new
authentication) the PR is suspended.
On 16 December 2015 at 21:21, Rick Roen wrote:
> I'm pretty sure this is a
t require protocol version 13 support, and could
> be added without problems.
>
> Mark
>
>
> - Reply message -----
> Van: "Геннадий Забула" <zabulu...@gmail.com>
> Aan: "For users and developers of the Firebird .NET providers"
> <firebird-net-pr
Is it Ext* classes?
On 30 December 2015 at 11:06, Jiří Činčura wrote:
> Hi *,
>
> the so called Fyracle External Engine is going to be removed from
> sources in next major/minor version. It will still be in history, as
> usual, in case somebody wants to look at history.
>
> --
Mgr. Jiří Činčura
> Independent IT Specialist
>
> On Thu, Dec 17, 2015, at 09:54, Геннадий Забула wrote:
>> And so it was.
>> I'm also don't understand why don't merge the PR.
>> People can start using .NET with FB 3.0 using legacy authentication
>> and new features like native
There is also ILMerge option to include dependency in a package.
On 21 June 2016 at 11:02, Gerdus van Zyl wrote:
> SharpZipLib looks to be more actively maintained and with clearer and more
> permissive licensing. It's a dependency of most of my project anyway so I
>
According to http://semver.org/, if Public API surface is changed with
any backwards incompatible changes major version must be changed.
On 18 January 2016 at 16:29, Jiří Činčura wrote:
>> Reading the release notes for 4.9, there have been a change for the
>> event handlers, to
y 2016 at 09:20, Kjell Rilbe <kj...@rilbe.se> wrote:
> den 2016-01-30 20:23, skrev Геннадий Забула:
>> On 30 January 2016 at 12:44, Kjell Rilbe <kj...@rilbe.se> wrote:
>>> Hi,
>>>
>>> Using a framework that's "database agnostic", I am
fbclient.dll is not .net provider library, it is fb server native client library
On 19 January 2016 at 13:41, dragos.pop wrote:
>
> IBExpert is a freeware downloaded from Internet, which is not a .NET
> application so it does not use the .NET provider but the gds32.dll
EF context is implementation of unit-of-work pattern, it is not
repository pattern.
> d) Do I need to dispose the the context on closing the window?
Not only on that. you should create and dispose context for every
action you do with a database: insert, delete, update, query etc.
> 3. As
> That doesn't make any sense. If I dispose context after query then I
can't update the entities without attaching them to new context. Waste
of resources.
Indeed. It's EF poor design, that they try to rework in EF core.
Still there are plenty of workarounds for this. For example attaching
Keeping long-lived context instance it is something like having in-memory
database. Yes you have all entities but it cost you memory. Still some apps ok
with this, if user session works only with small subset of database entities.
Sent from my Windows 10 phone
From: Jiří Činčura
Sent:
Looks good for me.
Here is one more suggestion: extract DDEX sources to separate
repository, and use FirebirdSql.Data.FirebirdClient rep only for
client itself.
On 22 March 2016 at 22:12, Jiří Činčura wrote:
> Hi *,
>
> I'm contemplating renaming some folders - the two top
I can confirm. Same issue here.
Steps:
run Update-Package FirebirdSql.Data.FirebirdClient
in package manager console
On 18 May 2016 at 15:57, livioc (JIRA) wrote:
> cannot connect to an embedded db with the 5.0.0.0
> -
>
>
Is it possible to have two different database contexts that points to
same databases file?
--
Find and fix application performance issues faster with Applications Manager
Applications Manager provides deep performance
Looks good.
I wonder where do code should persist? Server/Client?
What performance impact for such logic?
On 28 June 2016 at 15:37, Daniel Rail wrote:
> Hi,
>
> At June 27, 2016, 3:51 PM, Jiří Činčura wrote:
>
>> Hi *,
>
>> there's something I've been working on for a few
What finalizers are you mention?
On 29 August 2016 at 11:23, Gerdus van Zyl wrote:
> I agree finalizers should not be used to mask or 'fix' incorrect provider
> usage. I try to avoid finalizers as much as possible since they run at
> unpredictable times causing hard to
I had catched such random issues by couple of tricks:
1. .trx files that were produced vstest.console. They always have call
stack with exception.
2. Unhandled exception handler that creates dump file of process
itself and then publish it as artifact. Dump can be opened in Visual
Studio, it will
FB.NET doesn't wait on locks, it returns immediately with exception.
All other known for me are waiting on locks. That's the behavior you
observe.
You need to override creation of transaction. You should use
FbTransaction with TBP in which you specify waiting option and
timeout.
On 26 October
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
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
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
>
>
If the event you mentioned means, "nothing happens, I'm just alive and
send you this", then you should only fire some event that means server
alive, nothing else. No one cares that event occurs just because
server sent something.
On 17 December 2016 at 00:22, Si Carter wrote:
Hi all.
I have server, after a while, it starts continuously consume memory.
All approaches I've used before didn't show that this was particular
memory leak in server code.
To detect memory leak I've used vmmap, that showed private memory
(VirtualAlloc) is consumed (attach1.png
Hi all.
I have server, after a while, it starts continuously consume memory.
All approaches I've used before didn't show that this was particular
memory leak in server code.
To detect memory leak I've used vmmap, that showed private memory
(VirtualAlloc) is consumed (attach1.png
80 matches
Mail list logo