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

Re: [Firebird-net-provider] Sweep

[Jiri C. <di...@ci...>]

On Wed, Apr 3, 2013 at 2:20 AM, Nicolas Timmers <nft...@ho...> wrote:
> There is a method on firebord data provider to perform database sweep??

Yes. Services namespace. FbValidationFlags.SweepDatabase flag.

--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com

[Firebird-net-provider] Sweep

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

There is a method on firebord data provider to perform database sweep??

Enviado pelo meu Windows Phone

[Firebird-net-provider] [FB-Tracker] Created: (DNET-489) Wrong parameters usage when using restriction on catalogr/schema on non-table schema tables

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

Wrong parameters usage when using restriction on catalogr/schema on non-table schema tables
-------------------------------------------------------------------------------------------

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


Calling ".GetSchema("Procedures", new[] { null, "dbo", "test" });" results into:
				SELECT
					null AS PROCEDURE_CATALOG,
					null AS PROCEDURE_SCHEMA,
					rdb$procedure_name AS PROCEDURE_NAME,
					rdb$procedure_inputs AS INPUTS,
					rdb$procedure_outputs AS OUTPUTS,
					rdb$system_flag AS IS_SYSTEM_PROCEDURE,
					rdb$procedure_source AS SOURCE,
					rdb$description AS DESCRIPTION
				FROM rdb$procedures WHERE rdb$procedure_name = @p0  ORDER BY rdb$procedure_name
FirebirdSql.Data.FirebirdClient Information: 0 : Parameters:

FirebirdSql.Data.FirebirdClient Information: 0 : Name:@p0	Type:VarChar	Used Value:dbo
FirebirdSql.Data.FirebirdClient Information: 0 : Name:@p1	Type:VarChar	Used Value:test

So the wrong parameter is used and another parameter is generated even if nod needed nor used.

It should be i.e.:
				SELECT
					null AS PROCEDURE_CATALOG,
					'Firebird' AS PROCEDURE_SCHEMA,
					rdb$procedure_name AS PROCEDURE_NAME,
					rdb$procedure_inputs AS INPUTS,
					rdb$procedure_outputs AS OUTPUTS,
					rdb$system_flag AS IS_SYSTEM_PROCEDURE,
					rdb$procedure_source AS SOURCE,
					rdb$description AS DESCRIPTION
				FROM rdb$procedures WHERE rdb$procedure_name = @p0  ORDER BY rdb$procedure_name
Parameters:
Name:@p0	Type:VarChar	Used Value:test

-- 
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] Cannot "Update Model from Database" in Visual Studio 2012 Pro

[Jiri C. <di...@ci...>]

On Mon, Mar 11, 2013 at 8:29 PM, Michael Eubanks <meu...@id...> wrote:
> Also, when I attempt to connect to a Firebird database using the "Server
> Explorer", Firebird is not listed. Any ideas??

DDEX not installed correctly.

-- 
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com

Re: [Firebird-net-provider] Code First Error

[Jiri C. <di...@ci...>]

On Sun, Mar 24, 2013 at 7:51 PM, Muthu Annamalai <pea...@gm...> wrote:
> if you can help me

This part looks good. But hard to guess without the whole code.

-- 
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com

Re: [Firebird-net-provider] Code First Error

[Muthu A. <pea...@gm...>]

Here is my Image.cs and ImageMap.cs and DbContext Class, also I have column for image which is byte array... please see if you can help me...

*************************************************
    public partial class IMAGE
    {
        public int ID { get; set; }
        public int? ITEMSTYLEID { get; set; }
        public int? USERID { get; set; }
        public int? CUSTOMERID { get; set; }
        public byte[] PICTURE { get; set; }
        public virtual CUSTOMER CUSTOMER { get; set; }
        public virtual ITEMSTYLE ITEMSTYLE { get; set; }
        public virtual USER USER { get; set; }
    }
*************************************************

public class IMAGEMap : EntityTypeConfiguration<IMAGE>
    {
        public IMAGEMap()
        {
            // Primary Key
            HasKey(t => t.ID);

            // Properties
            Property(t => t.PICTURE)
                .IsRequired();

            // Table & Column Mappings
            ToTable("IMAGE", "Firebird");
            Property(t => t.ID).HasColumnName("ID");
            Property(t => t.ITEMSTYLEID).HasColumnName("ITEMSTYLEID");
            Property(t => t.USERID).HasColumnName("USERID");
            Property(t => t.CUSTOMERID).HasColumnName("CUSTOMERID");
            Property(t => t.PICTURE).HasColumnName("PICTURE");

            // Relationships
            HasOptional(t => t.CUSTOMER)
                .WithMany(t => t.IMAGEs)
                .HasForeignKey(d => d.CUSTOMERID);
            HasOptional(t => t.ITEMSTYLE)
                .WithMany(t => t.IMAGEs)
                .HasForeignKey(d => d.ITEMSTYLEID);
            HasOptional(t => t.USER)
                .WithMany(t => t.IMAGEs)
                .HasForeignKey(d => d.USERID);
        }
    }

    {
        static Entities()
        {
            Database.SetInitializer<Entities>(null);
        }

        public Entities()
            : base("Name=Entities")
        {
        }

        public Entities(string connectionString)
            : base(connectionString)
        {
        }

        public Entities(DbConnection entityConnection) : base(entityConnection, true)
        {
        }

        public DbSet<ADDRESS> ADDRESSes { get; set; }
 	  snip...
        public DbSet<IMAGE> IMAGEs { get; set; }
        snip...
        public DbSet<VENDOR> VENDORs { get; set; }

        public override int SaveChanges()
        {
            try
            {
                return base.SaveChanges();
            }
            catch (DbUpdateConcurrencyException e)
            {
                if (e.GetType() == typeof (DbUpdateConcurrencyException))
                {
                    //Update the values of the entity that failed to save from the store
                    e.Entries.GetEnumerator().Current.Reload();
                }
                EmailException.ExceptionEmail(e);
                return 0;
            }
        }

        protected override void OnModelCreating(DbModelBuilder modelBuilder)
        {
            modelBuilder.Configurations.Add(new ADDRESSMap());
            snip...
            modelBuilder.Configurations.Add(new IMAGEMap());
		snip...
            modelBuilder.Configurations.Add(new VENDORMap());
        }
    }


-----Original Message-----
From: MuthuAnnamalai [mailto:mut...@sb...] 
Sent: Friday, March 22, 2013 6:27 AM
To: For users and developers of the Firebird .NET providers
Subject: Re: [Firebird-net-provider] Code First Error

But the Model is created by C# Entity Framework Power tool and I checked the Image table mapping class which has mapping for primary key defined...

Sent from my iPad

On Mar 22, 2013, at 3:07 AM, Jiri Cincura <di...@ci...> wrote:

> On Fri, Mar 22, 2013 at 3:05 AM, Muthu Annamalai 
> <mut...@sb...> wrote:
>> 
>> System.Data.Entity.Edm.EdmEntityType: EntityType ‘Image’ has no key 
>> defined. Define the key for this EntityType.
>> 
>> System.Data.Entity.Edm.EdmEntitySet: EntityType  EntitySet ‘Images is 
>> based on the type ‘Image’ that has no key defined. Define the key for 
>> this EntityType.
> 
> I think this is pretty clear. You didn't specified the key(s) for your entity.
> 
>> All the tables in our database has primary key defined. And all the
> 
> Which is not relevant here. The error is about model, not database.
> 
>> primary keys have Description set to #PK_GEN#. Any clue to fix this 
>> error is
> 
> #PK_GEN# is used only when you *generate* EDM.
> 
> --
> Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | 
> http://www.ID3renamer.com
> 
> ----------------------------------------------------------------------
> -------- Everyone hates slow websites. So do we.
> Make your web apps faster with AppDynamics Download AppDynamics Lite 
> for free today:
> http://p.sf.net/sfu/appdyn_d2d_mar
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_mar
_______________________________________________
Firebird-net-provider mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

[Firebird-net-provider] Fbshutdown

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

The dbshutdown command apears not to work with firebird 2.5.2 super classic aleays return the error service already open can someone help?

Enviado pelo meu Windows Phone

Re: [Firebird-net-provider] fbbackup

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

Tank you
So doing the shutdown not necessary i need to call the clear pool right ? Because tje shitdown forced will close all connection be her from .net or othee?

Enviado pelo meu Windows Phone
________________________________
De: Mark Rotteveel
Enviada em: 22/03/2013 11:08
Para: For users and developers of the Firebird .NET providers
Assunto: Re: [Firebird-net-provider] fbbackup

On Fri, 22 Mar 2013 13:48:21 +0000, Scott Price <sco...@vi...>
wrote:
> You shouldn't need to perform a server shut-down to perform a restore,
> and do not need to ever to perform a backup, though it's up to you if
> you choose to.  What you would need to do is make sure all connections
> to the database are closed.  If you are using the .NET ADO.NET provider
> only, you will by default probably be using connection pooling.  As
> such, you will likely need to have a call to
>
> FbConnection.ClearAllPools();
>
> That should drop all connections from the local perspective.  It will
> not help with any other machines connected to the database however.
>
> After a short pause to let any kind of clean up that's required to
> occur, you should be able to restore a database backup to that instance.

Shutting down a database means that the Firebird server will not accept
any connections for a specific database (or only accepts a single admin
connection). Depending on the exact config you can even force the server to
close existing connections. This is a much cleaner way than assuming that
the manual work to close connections is sufficient, or that your
applications is the only one to connect.

You can use FbConfiguration (in FirebirdSql.Data.Services) to shutdown a
database.

Mark

------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_mar
_______________________________________________
Firebird-net-provider mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] fbbackup

[Mark R. <ma...@la...>]

On Fri, 22 Mar 2013 13:48:21 +0000, Scott Price <sco...@vi...>
wrote:
> You shouldn't need to perform a server shut-down to perform a restore, 
> and do not need to ever to perform a backup, though it's up to you if 
> you choose to.  What you would need to do is make sure all connections 
> to the database are closed.  If you are using the .NET ADO.NET provider 
> only, you will by default probably be using connection pooling.  As 
> such, you will likely need to have a call to
> 
> FbConnection.ClearAllPools();
> 
> That should drop all connections from the local perspective.  It will 
> not help with any other machines connected to the database however.
> 
> After a short pause to let any kind of clean up that's required to 
> occur, you should be able to restore a database backup to that instance.

Shutting down a database means that the Firebird server will not accept
any connections for a specific database (or only accepts a single admin
connection). Depending on the exact config you can even force the server to
close existing connections. This is a much cleaner way than assuming that
the manual work to close connections is sufficient, or that your
applications is the only one to connect.

You can use FbConfiguration (in FirebirdSql.Data.Services) to shutdown a
database.

Mark

Re: [Firebird-net-provider] fbbackup

[Scott P. <sco...@vi...>]

You shouldn't need to perform a server shut-down to perform a restore, 
and do not need to ever to perform a backup, though it's up to you if 
you choose to.  What you would need to do is make sure all connections 
to the database are closed.  If you are using the .NET ADO.NET provider 
only, you will by default probably be using connection pooling.  As 
such, you will likely need to have a call to

FbConnection.ClearAllPools();

That should drop all connections from the local perspective.  It will 
not help with any other machines connected to the database however.

After a short pause to let any kind of clean up that's required to 
occur, you should be able to restore a database backup to that instance.


Kind regards,


Scott Price

On 22/03/2013 13:38, Nicolas Timmers wrote:
> You are right tank youu
>
> Someone know hpw to performe a database shutdown and online ???
>
> Enviado pelo meu Windows Phone
> ------------------------------------------------------------------------
> De: Gerdus van Zyl
> Enviada em: 22/03/2013 09:19
> Para: For users and developers of the Firebird .NET providers
> Assunto: Re: [Firebird-net-provider] fbbackup
>
> It will give an exception if there is a problem.
> you have to set Verbose = True on FbRestore/FbBackup so that the 
> program blocks until the backup is complete.
>
>         restore.Verbose = True
>         AddHandler restore.ServiceOutput, Sub(sender As Object, e As 
> ServiceOutputEventArgs)
>
>                                           End Sub
>
>
> On Fri, Mar 22, 2013 at 1:30 PM, Nicolas Timmers 
> <nft...@ho... <mailto:nft...@ho...>> wrote:
>
>     Hello everyone
>
>     I have a question,  when using the fbbackup on .net have a way to
>     know if the backup was completely sucesfull???
>
>     And wirh fbreatore??
>
>     Enviado pelo meu Windows Phone
>
>     ------------------------------------------------------------------------------
>     Everyone hates slow websites. So do we.
>     Make your web apps faster with AppDynamics
>     Download AppDynamics Lite for free today:
>     http://p.sf.net/sfu/appdyn_d2d_mar
>     _______________________________________________
>     Firebird-net-provider mailing list
>     Fir...@li...
>     <mailto:Fir...@li...>
>     https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
>
>
>
>
> ------------------------------------------------------------------------------
> Everyone hates slow websites. So do we.
> Make your web apps faster with AppDynamics
> Download AppDynamics Lite for free today:
> http://p.sf.net/sfu/appdyn_d2d_mar
>
>
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] fbbackup

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

------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_mar

Re: [Firebird-net-provider] fbbackup

[André K. <Kna...@be...>]

You can subscribe a method to the "ServiceOutput" event.
I  have  usually switched it off, because means a performance penalty,
but for debugging I usually turn it on.

Here is a small example which should put you into the right direction.
All   you   need   to   do   is   to   write   "e.Message"   from  the
ServiceOutputEventArgs e into a RichTextBox or similar.

FbBackup works the same as FbRestore in that aspect.

internal delegate void OnRestoreResultEventHandler(object sender, ServiceOutputEventArgs e);
internal static event OnRestoreResultEventHandler OnRestoreResult;

FbRestore _Restore    = new FirebirdSql.Data.Services.FbRestore();

_Restore.ServiceOutput += new ServiceOutputEventHandler(_Restore_ServiceOutput);
...
...
...

private static void _Restore_ServiceOutput(object sender, ServiceOutputEventArgs e)
{
  if (OnRestoreResult != null) OnRestoreResult(_Restore, e);
}

> Hello everyone

> I have a question,  when using the fbbackup on .net have a way to
> know if the backup was completely sucesfull???

> And wirh fbreatore??

> Enviado pelo meu Windows Phone


mit freundlichen Grüßen,

André Knappstein
EDV und Controlling
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
beta Eigenheim- und Grundstücksverwertungsgesellschaft mbH
Hafenweg 4
59192 Bergkamen-Rünthe

Telefon: +49 2389 9240 140
Telefax: +49 2389 9240 150
e-mail:  kna...@be...

Amtsgericht Hamm Nr. B 420
Geschäftsführer: Achim Krähling, Dirk Salewski und Matthias Steinhaus

USt-IDNr.: DE 125215402

Re: [Firebird-net-provider] fbbackup

[Gerdus v. Z. <ger...@gm...>]

It will give an exception if there is a problem.
you have to set Verbose = True on FbRestore/FbBackup so that the program
blocks until the backup is complete.

        restore.Verbose = True
        AddHandler restore.ServiceOutput, Sub(sender As Object, e As
ServiceOutputEventArgs)

                                          End Sub


On Fri, Mar 22, 2013 at 1:30 PM, Nicolas Timmers <nft...@ho...>wrote:

> Hello everyone
>
> I have a question,  when using the fbbackup on .net have a way to know if
> the backup was completely sucesfull???
>
> And wirh fbreatore??
>
> Enviado pelo meu Windows Phone
>
>
> ------------------------------------------------------------------------------
> Everyone hates slow websites. So do we.
> Make your web apps faster with AppDynamics
> Download AppDynamics Lite for free today:
> http://p.sf.net/sfu/appdyn_d2d_mar
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
>

<http://about.me/gerdus>

Re: [Firebird-net-provider] Code First Error

[MuthuAnnamalai <mut...@sb...>]

But the Model is created by C# Entity Framework Power tool and I checked the Image table mapping class which has mapping for primary key defined...

Sent from my iPad

On Mar 22, 2013, at 3:07 AM, Jiri Cincura <di...@ci...> wrote:

> On Fri, Mar 22, 2013 at 3:05 AM, Muthu Annamalai
> <mut...@sb...> wrote:
>> 
>> System.Data.Entity.Edm.EdmEntityType: EntityType ‘Image’ has no key
>> defined. Define the key for this EntityType.
>> 
>> System.Data.Entity.Edm.EdmEntitySet: EntityType  EntitySet ‘Images is
>> based on the type ‘Image’ that has no key defined. Define the key for this
>> EntityType.
> 
> I think this is pretty clear. You didn't specified the key(s) for your entity.
> 
>> All the tables in our database has primary key defined. And all the
> 
> Which is not relevant here. The error is about model, not database.
> 
>> primary keys have Description set to #PK_GEN#. Any clue to fix this error is
> 
> #PK_GEN# is used only when you *generate* EDM.
> 
> --
> Jiri {x2} Cincura (x2develop.com founder)
> http://blog.cincura.net/ | http://www.ID3renamer.com
> 
> ------------------------------------------------------------------------------
> Everyone hates slow websites. So do we.
> Make your web apps faster with AppDynamics
> Download AppDynamics Lite for free today:
> http://p.sf.net/sfu/appdyn_d2d_mar
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

[Firebird-net-provider] fbbackup

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

Hello everyone

I have a question,  when using the fbbackup on .net have a way to know if the backup was completely sucesfull???

And wirh fbreatore??

Enviado pelo meu Windows Phone

Re: [Firebird-net-provider] Code First Error

[Jiri C. <di...@ci...>]

On Fri, Mar 22, 2013 at 3:05 AM, Muthu Annamalai
<mut...@sb...> wrote:
>
> System.Data.Entity.Edm.EdmEntityType: EntityType ‘Image’ has no key
> defined. Define the key for this EntityType.
>
> System.Data.Entity.Edm.EdmEntitySet: EntityType  EntitySet ‘Images is
> based on the type ‘Image’ that has no key defined. Define the key for this
> EntityType.

I think this is pretty clear. You didn't specified the key(s) for your entity.

> All the tables in our database has primary key defined. And all the

Which is not relevant here. The error is about model, not database.

> primary keys have Description set to #PK_GEN#. Any clue to fix this error is

#PK_GEN# is used only when you *generate* EDM.

--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com

Re: [Firebird-net-provider] DDEX 3.0 upgrade problem

[Markus O. <ma...@gm...>]

On Tue, Mar 19, 2013 at 9:45 PM, Brian Liedtke <li...@fr...> wrote:
> The download side is confusing, it looks like the msi package
> is for all the listed versions of .NET. not just 4.5.

Indeed, I got confused there, too.
Great work with the provider though -- I'm happy I can continue using Firebird.

Thanks a lot!

Re: [Firebird-net-provider] DDEX 3.0 upgrade problem

[Brian L. <li...@fr...>]

Thanks, that got the update to work.

The download side is confusing, it looks like the msi package
is for all the listed versions of .NET. not just 4.5.

Now if I can figure out why I can not create a new entity data model.
I get the HRESULT E_FAIL ComException, but I suspect that
has something to do with Visual Studio.

Brian

-----Original Message----- 
From: André Knappstein
Sent: Tuesday, March 19, 2013 5:46 AM
To: For users and developers of the Firebird .NET providers
Subject: Re: [Firebird-net-provider] DDEX 3.0 upgrade problem

A common question and usually always the same answer.

You probably have this:
http://sourceforge.net/projects/firebird/files/firebird-net-provider/3.0.2/NETProvider-3.0.2.0.msi/download

But what you need is this:
http://sourceforge.net/projects/firebird/files/firebird-net-provider/3.0.2/NETProvider-3.0.2.0-NET40.7z/download

ciao,
André

Re: [Firebird-net-provider] DDEX 3.0 upgrade problem

[Jiri C. <di...@ci...>]

On Tue, Mar 19, 2013 at 12:46 PM, André Knappstein
<Kna...@be...> wrote:
> A common question and usually always the same answer.
>
> You probably have this:
> http://sourceforge.net/projects/firebird/files/firebird-net-provider/3.0.2/NETProvider-3.0.2.0.msi/download
>
> But what you need is this:
> http://sourceforge.net/projects/firebird/files/firebird-net-provider/3.0.2/NETProvider-3.0.2.0-NET40.7z/download

Yep. Andre is right.


-- 
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com

Re: [Firebird-net-provider] DDEX 3.0 upgrade problem

[André K. <Kna...@be...>]

A common question and usually always the same answer.

You probably have this:
http://sourceforge.net/projects/firebird/files/firebird-net-provider/3.0.2/NETProvider-3.0.2.0.msi/download

But what you need is this:
http://sourceforge.net/projects/firebird/files/firebird-net-provider/3.0.2/NETProvider-3.0.2.0-NET40.7z/download

ciao,
André


> Ok, I've rolled back the DDEX to the previous version of 2.0.5, but I am still
> getting the same error.

> So, do you mean that the latest data provider is for 4.5 also?

> Here is what is in the GAC:

> gacutil /l FirebirdSql.Data.FirebirdClient
> Microsoft (R) .NET Global Assembly Cache Utility.  Version 4.0.30319.1
> Copyright (c) Microsoft Corporation.  All rights reserved.

> The Global Assembly Cache contains the following assemblies:
>   FirebirdSql.Data.FirebirdClient, Version=3.0.2.0,
> Culture=neutral, PublicKeyToken=3750abcc3150b00c, processorArchitecture=MSIL

> Number of items = 1

> gacutil /l FirebirdSql.VisualStudio.DataTools
> Microsoft (R) .NET Global Assembly Cache Utility.  Version 4.0.30319.1
> Copyright (c) Microsoft Corporation.  All rights reserved.

> The Global Assembly Cache contains the following assemblies:
>   FirebirdSql.VisualStudio.DataTools, Version=2.0.5.0,
> Culture=neutral, PublicKeyToken=bae6c78ccb0fcdb3, processorArchitecture=MSIL

> Number of items = 1

> -----Original Message----- 
> From: Jiri Cincura 
> Sent: Monday, March 18, 2013 3:12 PM 
> To: For users and developers of the Firebird .NET providers 
> Subject: Re: [Firebird-net-provider] DDEX 3.0 upgrade problem 

> You're using version for .NET 4.5 very likely, but you're developing
> for previous version.





mit freundlichen Grüßen,

André Knappstein
EDV und Controlling
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
beta Eigenheim- und Grundstücksverwertungsgesellschaft mbH
Hafenweg 4
59192 Bergkamen-Rünthe

Telefon: +49 2389 9240 140
Telefax: +49 2389 9240 150
e-mail:  kna...@be...

Amtsgericht Hamm Nr. B 420
Geschäftsführer: Achim Krähling, Dirk Salewski und Matthias Steinhaus

USt-IDNr.: DE 125215402

Re: [Firebird-net-provider] DDEX 3.0 upgrade problem

[Brian L. <li...@fr...>]

Ok, I've rolled back the DDEX to the previous version of 2.0.5, but I am still
getting the same error.

So, do you mean that the latest data provider is for 4.5 also?

Here is what is in the GAC:

gacutil /l FirebirdSql.Data.FirebirdClient
Microsoft (R) .NET Global Assembly Cache Utility.  Version 4.0.30319.1
Copyright (c) Microsoft Corporation.  All rights reserved.

The Global Assembly Cache contains the following assemblies:
  FirebirdSql.Data.FirebirdClient, Version=3.0.2.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c, processorArchitecture=MSIL

Number of items = 1

gacutil /l FirebirdSql.VisualStudio.DataTools
Microsoft (R) .NET Global Assembly Cache Utility.  Version 4.0.30319.1
Copyright (c) Microsoft Corporation.  All rights reserved.

The Global Assembly Cache contains the following assemblies:
  FirebirdSql.VisualStudio.DataTools, Version=2.0.5.0, Culture=neutral, PublicKeyToken=bae6c78ccb0fcdb3, processorArchitecture=MSIL

Number of items = 1

-----Original Message----- 
From: Jiri Cincura 
Sent: Monday, March 18, 2013 3:12 PM 
To: For users and developers of the Firebird .NET providers 
Subject: Re: [Firebird-net-provider] DDEX 3.0 upgrade problem 

You're using version for .NET 4.5 very likely, but you're developing
for previous version.


-- 
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com

------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_mar
_______________________________________________
Firebird-net-provider mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] DDEX 3.0 upgrade problem

[Brian L. <li...@fr...>]

Ok, I just saw that version 3.0 was for VS 2005 thru 2012 and thought it would
support other .Net versions, not just 4.5 framework. Now I just have to find my
old DDEX installation package in my archives. Unless it is buried on the
Firebird website someplace?

Thanks Jiri,
Brian

-----Original Message----- 
From: Jiri Cincura 
Sent: Monday, March 18, 2013 3:12 PM 
To: For users and developers of the Firebird .NET providers 
Subject: Re: [Firebird-net-provider] DDEX 3.0 upgrade problem 

You're using version for .NET 4.5 very likely, but you're developing
for previous version.


-- 
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com

------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_mar
_______________________________________________
Firebird-net-provider mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] DDEX 3.0 upgrade problem

[Jiri C. <di...@ci...>]

You're using version for .NET 4.5 very likely, but you're developing
for previous version.


-- 
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com

[Firebird-net-provider] DDEX 3.0 upgrade problem

[Brian L. <li...@fr...>]

I just upgraded to Firebird 2.5.1, .NET provider 3.0.2.0, and DDEX 3.0.0.0. for Windows (7 64-bit).

On the previous versions of the tools, I had created an entity data source with no problem.

Now when I try to upgrade that data source, The wizard gives the error

"... An exception of type 'System.Data.ProviderIncompatibleException' occurred. The error message is"
'The store data provider failed to return information for the StoreSchemaDefinition request.' ... The inner exception
caught was of type 'System.MissingFieldException', with this error message" 'Field not found:
'System.Data.Common.DbProviderManifest.StoreSchemaDefinitionVersion3'.'."

If I try to create a new entity data source in this, or a new solution, I get the error
"An exception of type 'System.Runtime.InteropServices.COMException' occurred
while attempting to launch Entity Data Model Wizard. The exception message is
'Error HRESULT E_FAIL has been returned from a call to a COM component.'"

Since I can manipulate and create a database. The libraries and .NET provider look OK.
The problem seems to be with the DDEX provider. I have gone through the README.
Everything looks like it installed OK, the assemblies are in the GAC, the machine.config
looks correct. The only thing is the *.reg files, which aren't in the DDEX 3.0 installation package.
I assume that the .msi installation file takes care of that.

My question is, what are they proper registry entries? Or is there something else I am missing?
I have been scouring the web for solutions the past two days to no avail.

Brian

[Firebird-net-provider] Cannot "Update Model from Database" in Visual Studio 2012 Pro

[Michael E. <meu...@id...>]

Hello,
I am using Windows 7 and Visual Studio 2012. I upgraded a project from
Visual Studio 2010 and installed the new .net provider
(NETProvider-3.0.2.0.msi). After uninstalling the old version, it installed
file but it does not seem to install the components needed to "Update Model
from Database". This is the error I get:
An exception of type
'Microsoft.VSDesigner.Data.Local.ConnectionStringConverterServiceException'
occurred while
attempting to upgrade from database. The exception message is:''.

Also, when I attempt to connect to a Firebird database using the "Server
Explorer", Firebird is not listed. Any ideas??

Michael Eubanks