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

[Firebird-net-provider] [FB-Tracker] Created: (DNET-543) Could not load type 'FirebirdSql.Data.FirebirdClient.FbConnectionString' from assembly 'FirebirdSql.Data.FirebirdClient'

[Rustam R. (JIRA) <tr...@fi...>]

Could not load type 'FirebirdSql.Data.FirebirdClient.FbConnectionString' from assembly 'FirebirdSql.Data.FirebirdClient'
------------------------------------------------------------------------------------------------------------------------

                 Key: DNET-543
                 URL: http://tracker.firebirdsql.org/browse/DNET-543
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 4.1.0.0
         Environment: .NET 4.5; Firebird 2.5.2; Firebird ADO.NET Data Provider 4.1.0.0; MonoDevelop 4.0.1, Unity 4.3.4f1 
            Reporter: Rustam Rakhimov
            Assignee: Jiri Cincura
            Priority: Minor


Executing the following code:

using UnityEngine;
using System.Collections;
using System.Data;
using FirebirdSql.Data.FirebirdClient;

public class SQLConnection : MonoBehaviour {

	void Start () {
		string conn = "Database=D:\\DB\\MAIN.FDB;" + "User=SYSDBA;" + "Password=masterkey;" + "Dialect=3;" + "Server=localhost";
		FbConnection dbcon = new FbConnection(conn);
	}

}

raises an exception:

TypeLoadException: Could not load type 'FirebirdSql.Data.FirebirdClient.FbConnectionString' from assembly 'FirebirdSql.Data.FirebirdClient, Version=4.1.0.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c'.
(wrapper remoting-invoke-with-check) FirebirdSql.Data.FirebirdClient.FbConnection:.ctor (string)
SQLConnection.Start () (at Assets/SQLConnection.cs:11)

Library file "FirebirdSql.Data.FirebirdClient.dll" is in the Unity project folder (Assets/Plugins)

-- 
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] Fwd: [firebird-support] An unhandled exception of type 'System.NotSupportedException' occurred in FirebirdSql.Data.FirebirdClient.dll

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

The ADO.NET stack is not available in WinRT, hence you cannot use any
database access. The CF version didn't helped either.


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

[Firebird-net-provider] Fwd: [firebird-support] An unhandled exception of type 'System.NotSupportedException' occurred in FirebirdSql.Data.FirebirdClient.dll

[narendra d. <nk...@gm...>]

I am creating a project windows runtime component with c# , I want to
create a embedded DB so i am using "Firebird-2.5.2.26540-0_x64_embed" and
.net provider "NETProvider-2.5.2-CF" .....


every time i am getting same error: " An unhandled exception of type
'System.NotSupportedException' occurred in
FirebirdSql.Data.FirebirdClient.dll ".

my project is not targeted to any .net framework because it is only WinRT(
c# )...

Please help me guys..please reply
__,_._,___
 for ref of my question:
https://groups.yahoo.com/neo/groups/firebird-support/conversations/topics/123803

Re: [Firebird-net-provider] No lazy loading?

[Sibylle K. <nul...@we...>]

Am 09.02.2014 15:52, schrieb Jiri Cincura:
> Show us the code.
>

Ok:

  --- Model classes:

class CHILDDATA
{
	public int CHILDID { get; set; }
	public int MOTHERID { get; set; }
	public string CHILDNAME { get; set; }
	public virtual MOTHERDATA Mother { get; set; }
}

class MOTHERDATA
{
	public int MOTHERID { get; set; }
	public string MOTHERNAME { get; set; }
	public virtual ICollection<CHILDDATA> Children { get; set; }

	public MOTHERDATA()
	{
		Children = new List<CHILDDATA>();
	}
}

  --- Context class:

class SingleMothersDB : DbContext
{
     public DbSet<MOTHERDATA> MotherRecords { get; set; }
     public DbSet<CHILDDATA> ChildRecords { get; set; }

     public SingleMothersDB()
         : base(new FbConnection(@"database=localhost:singlemothers; 
user=sib; password=immergut"), true)
     { }

     protected override void OnModelCreating(DbModelBuilder modelBuilder)
     {
         modelBuilder.Conventions.Remove<PluralizingTableNameConvention>();
         modelBuilder.Entity<MOTHERDATA>().HasKey(m => m.MOTHERID);
         modelBuilder.Entity<MOTHERDATA>().Property(m => m.MOTHERNAME)
             .IsRequired().HasMaxLength(50);
         modelBuilder.Entity<CHILDDATA>().HasKey(c => c.CHILDID);
         modelBuilder.Entity<CHILDDATA>().Property(c => c.CHILDNAME)
             .IsRequired().HasMaxLength(50);
     }
}

  --- Application:

class Program
{
static void ShowMothersWithChildren(SingleMothersDB db)
{
     Console.WriteLine("Show mothers and their children");
     Console.WriteLine("Lazy loading enabled: {0}",
         db.Configuration.LazyLoadingEnabled);
     Console.WriteLine("Proxy creation enabled: {0}",
         db.Configuration.ProxyCreationEnabled);
     var motherquery = from m in db.MotherRecords
                       orderby m.MOTHERNAME
                       select m;
     foreach (var m in motherquery)
     {
         int childcount = m.Children.Count();
         Console.WriteLine("{0} (ID {1}) has {2} children:",
             m.MOTHERNAME, m.MOTHERID, childcount);
         foreach (var c in m.Children)
         {
             Console.WriteLine("{0} (ID {1})",
                 c.CHILDNAME, c.CHILDID);
         }
         Console.WriteLine();
     }
}

static void ShowChildrenWithMothers(SingleMothersDB db)
{
     Console.WriteLine("Show children and their mothers");
     Console.WriteLine("Lazy loading enabled: {0}",
         db.Configuration.LazyLoadingEnabled);
     Console.WriteLine("Proxy creation enabled: {0}",
         db.Configuration.ProxyCreationEnabled);
     var childquery = from c in db.ChildRecords
                      orderby c.CHILDNAME
                      select c;
     foreach (var c in childquery)
     {
         string mothername = (c.Mother == null ?
             "unknown" : c.Mother.MOTHERNAME);
         Console.WriteLine("{0} (Id {1}) is a child of {2}",
             c.CHILDNAME, c.CHILDID, mothername);
     }
     Console.WriteLine();
}

static void Main(string[] args)
{
     Database.SetInitializer<SingleMothersDB>(null);
     using (SingleMothersDB context =
         new SingleMothersDB())
     {
         ShowChildrenWithMothers(context);
         ShowMothersWithChildren(context);
     }
     Console.WriteLine("Press any key to continue ...");
     Console.ReadKey();
}
}

And the metadata for the database, if that's useful:

/********************* ROLES **********************/

CREATE ROLE RDB$ADMIN;
/********************* UDFS ***********************/

/****************** GENERATORS ********************/

CREATE GENERATOR S_CHILD;
CREATE GENERATOR S_MOTHER;
/******************** DOMAINS *********************/

/******************* PROCEDURES ******************/

/******************** TABLES **********************/

CREATE TABLE CHILDDATA
(
   CHILDID Integer NOT NULL,
   MOTHERID Integer NOT NULL,
   CHILDNAME Varchar(50) NOT NULL,
   PRIMARY KEY (CHILDID),
   UNIQUE (CHILDNAME)
);
CREATE TABLE MOTHERDATA
(
   MOTHERID Integer NOT NULL,
   MOTHERNAME Varchar(50) NOT NULL,
   PRIMARY KEY (MOTHERID),
   UNIQUE (MOTHERNAME)
);
/********************* VIEWS **********************/

/******************* EXCEPTIONS *******************/

/******************** TRIGGERS ********************/

SET TERM ^ ;
CREATE TRIGGER SET_CHILDID FOR CHILDDATA ACTIVE
BEFORE INSERT POSITION 0
AS BEGIN
	IF (NEW.childid IS NULL) THEN
		NEW.childid = NEXT VALUE FOR s_child;
END^
SET TERM ; ^
SET TERM ^ ;
CREATE TRIGGER SET_MOTHERID FOR MOTHERDATA ACTIVE
BEFORE INSERT POSITION 0
AS BEGIN
	IF (NEW.motherid IS NULL) THEN
		NEW.motherid = NEXT VALUE FOR s_mother;
END^
SET TERM ; ^

ALTER TABLE CHILDDATA ADD
   FOREIGN KEY (MOTHERID) REFERENCES MOTHERDATA (MOTHERID);


Thank you,
Sibylle

Re: [Firebird-net-provider] No lazy loading?

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

Show us the code.


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

[Firebird-net-provider] No lazy loading?

[Sibylle K. <nul...@we...>]

Hello,

I can't get lazy loading to work as I think it should.

Parts of the problem: Entity Framework 6.0.2, Firebird ADO.NET provider 
4.1.0.0 (Entity Framework 6), Visual Studio 2012 Professional, Firebird 
2.5.2, Windows 7. Database server on localhost.

Two related tables:

motherdata, fields motherid (primary key, generated by sequence), 
mothername (varchar(50), not null).
childdata, fields childid (primary key, generated by sequence), motherid 
(foreign key), childname (varchar(50), not null).

Model classes with virtual navigation properties.

Configuration.LazyLoadingEnabled, Configuration.ProxyCreationEnabled are 
both true for the DbContext derived class.

Console application with two functions: ShowMothersWithChildren, 
ShowChildrenWithMothers. Both just print the data to the console, one 
every motherdata record with a list of related childdata records, one 
every childdata record with the related motherdata info.

The main function creates the DbContext derived class and calls the two 
functions. Between runs I change the order of the calls. The first 
function called doesn't show the related data: empty childdata lists for 
motherdata records, null for related motherdata in childdata record. The 
second call works as expected.

Bug in the provider? Or my bug (in which case I probably should provide 
more details)?

Thank you for help,
Sibylle

[Firebird-net-provider] [FB-Tracker] Created: (DNET-542) EF6's FunctionReturnTableColumns and FunctionFunctionReturnTableColumns set not handled

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

EF6's FunctionReturnTableColumns and FunctionFunctionReturnTableColumns set not handled
---------------------------------------------------------------------------------------

                 Key: DNET-542
                 URL: http://tracker.firebirdsql.org/browse/DNET-542
             Project: .NET Data provider
          Issue Type: Bug
          Components: Entity Framework support
    Affects Versions: 4.1.0.0, 4.0.0.0
            Reporter: Jiri Cincura
            Assignee: Jiri Cincura
            Priority: Minor


An error occurred while connecting to the database. The database might be unavailable. An exception of type 'System.Data.Entity.Core.EntityCommandCompilationException' occurred. The error message is: 'An error occurred while preparing the command definition. See the inner exception for details.
The inner exception caught was of type 'System.Data.Entity.Core.MappingException', with this error message: '
StoreSchemaMappingVersion3(3,4) : error 3027: No mapping specified for the following EntitySet/AssociationSet - FunctionReturnTableColumns, FunctionFunctionReturnTableColumns.'.'.


-- 
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] EF6.0 Reverse Engineering

[Morten M. <mo...@my...>]

Hi all,

 

I've downloaded and installed Firebird .Net provider 4.1.0.0 and
DDEXProvider 3.0.1.0, and tried to reverse engineer a Firebird database
using Entity Framework 6, but get an exception right after clicking OK in
the "Connection Properties" dialog:

 

System.Data.ProviderIncompatibleException: A null was returned after calling
the 'GetService' method on a store provider instance of type
'FirebirdSql.Data.FirebirdClient.FirebirdClientFactory'. The store provider
might not be functioning correctly.

   at
System.Data.Entity.Design.Common.MetadataUtil.GetProviderServices(DbProvider
Factory factory)

   at
System.Data.Entity.Design.EntityStoreSchemaGenerator.CreateStoreSchemaConnec
tion(String providerInvariantName, String connectionString, Version
targetEntityFrameworkVersion)

   at
System.Data.Entity.Design.SsdlGenerator.EntityStoreSchemaGeneratorDatabaseSc
hemaLoader.CreateStoreSchemaConnection(String providerInvariantName, String
connectionString, Version& storeSchemaModelVersion)

   at System.Data.Entity.Design.EntityStoreSchemaGenerator..ctor(String
providerInvariantName, String connectionString, String namespaceName)

   at
Microsoft.DbContextPackage.Handlers.ReverseEngineerCodeFirstHandler.ReverseE
ngineerCodeFirst(Project project)

 

I'm able to add the database to Server Explorer without problems, so I know
the database is up and running ok.

Anyone have any clue as to what the problem may be? Any response would be
greatly appreciated. J 

 

Regards,
Morten



---
This email is free from viruses and malware because avast! Antivirus protection is active.
http://www.avast.com

[Firebird-net-provider] FirebirdClient as COM

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

Hi *,

I'm reading now DNET-521. It looks like a simple change in
AssemblyInfo, but is there some caveat doing that? I'm not that much
COM expert.

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

[Firebird-net-provider] DDEX 3.0.1

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

Hi *,

DDEX provider for Firebird has just been released. More info
http://blog.cincura.net/233441-ddex-provider-3-0-1-for-firebird-released/
.

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

[Firebird-net-provider] [FB-Tracker] Created: (DNET-541) Unhandled NullReferenceException when closing FbRemoteEvent

[G. K. (JIRA) <tr...@fi...>]

Unhandled NullReferenceException when closing FbRemoteEvent
-----------------------------------------------------------

                 Key: DNET-541
                 URL: http://tracker.firebirdsql.org/browse/DNET-541
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 4.1.0.0
         Environment: WPF application, .Net 4.5 (c#) , Firebird Server 2.5.2.26536 accessed via 127.0.0.1, VS2012 on Win7 x64 Prof.
            Reporter: G. Krug
            Assignee: Jiri Cincura
            Priority: Blocker



I have opened an event registration like shown in example at http://www.firebirdsql.org/en/net-examples-of-use/ . 
CreateConnection creates a new unpooled connection which is only used for this event (beside other connections with Pooling=true) :

FbRemoteEventEventHandler handler = new FbRemoteEventEventHandler(this.Update_Event);

FbConnection conn = CreateConnection();
FbRemoteEvent rv = new FbRemoteEvent(conn, dbEventNames);
  rv.RemoteEventCounts += new FbRemoteEventEventHandler(handler);
  rv.QueueEvents();

private void Update_Event(object sender, FbRemoteEventEventArgs e)
{
  // do something
}

The registered event(s) are working fine then. If I want to stop event processing with


fbEvent.RemoteEventCounts -= handler;
 // In most cases an unhandled NullReferenceException is thrown, we can not catch it here
 try
 {
      fbEvent.CancelEvents();
 }
      catch (NullReferenceException nre)
{
                        // ignore, but log to debug output
}
if (conn .State != ConnectionState.Closed)
{
       conn .Close();
}
conn.Dispose();

// hereafter
 an unhandled exception is thrown as follows:

Exception: System.NullReferenceException: Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt.
   bei FirebirdSql.Data.Common.RemoteEvent.EventCounts(Byte[] buffer) in c:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\source\FirebirdSql\Data\Common\RemoteEvent.cs:Zeile 179.
   bei FirebirdSql.Data.Client.Managed.Version10.GdsEventManager.<>c__DisplayClassa.<ThreadHandler>b__7(Object param0) in c:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\source\FirebirdSql\Data\Client\Managed\Version10\GdsEventManager.cs:Zeile 201.
   bei System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Int32 numArgs)
   bei MS.Internal.Threading.ExceptionFilterHelper.TryCatchWhen(Object source, Delegate method, Object args, Int32 numArgs, Delegate catchHandler)

When stepping through the code inside my application there is a method in RemoteEvent.cs which is called after cancelling events, closing and disposing connection of that event (see code above):

		public void EventCounts(byte[] buffer)
		{
			int pos = 1;
			Charset charset = this.db.Charset;
....

and this Charset is already null which will lead to the reported exception. As it is thrown asynchronously on the internal worker thread the exception gets not catched by the main thread.
Both parts of code are getting called from main thread in an WPF application.
This problem is not reproducible with 4.0.0.0 but I had to update to the newest version due to other bugs in there.

If there is any way to resolve this immediately, please post here,

Thank you in advance.




-- 
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] Remote Connection to Firebird 3.0

[Norbert <nor...@si...>]

Il se trouve que LtColRDSChauhan a formulé :
> Hello,
>
> How do i connect to a Remote Firebird 3.0 server.
> Thanks in advance please.
>
> Regards,
> Lt Col (Retd) Rajiv Dular Singh Chauhan

the only way to actually use dotnet & FB3 it is embded user with write 
rights on the DB name instances of web processes (IIS 7)
Norbert

-- 
..
TetraSys

http://www.tetrasys.eu

Re: [Firebird-net-provider] Remote Connection to Firebird 3.0

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

On Tue, Jan 14, 2014 at 1:07 AM, LtColRDSChauhan <rds...@gm...> wrote:
> How do i connect to a Remote Firebird 3.0 server.

Same as to previous. Don't forget to enable "old" auth on server. The
new is not supported (yet).

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

[Firebird-net-provider] Remote Connection to Firebird 3.0

[LtColRDSChauhan <rds...@gm...>]

Hello,

How do i connect to a Remote Firebird 3.0 server.
Thanks in advance please.

Regards,
Lt Col (Retd) Rajiv Dular Singh Chauhan

[Firebird-net-provider] ddex 3.0.0.0 advanced properties

[EJ <edj...@gm...>]

trying to access a remote database server and getting this error

---------------------------
Microsoft Visual Studio
---------------------------
Unable to complete network request to host "192.168.1.98".
---------------------------
OK
---------------------------

I'm having this as the name of the database file in ddex

server type is standalone server

i have this in database box

192.168.1.98:C:\folder\database.fdb

wonder what the advanced properties are and if i need to set them - i tried
to go in and adjust some like the "isolation level" but it does not save
the settings i pick there. where is a list of settings for advanced
properties and how do i set them?

Re: [Firebird-net-provider] DDEX 3.0.0.0 compatibility with firebird client versions

[EJ <edj...@gm...>]

i tried running 2.5 in dev and it's still giving the same error


On Fri, Jan 10, 2014 at 9:30 AM, Jiri Cincura <di...@ci...> wrote:

> On Fri, Jan 10, 2014 at 1:14 PM, EJ <edj...@gm...> wrote:
> > do i need to run 2.5 instead?
>
> Yes, for development.
>
> --
> Jiri {x2} Cincura (x2develop.com founder)
> http://blog.cincura.net/ | http://www.ID3renamer.com
>
>
> ------------------------------------------------------------------------------
> CenturyLink Cloud: The Leader in Enterprise Cloud Services.
> Learn Why More Businesses Are Choosing CenturyLink Cloud For
> Critical Workloads, Development Environments & Everything In Between.
> Get a Quote or Start a Free Trial Today.
>
> http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

Re: [Firebird-net-provider] DDEX 3.0.0.0 compatibility with firebird client versions

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

On Fri, Jan 10, 2014 at 1:14 PM, EJ <edj...@gm...> wrote:
> do i need to run 2.5 instead?

Yes, for development.

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

Re: [Firebird-net-provider] DDEX 3.0.0.0 compatibility with firebird client versions

[EJ <edj...@gm...>]

actually i just tried uninstalling 2.1 and installed latest 2.5 and get the
same exact error


On Fri, Jan 10, 2014 at 6:14 AM, EJ <edj...@gm...> wrote:

> i'm runnin 2.1.5.18497 firebird client and get this error when trying to
> add entities to the model - do i need to run 2.5 instead?
>
> Unable to generate the model because of the following exception: 'An error
> occurred while executing the command definition. See the inner exception
> for details.
>
> Dynamic SQL Error
>
> SQL error code = -504
>
> CHARACTER SET UTF8 is not defined
>
>  Dynamic SQL Error
>
> SQL error code = -504
>
> CHARACTER SET UTF8 is not defined
>
>
>
>
> On Thu, Jan 9, 2014 at 8:07 AM, Jiri Cincura <di...@ci...> wrote:
>
>> On Thu, Jan 9, 2014 at 1:16 PM, EJ <edj...@gm...> wrote:
>> > is there a particular version of firebird that this ddex is and is not
>> > compatible with?
>>
>> DDEX is compatible with all Firebird server version.
>>
>> >From the error I guess, you're not that much interested in DDEX, but
>> in Entity Framework. There you need for *run* at least 2.1 (with some
>> limitations).
>>
>> --
>> Jiri {x2} Cincura (x2develop.com founder)
>> http://blog.cincura.net/ | http://www.ID3renamer.com
>>
>>
>> ------------------------------------------------------------------------------
>> CenturyLink Cloud: The Leader in Enterprise Cloud Services.
>> Learn Why More Businesses Are Choosing CenturyLink Cloud For
>> Critical Workloads, Development Environments & Everything In Between.
>> Get a Quote or Start a Free Trial Today.
>>
>> http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk
>> _______________________________________________
>> Firebird-net-provider mailing list
>> Fir...@li...
>> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>>
>
>

Re: [Firebird-net-provider] DDEX 3.0.0.0 compatibility with firebird client versions

[EJ <edj...@gm...>]

i'm runnin 2.1.5.18497 firebird client and get this error when trying to
add entities to the model - do i need to run 2.5 instead?

Unable to generate the model because of the following exception: 'An error
occurred while executing the command definition. See the inner exception
for details.

Dynamic SQL Error

SQL error code = -504

CHARACTER SET UTF8 is not defined

 Dynamic SQL Error

SQL error code = -504

CHARACTER SET UTF8 is not defined




On Thu, Jan 9, 2014 at 8:07 AM, Jiri Cincura <di...@ci...> wrote:

> On Thu, Jan 9, 2014 at 1:16 PM, EJ <edj...@gm...> wrote:
> > is there a particular version of firebird that this ddex is and is not
> > compatible with?
>
> DDEX is compatible with all Firebird server version.
>
> >From the error I guess, you're not that much interested in DDEX, but
> in Entity Framework. There you need for *run* at least 2.1 (with some
> limitations).
>
> --
> Jiri {x2} Cincura (x2develop.com founder)
> http://blog.cincura.net/ | http://www.ID3renamer.com
>
>
> ------------------------------------------------------------------------------
> CenturyLink Cloud: The Leader in Enterprise Cloud Services.
> Learn Why More Businesses Are Choosing CenturyLink Cloud For
> Critical Workloads, Development Environments & Everything In Between.
> Get a Quote or Start a Free Trial Today.
>
> http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

Re: [Firebird-net-provider] DDEX 3.0.0.0 compatibility with firebird client versions

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

On Thu, Jan 9, 2014 at 1:16 PM, EJ <edj...@gm...> wrote:
> is there a particular version of firebird that this ddex is and is not
> compatible with?

DDEX is compatible with all Firebird server version.

>From the error I guess, you're not that much interested in DDEX, but
in Entity Framework. There you need for *run* at least 2.1 (with some
limitations).

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

Re: [Firebird-net-provider] DDEX 3.0.0 0 type initializer for 'FirebirdSql.Data.Common.TimeoutHelper' threw an exception

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

On Thu, Jan 9, 2014 at 1:15 PM, EJ <edj...@gm...> wrote:
> there is a bug in the installer that was putting on the 45 version when i
> only had 40

Installer installs only 4.5 version.


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

[Firebird-net-provider] DDEX 3.0.0.0 compatibility with firebird client versions

[EJ <edj...@gm...>]

i'm trying to run with firebird 1.5 client and am getting the following
error when i try to add a new entity framework model

---------------------------
Microsoft Visual Studio
---------------------------
An error occurred while connecting to the database. The database might be
unavailable. An exception of type
'System.Data.EntityCommandExecutionException' occurred. The error message
is: 'An error occurred while executing the command definition. See the
inner exception for details.
The inner exception caught was of type
'FirebirdSql.Data.FirebirdClient.FbException', with this error message:
'Dynamic SQL Error
SQL error code = -104
Token unknown - line 6, column 8
SELECT'.
The inner exception caught was of type
'FirebirdSql.Data.Common.IscException', with this error message: 'Dynamic
SQL Error
SQL error code = -104
Token unknown - line 6, column 8
SELECT'.'.
---------------------------
OK
---------------------------

is there a particular version of firebird that this ddex is and is not
compatible with?

Re: [Firebird-net-provider] DDEX 3.0.0 0 type initializer for 'FirebirdSql.Data.Common.TimeoutHelper' threw an exception

[EJ <edj...@gm...>]

thanks - manually installing 4.0 worked - apparently there is a bug in the
installer that was putting on the 45 version when i only had 40 and vs 2010
just FYI


On Sun, Jan 5, 2014 at 11:18 PM, Jiri Cincura <di...@ci...> wrote:

> You installed provider version for .NET 4.5.
>
>
> --
> Jiri {x2} Cincura (x2develop.com founder)
> http://blog.cincura.net/ | http://www.ID3renamer.com
>
>
> ------------------------------------------------------------------------------
> Rapidly troubleshoot problems before they affect your business. Most IT
> organizations don't have a clear picture of how application performance
> affects their revenue. With AppDynamics, you get 100% visibility into your
> Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics
> Pro!
> http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

Re: [Firebird-net-provider] DDEX 3.0.0 0 type initializer for 'FirebirdSql.Data.Common.TimeoutHelper' threw an exception

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

You installed provider version for .NET 4.5.


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

Re: [Firebird-net-provider] Stored Procedure in Entity Framework

[PRS <ps...@cc...>]

I have installed the latest version of the Firebird ADO.Net Data Provider v
4.1.0 using Nuget in Visual Studio, and tried to import this stored
procedure again, but still no luck.

Has anybody been able to import a Firebird stored procedure into an entity
model successfully?

Thanks



--
View this message in context: http://firebird.1100200.n4.nabble.com/Stored-Procedure-in-Entity-Framework-tp4634673p4634839.html
Sent from the firebird-net-provider mailing list archive at Nabble.com.