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

[Firebird-net-provider] RES: Shutdown - online problem

[Nicolas F. T. <nft...@ho...>]

Yes

Seens that in the new Version after a shutdown it not cleanen the pool anymore


So if you made a connection before the database shutdown made the shutdown and then try to connect usem the same user of the first connection an exception is throw.

So If you clean the pool the excetion stop's

-----Mensagem original-----
De: Jiří Činčura [mailto:ji...@ci...] 
Enviada em: terça-feira, 13 de janeiro de 2015 14:35
Para: For users and developers of the Firebird .NET providers
Assunto: Re: [Firebird-net-provider] Shutdown - online problem

Is the call in console app *exactly* the same as in web app?
-- 
Mgr. Jiří Činčura
Independent IT Specialist
------------------------------------------------------------------------------
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
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

[Firebird-net-provider] RES: Shutdown - online problem

[Nicolas F. T. <nft...@ho...>]

Founded

 

In the new version 4.6 after make de Database Shutdown we need to run

 

FirebirdSql.Data.FirebirdClient.FbConnection.ClearAllPools();

 

And then it works’s

 

Question, should it be done automaticly ?

 

De: Nicolas F. Timmers [mailto:nft...@ho...] 
Enviada em: terça-feira, 13 de janeiro de 2015 13:40
Para: fir...@li...
Assunto: [Firebird-net-provider] Shutdown - online problem

 

Hello Everyone

 

I’m facing a problem on the new version of .net data provider Version 4.6

 

The DataBase Shutdown and Online seem not been worling on Web App’s

 

If I made on a Console Apllication it works fine, but on a web app, I made
the shutdown and database online no error is returned but when I made a
SELECT it returns that it still on shutdown 

 

Any help ??

Re: [Firebird-net-provider] Shutdown - online problem

[Jiří Č. <ji...@ci...>]

Is the call in console app *exactly* the same as in web app?
-- 
Mgr. Jiří Činčura
Independent IT Specialist

[Firebird-net-provider] Shutdown - online problem

[Nicolas F. T. <nft...@ho...>]

Hello Everyone

 

I'm facing a problem on the new version of .net data provider Version 4.6

 

The DataBase Shutdown and Online seem not been worling on Web App's

 

If I made on a Console Apllication it works fine, but on a web app, I made
the shutdown and database online no error is returned but when I made a
SELECT it returns that it still on shutdown 

 

Any help ??

[Firebird-net-provider] [FB-Tracker] Created: (DNET-588) FbStreamingRestore without Verbose=true might end prematurely

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

FbStreamingRestore without Verbose=true might end prematurely
-------------------------------------------------------------

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


Because there are no messages in responses and length might be 0 as the server might be processing the data.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Re: [Firebird-net-provider] EF Migrations

[Mercea P. <pau...@al...>]

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.
>
First error i got when i enable migrations:

"Checking if the context targets an existing database...
No MigrationSqlGenerator found for provider 
'FirebirdSql.Data.FirebirdClient'. Use the SetSqlGenerator method in the 
target migrations configuration class to register additional SQL 
generators."

FB 2.5.2, Windows 8.1, Visual Studio 2013.
FB Client 4.6

Paul MERCEA
___________________________________________
E-mail: pau...@al...
___________________________________________

[Firebird-net-provider] [FB-Tracker] Created: (DNET-587) Support for MetaDataOnly in FbRestoreFlags

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

Support for MetaDataOnly in FbRestoreFlags
------------------------------------------

                 Key: DNET-587
                 URL: http://tracker.firebirdsql.org/browse/DNET-587
             Project: .NET Data provider
          Issue Type: Improvement
          Components: ADO.NET Provider
    Affects Versions: 4.6.0.0
            Reporter: Jiri Cincura
            Assignee: Jiri Cincura
            Priority: Minor




-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Re: [Firebird-net-provider] Firebird and VS 2015 preview

[Mercea P. <pau...@al...>]

On 2015.01.08 11:04 PM, Jiří Činčura wrote:
> You mean DDEX?
>
Yes Jiri, you are right.
I modified reg files(12.0_config->14.0_config) and is working.
Thanks.

Paul MERCEA
___________________________________________
E-mail: pau...@al...
___________________________________________

Re: [Firebird-net-provider] Firebird and VS 2015 preview

[Jiří Č. <ji...@ci...>]

You mean DDEX? 

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

[Firebird-net-provider] [FB-Tracker] Created: (DNET-584) Add suport for Firebird 3

[Mercea P. (JIRA) <tr...@fi...>]

Add suport for Firebird 3
-------------------------

                 Key: DNET-584
                 URL: http://tracker.firebirdsql.org/browse/DNET-584
             Project: .NET Data provider
          Issue Type: New Feature
          Components: ADO.NET Provider
    Affects Versions: 4.6.0.0
         Environment: Windows 8.1 x64, Windows 10 x64, Firebird 3 beta 1
            Reporter: Mercea Paul
            Assignee: Jiri Cincura
            Priority: Minor


I'm trying to test an existing app with next Firebird 3 version but i get error message:
"Could not retrieve storage version."



-- 
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] Firebird and VS 2015 preview

[Mercea P. <pau...@al...>]

Hi all

Has anyone tried Firebird with Visual Studio 2015 preview?
Is enough to modify reg files to register as provider?

TIA,

Paul MERCEA
___________________________________________
E-mail: pau...@al...
___________________________________________

Re: [Firebird-net-provider] Firebird connection very slow

[Jiří Č. <ji...@ci...>]

The 10054 means "Connection Reset By Peer". Looks like something on the machine is killing the connection. But might be also as you're debugging that you kill your application.

Can you maybe create a simple console app and try the connection there. To eliminate stuff around.

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

[Firebird-net-provider] Firebird connection very slow

[Raigo L <ra...@ma...>]

Hi, 

problem is that the connection to Firebird server is very slow. Sometimes takes up to a minute to connect. After it has connected works very fast. 
Frequently also get INET/inet_error: read errno = 10054 in Firebird.log 

However connecting with Flamerobin or IBExpert is very fast.

Firebird Superserver, ASP.NET MVC5 application. 
Firebird server and IIS + application are running on same machine, all connections are to 127.0.0.1 

I have this issue on 2 different servers (Windows Server 2008 R2), and in my development machine (Windows7). So it is not related to certain hardware.

What I have already done: 
upgraded to latest Firebird 2.5.3 and ADO.NET Data provider 4.6.0

Database Page Size 16384

I read http://www.firebirdfaq.org/faq52/  
and already checked those. 

exists both

c:\windows\system32\drivers\etc\hosts
127.0.0.1       localhost

c:\windows\system32\drivers\etc\services 
gds_db 3050/tcp fb #Firebird 

In windows Firewall opened port 3050. Also have tried turning off Windows firewall, no difference 

I use extension .FDB 

I have run netsh winsock reset 

in application wherever I open connection I also close it. typical pattern I use is 

Web.config file 
<add name="ConnectionString2" connectionString="Charset=UTF8;DataSource=127.0.0.1;Server Type=0;Port=3050;Database=C:\mydir\mydb.fdb;User=sysdba;Password=masterkey;Pooling=true;MinPoolSize=0;MaxPoolSize=100;Connection lifetime=15;Packet Size=8192;" providerName="FirebirdSql.Data.FirebirdClient" />

C# 
            string connectionString = ConfigurationManager.ConnectionStrings["ConnectionString2"].ConnectionString;

            using (FbConnection connection = new FbConnection(connectionString))
            {
                connection.Open();
                using (FbCommand command = new FbCommand("select * from sp_get_event_type (?, ?);", connection))
                {
                    command.Parameters.Add("category_id", FbDbType.Integer).Value = category_id;
                    command.Parameters.Add("language_code", FbDbType.Text).Value = language_code;
                    FbDataReader reader = command.ExecuteReader();
                    while (reader.Read())
                    {
                        event_type_items.Add(new event_type
                        {
                            event_type_id = reader.GetInt32(reader.GetOrdinal("event_type_id")),
                            event_type_name = reader["event_type_name"].ToString()
                        });
                    }
                    reader.Close();
                }
                connection.Close();
            }


what else could be done to improve slow connection to Firebird?

Raigo

Re: [Firebird-net-provider] EF Migrations

[Jiří Č. <ji...@ci...>]

> I'd like to do this. But when I register it in provider services, it does
> not work. Not sure why.

Ahh. Finally found it. IdbInterceptors are not supported for registration in DbProviderServices. So we're probably left with only DbInterception.Add. I did some research and looks it should work fine. Better than forcing people to derive from custom class, I think.

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

Re: [Firebird-net-provider] EF Migrations

[Jiří Č. <ji...@ci...>]

> One more question, how can I register custom implementation of
> IFbMigrationSqlGeneratorBehavior?

Register MigrationSqlGenerator with FbMigrationSqlGenerator and pass the implementation to ctor. Something like:
AddDependencyResolver(new SingletonDependencyResolver<Func<MigrationSqlGenerator>>(() => new FbMigrationSqlGenerator(...

EF does not allow to plug custom "services". :(

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

Re: [Firebird-net-provider] EF Migrations

[Jiří Č. <ji...@ci...>]

> or maybe via AddDependencyResolver(new
> SingletonDependencyResolver<IDbInterceptor>()) as suggested in
> documentation: http://msdn.microsoft.com/ru-
> ru/library/system.data.entity.dbconfiguration.addinterceptor(v=vs.113).asp
> x),

I'd like to do this. But when I register it in provider services, it does not work. Not sure why.

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

Re: [Firebird-net-provider] EF Migrations

[Геннадий З. <zab...@gm...>]

One more question, how can I register custom implementation of
IFbMigrationSqlGeneratorBehavior?

On Tue, Dec 30, 2014 at 12:55 PM, Геннадий Забула <zab...@gm...> wrote:
> 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
> SingletonDependencyResolver<IDbInterceptor>()) 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 <ji...@ci...> 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
>> Fir...@li...
>> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] EF Migrations

[Геннадий З. <zab...@gm...>]

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
SingletonDependencyResolver<IDbInterceptor>()) 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 <ji...@ci...> 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
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] EF Migrations

[Jiří Č. <ji...@ci...>]

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

Re: [Firebird-net-provider] EF Migrations

[Геннадий З. <zab...@gm...>]

> 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 <ji...@ci...>:

> 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
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

Re: [Firebird-net-provider] EF Migrations

[Jiří Č. <ji...@ci...>]

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

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

Re: [Firebird-net-provider] EF Migrations

[Jiří Č. <ji...@ci...>]

That’s not the same as what AddInterceptor call does.

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

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

And looks like it works:
public FbProviderServices()
                      {
#if (EF_6)
                                  AddDependencyResolver(new SingletonDependencyResolver<IDbConnectionFactory>(new FbConnectionFactory()));
                                  AddDependencyResolver(new SingletonDependencyResolver<Func<MigrationSqlGenerator>>(() => new FbMigrationSqlGenerator(), ProviderInvariantName));
            System.Data.Entity.Infrastructure.Interception.DbInterception.Add(new MigrationsTransactionsInterceptor());
#endif
                      }

2014-12-30 11:29 GMT+02:00 Геннадий Забула <zab...@gm...<mailto:zab...@gm...>>:
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 <ji...@ci...<mailto:ji...@ci...>>:
> 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
Fir...@li...<mailto:Fir...@li...>
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] EF Migrations

[Геннадий З. <zab...@gm...>]

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 Геннадий Забула <zab...@gm...>:

> And looks like it works:
> public FbProviderServices()
> {
> #if (EF_6)
> AddDependencyResolver(new
> SingletonDependencyResolver<IDbConnectionFactory>(new
> FbConnectionFactory()));
> AddDependencyResolver(new
> SingletonDependencyResolver<Func<MigrationSqlGenerator>>(() => new
> FbMigrationSqlGenerator(), ProviderInvariantName));
>
> System.Data.Entity.Infrastructure.Interception.DbInterception.Add(new
> MigrationsTransactionsInterceptor());
> #endif
> }
>
> 2014-12-30 11:29 GMT+02:00 Геннадий Забула <zab...@gm...>:
>
>> 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 <ji...@ci...>:
>>
>>> > 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
>>> Fir...@li...
>>> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>>>
>>
>>
>

Re: [Firebird-net-provider] EF Migrations

[Геннадий З. <zab...@gm...>]

And looks like it works:
public FbProviderServices()
{
#if (EF_6)
AddDependencyResolver(new
SingletonDependencyResolver<IDbConnectionFactory>(new
FbConnectionFactory()));
AddDependencyResolver(new
SingletonDependencyResolver<Func<MigrationSqlGenerator>>(() => new
FbMigrationSqlGenerator(), ProviderInvariantName));

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

2014-12-30 11:29 GMT+02:00 Геннадий Забула <zab...@gm...>:

> 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 <ji...@ci...>:
>
>> > 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
>> Fir...@li...
>> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>>
>
>

Re: [Firebird-net-provider] EF Migrations

[Геннадий З. <zab...@gm...>]

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 <ji...@ci...>:

> > 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
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>