Re: [Firebird-net-provider] EF Migrations

2014-11-06 Thread Геннадий Забула
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

Re: [Firebird-net-provider] EF Migrations

2014-11-08 Thread Геннадий Забула
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

Re: [Firebird-net-provider] EF Migrations

2014-11-09 Thread Геннадий Забула
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

Re: [Firebird-net-provider] EF Migrations

2014-11-13 Thread Геннадий Забула
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

Re: [Firebird-net-provider] Insert into uncommitted table

2014-12-22 Thread Геннадий Забула
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

Re: [Firebird-net-provider] EF Migrations

2014-12-29 Thread Геннадий Забула
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

Re: [Firebird-net-provider] EF Migrations

2014-12-30 Thread Геннадий Забула
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

Re: [Firebird-net-provider] EF Migrations

2014-12-30 Thread Геннадий Забула
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

Re: [Firebird-net-provider] EF Migrations

2014-12-30 Thread Геннадий Забула
+02:00 Геннадий Забула zabulu...@gmail.com: And looks like it works: public FbProviderServices() { #if (EF_6) AddDependencyResolver(new SingletonDependencyResolverIDbConnectionFactory(new FbConnectionFactory())); AddDependencyResolver(new SingletonDependencyResolverFuncMigrationSqlGenerator

Re: [Firebird-net-provider] EF Migrations

2014-12-30 Thread Геннадий Забула
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

Re: [Firebird-net-provider] EF Migrations

2014-12-30 Thread Геннадий Забула
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

Re: [Firebird-net-provider] EF Migrations

2014-12-30 Thread Геннадий Забула
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

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

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

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

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

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.

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

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

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

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

Re: [Firebird-net-provider] 4.9.0 beta 1 release

2015-11-15 Thread Геннадий Забула
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.

Re: [Firebird-net-provider] [FB-Tracker] Created: (DNET-638) Add exception when FbConnectionPoolManager.ClearPools used inapropriately

2015-10-14 Thread Геннадий Забула
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 >

[Firebird-net-provider] Question about IFbClient purpose

2015-10-14 Thread Геннадий Забула
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? --

Re: [Firebird-net-provider] Question about IFbClient purpose

2015-10-14 Thread Геннадий Забула
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

Re: [Firebird-net-provider] Question about FbConnectionPoolManager

2015-10-06 Thread Геннадий Забула
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

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

Re: [Firebird-net-provider] Migrations

2015-08-29 Thread Геннадий Забула
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

Re: [Firebird-net-provider] Migrations

2015-08-29 Thread Геннадий Забула
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.

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

2015-08-29 Thread Геннадий Забула
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

[Firebird-net-provider] Migrations

2015-08-29 Thread Геннадий Забула
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.

Re: [Firebird-net-provider] Migrations

2015-08-29 Thread Геннадий Забула
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

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

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

2015-08-29 Thread Геннадий Забула
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

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

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

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:

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 relati

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

Re: [Firebird-net-provider] Migrations

2015-10-01 Thread Геннадий Забула
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

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

2015-10-01 Thread Геннадий Забула
; } 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.

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

2015-10-01 Thread Геннадий Забула
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

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

2015-10-01 Thread Геннадий Забула
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");

Re: [Firebird-net-provider] Migrations

2015-10-01 Thread Геннадий Забула
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

[Firebird-net-provider] Inserting strings problem

2015-10-01 Thread Геннадий Забула
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

Re: [Firebird-net-provider] Migrations

2015-10-02 Thread Геннадий Забула
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

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:

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

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

2015-09-24 Thread Геннадий Забула
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. ;) >

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

2015-09-25 Thread Геннадий Забула
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

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, Геннадий Забул

Re: [Firebird-net-provider] Parser class/library

2015-10-05 Thread Геннадий Забула
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

Re: [Firebird-net-provider] Parser class/library

2015-10-05 Thread Геннадий Забула
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

Re: [Firebird-net-provider] 4.9.0 beta 1 release

2015-12-06 Thread Геннадий Забула
> 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

Re: [Firebird-net-provider] 4.9.0 beta 1 release

2015-12-09 Thread Геннадий Забула
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

Re: [Firebird-net-provider] 4.9.0 beta 1 release

2015-12-09 Thread Геннадий Забула
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: >

Re: [Firebird-net-provider] FB3/provider 4.9.0.0 Boolean

2015-12-16 Thread Геннадий Забула
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

Re: [Firebird-net-provider] FB3/provider 4.9.0.0 Boolean

2015-12-17 Thread Геннадий Забула
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

Re: [Firebird-net-provider] Fyracle's External Engine to retire

2015-12-30 Thread Геннадий Забула
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. > > --

Re: [Firebird-net-provider] FB3/provider 4.9.0.0 Boolean

2015-12-17 Thread Геннадий Забула
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

Re: [Firebird-net-provider] Zlib library

2016-06-21 Thread Геннадий Забула
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 >

Re: [Firebird-net-provider] Solution With ADO.NET provider 4.10.0.0 Fails Compile

2016-01-18 Thread Геннадий Забула
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

Re: [Firebird-net-provider] Choose isolation level using System.Data.IsolationLevel?

2016-01-31 Thread Геннадий Забула
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

Re: [Firebird-net-provider] connection rejected by remote interface Error]

2016-01-19 Thread Геннадий Забула
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

Re: [Firebird-net-provider] Entity Framework: Best practices to work in a multiuser environment

2016-03-25 Thread Геннадий Забула
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

Re: [Firebird-net-provider] Entity Framework: Best practices to work in a multiuser environment

2016-03-26 Thread Геннадий Забула
> 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

Re: [Firebird-net-provider] Entity Framework: Best practices to workin a multiuser environment

2016-04-01 Thread Геннадий Забула
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:

Re: [Firebird-net-provider] Renaming some folder

2016-03-23 Thread Геннадий Забула
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

Re: [Firebird-net-provider] [FB-Tracker] Created: (DNET-680) cannot connect to an embedded db with the 5.0.0.0

2016-05-19 Thread Геннадий Забула
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 > - > >

[Firebird-net-provider] Two DbContexts same database

2016-04-18 Thread Геннадий Забула
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

Re: [Firebird-net-provider] [Firebird-devel] Stored procedures etc. in .NET

2016-06-29 Thread Геннадий Забула
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

Re: [Firebird-net-provider] Finalizers

2016-09-06 Thread Геннадий Забула
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

Re: [Firebird-net-provider] Some guess or hint

2016-09-06 Thread Геннадий Забула
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

Re: [Firebird-net-provider] EntitiyFramework and Update

2016-10-26 Thread Геннадий Забула
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

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

2017-01-10 Thread Геннадий Забула
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

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

2017-01-10 Thread Геннадий Забула
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

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

2017-01-10 Thread Геннадий Забула
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 > >

Re: [Firebird-net-provider] Firing event when event count is 0

2016-12-16 Thread Геннадий Забула
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:

[Firebird-net-provider] Fbembed + .NET Provider 5.9.1. Memory leak?

2017-08-10 Thread Геннадий Забула
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

[Firebird-net-provider] Fwd: Fbembed + .NET Provider 5.9.1. Memory leak?

2017-08-31 Thread Геннадий Забула
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