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

Hi, At February 10, 2017, 8:12 AM, Jiří Činčura wrote: >> it(when compiled). And, since the application that is calling this >> .dll is not a .Net application(it's a native Win32 Delphi >> application), I am trying to find out how to setup the entity > Again. You're not saying how are you

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

Hi, At February 10, 2017, 8:13 AM, Jiří Činčura wrote: > Also, if you'd read my blog, you'd have been done already: > https://blog.cincura.net/233368-configuring-3rd-party-entity-framework-provider-firebird-from-code/ > ;) Thanks, that's what I was looking for. I do remember coming across it,

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

Also, if you'd read my blog, you'd have been done already: https://blog.cincura.net/233368-configuring-3rd-party-entity-framework-provider-firebird-from-code/ ;) -- Mgr. Jiří Činčura Independent IT Specialist -- Check

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

> An exception of type 'System.InvalidOperationException' occurred in > EntityFramework.dll but was not handled in user code > > Additional information: No Entity Framework provider found for the > ADO.NET provider with invariant name > 'FirebirdSql.Data.FirebirdClient'. Make sure the provider is

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

Title: Re: [Firebird-net-provider] Entity Framework 6 Hi, At February 9, 2017, 6:52 PM, Paul Dryden wrote: I have have had problems using Windows Entity Data Framework. In some cases, I can't open an edmx file in Visual Studio (that I had compiled from scanning a database perhaps a year

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

Hi, At February 10, 2017, 3:28 AM, Jiří Činčura wrote: > Well, you're not saying anything specific about the exception (at least > which provider - EF or ADO.NET?) nor how's the assembly loaded (because > you can as well use the config file, depending on how it's loaded). > Let's guess that

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

Well, you're not saying anything specific about the exception (at least which provider - EF or ADO.NET?) nor how's the assembly loaded (because you can as well use the config file, depending on how it's loaded). Let's guess that it's a ADO.NET provider, then you're probably missing the

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

I have have had problems using Windows Entity Data Framework. In some cases, I can't open an edmx file in Visual Studio (that I had compiled from scanning a database perhaps a year earlier, always receiving "Provider Not Found." Very frustrating. I am now considering switching to MySql, even

[Firebird-net-provider] Entity Framework 6

Hi, I'm trying to use the Firebird ADO.Net with Entity Framework 6. I'm able to create a code first model from an existing database. But, when trying to establish a connection, it is telling me that a provider is not registered. My scenario is that the connection is done in a DLL, not

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

OK, looks like this is not a problem, so I created DNET-732 for it and it will eventually happen. -- Mgr. Jiří Činčura Independent IT Specialist On Tue, Jan 10, 2017, at 18:27, Jiří Činčura wrote: > > Too much effort? > > Correct. > > Currently MS's story is only EF6 and EFCore so I don't

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

> Too much effort? Correct. Currently MS's story is only EF6 and EFCore so I don't want to waste too much of my free time on anything extra. Considering the move to EF6 from EF5 is not that difficult I don't see much reasons to keep it (and there has been plenty of time to do it). And of course

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

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] Entity Framework 5

> Have you considered supporting two separate libraries? In two separate > branches/nuget and so on? Not really. -- Mgr. Jiří Činčura Independent IT Specialist -- Developer Access Program for Intel Xeon Phi Processors

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

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

[Firebird-net-provider] Entity Framework 5

Hi *, anybody still using EF5 (or even EF4)? Or is everybody on EF6... Thinking about slimming the FirebirdSql.Data.FirebirdClient and removing the old EF support and keeping only EF6 (EntityFramework.Firebird). -- Mgr. Jiří Činčura Independent IT Specialist

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

: Saturday, March 26, 2016 12:52 PM To: For users and developers of the Firebird .NET providers Subject: Re: [Firebird-net-provider] Entity Framework: Best practices to workin a multiuser environment > Indeed. It's EF poor design, that they try to rework in EF core. > Still there are plenty of worka

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

> 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 > entities only by ids. Attaching by ID? It's still attaching... > DbContext is supposed to be used in request-response scenario (web > sites, for example),

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

> 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 work in a multiuser environment

> > 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. That doesn't make any sense. If I dispose context after query then I can't update the entities

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

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

> a) Is the method described above considered as good practice? From what you've written, yes. > b) Basically it is a connected Context until the user refreshes the data. > In > this case the context is recreated. No problem with that. > c) In order to manage multiuser environment, do I need

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

Hello all, I am using EF 6.0 with Firebird 4.10 and have same questions about best practices. It is an WPF/MVVM application that runs in a multiuser environment. 1. There is a static class to create the connection string AppGlobals

Re: [Firebird-net-provider] Entity Framework not importing stored procedures

Entity Framework (EF) is an object-relational mapper that enables .NET developers to work with relational data using domain-specific objects. It eliminates the need for most of the data-access code that developers usually need to write. with the help of this, i think it can import stored

Re: [Firebird-net-provider] Entity Framework Stored Procedures

On Tue, Jun 10, 2014 at 2:31 AM, Piers Smith piers.sm...@communicaresystems.com.au wrote: I looked at Function Imports in the model browser. If I Add Function Import there is nothing in the 'Stored Procedure / Function Name' dropdown to select. Is this what you mean? Yep. Looks like your

Re: [Firebird-net-provider] Entity Framework Stored Procedures

: [Firebird-net-provider] Entity Framework Stored Procedures On Tue, Jun 10, 2014 at 2:31 AM, Piers Smith piers.sm...@communicaresystems.com.au wrote: I looked at Function Imports in the model browser. If I Add Function Import there is nothing in the 'Stored Procedure / Function Name' dropdown

Re: [Firebird-net-provider] Entity Framework Stored Procedures

On Tue, Jun 10, 2014 at 9:16 AM, Piers Smith piers.sm...@communicaresystems.com.au wrote: Would you have any idea why edmgen.exe would import a stored procedure okay but not the entity model designer? If you're using same settings, then not. -- Jiri {x2} Cincura http://blog.cincura.net/ |

Re: [Firebird-net-provider] Entity Framework Stored Procedures

Have you created Function Import after updating the model? -- Jiri {x2} Cincura http://blog.cincura.net/ | http://www.ID3renamer.com -- HPCC Systems Open Source Big Data Platform from LexisNexis Risk Solutions Find

Re: [Firebird-net-provider] Entity Framework Stored Procedures

2014 12:37 AM To: For users and developers of the Firebird .NET providers Subject: Re: [Firebird-net-provider] Entity Framework Stored Procedures Have you created Function Import after updating the model? -- Jiri {x2} Cincura http://blog.cincura.net/ | http://www.ID3renamer.com

[Firebird-net-provider] Entity Framework Stored Procedures

Hi, I am having problems importing Firebird stored procedures into the entity framework via the VS model designer (Update Model from Database). The stored procedure is selectable but it does not get generated in the model xml anywhere (i.e. not in ssdl, csdl, msl). There are no errors given.

[Firebird-net-provider] Entity Framework woes (cannot update model from database)

When I try to do Update model from database, I get the following error: An exception of type 'Microsoft.VSDesigner.Data.Local.ConnectionStringConverterServiceException' occurred while attempting to update from the database. The exception message is: ''. I searched this error, and I find a reply

Re: [Firebird-net-provider] Entity Framework woes (cannot update modelfrom database)

@lists.sourceforge.net Sent: Tue, 15 Apr 2014 11:05:06 -0700 Subject: [Firebird-net-provider] Entity Framework woes (cannot update modelfrom database) When I try to do "Update model from database", I get the following error:An exception of type 'Microsoft.VSDesigner.Data.Local.ConnectionStringConverterServic

Re: [Firebird-net-provider] Entity Framework 5, code first: database created, then crash

Am 28.09.2012 15:01, schrieb Jiri Cincura: Use null as initializer. Thank you, that works. But it means that I can neither create nor change my database schema from the application. Only code first with an existing database is possible, right? Not really a problem, but I'd like to know for

Re: [Firebird-net-provider] Entity Framework 5, code first: database created, then crash

You have Migrations turned on, but Migrations are/is not supported (currently).How can I turn off Migrations? I dont want them for the moment. I would have thought using a Database Initializer derived from DropCreateDatabaseIfModelChanges would turn them off, because that seems incompatible with

Re: [Firebird-net-provider] Entity Framework 5, code first: database created, then crash

Use null as initializer. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com -- Got visibility? Most devs has no idea what their production app looks like. Find out how

[Firebird-net-provider] Entity Framework 5, code first: database created, then crash

Hello,Im trying to create a Firebird database in a small test application using Entity Framework 5 with Code First, but it doesnt work.Versions of everything:Windows 7 Home Premium, 64 bitFirebird 2.5.1Firebird net provider 2.7.7 (installed in the GAC, correct entries in machine.config)Visual

Re: [Firebird-net-provider] Entity Framework 5, code first: database created, then crash

You have Migrations turned on, but Migrations are/is not supported (currently). -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com -- Everyone hates slow websites. So do

[Firebird-net-provider] Entity Framework, Get Column Information gives specified type is not supported

Entity Framework in Model Browser -Add Function Import for Stored procedure when clicking Get Column Information I get exception An exception of type System.NotSupportedException occured while attempting to get columns information. The exception message is: The specified type is not supported

Re: [Firebird-net-provider] Entity Framework

On Tue, Oct 4, 2011 at 2:54 PM, Muthu Annamalai pearlamer...@gmail.com wrote: My doubt is the ObjectSet.ToList is the way it is supposed to work ? when we prepare sql statement manually to retrieve records we only write once and not one for each record. Secondly the problem in using the fast

Re: [Firebird-net-provider] Entity Framework

: [Firebird-net-provider] Entity Framework On Tue, Oct 4, 2011 at 2:54 PM, Muthu Annamalai pearlamer...@gmail.com wrote: My doubt is the ObjectSet.ToList is the way it is supposed to work ? when we prepare sql statement manually to retrieve records we only write once and not one for each record

Re: [Firebird-net-provider] Entity Framework

On Tue, Oct 4, 2011 at 5:44 PM, Muthu Annamalai muthuannama...@sbcglobal.net wrote: It seems like the provider is issuing select statement for each record and No it's not. It's doing it in one query. BTW provider isn't issuing any query. It's just sending commands requested by EF: it takes a

Re: [Firebird-net-provider] Entity Framework

-provider] Entity Framework On Tue, Oct 4, 2011 at 5:44 PM, Muthu Annamalai muthuannama...@sbcglobal.net wrote: It seems like the provider is issuing select statement for each record and No it's not. It's doing it in one query. BTW provider isn't issuing any query. It's just sending commands

[Firebird-net-provider] Entity Framework

I am using VS 2010, EF 4.0 with Firebird Dot Net Provider 2.6.5.0 When I use ObjectSet.ToList, the provider creates an select statement for each and every record in the list and it takes forever to load an list of 1 records. But instead if I use like From item in Objectset select

Re: [Firebird-net-provider] Entity Framework Default Value

On Mon, Jan 24, 2011 at 20:13, Muthu Annamalai muthuannama...@sbcglobal.net wrote: In VS 2010 I started using EF4 with firebird 2.5.0 and fb provider 2.6.0.0. AutoIncrement, Bool everything is working out well. Is there a way we can get the default value from database as well. I really

[Firebird-net-provider] Entity Framework Default Value

In VS 2010 I started using EF4 with firebird 2.5.0 and fb provider 2.6.0.0. AutoIncrement, Bool everything is working out well. Is there a way we can get the default value from database as well. I really appreciate your time and effort for providing an efficient provider. Thanks! Muthu Annamalai

Re: [Firebird-net-provider] Entity Framework autoincrement problem

, December 30, 2010 5:24 AM To: firebird-net-provider@lists.sourceforge.net Subject: Re: [Firebird-net-provider] Entity Framework autoincrement problem It seems that the firebird server performs insert into students(id, firstname) values(0, 'asdf') instead of insert into students(firstname

Re: [Firebird-net-provider] Entity Framework autoincrement problem

Yes I can do that thing but I want to return a currently generated id in order to use it in my entity class, and it is still 0. I mean the schema insert - select seems not working in my code using firebird database. In case with mssql it returns the proper value, so maybe I have to do something

Re: [Firebird-net-provider] Entity Framework autoincrement problem

On Thu, Dec 30, 2010 at 07:45, Stan sphinx...@yahoo.com wrote: And the trigger fires in case with an sql query, but doesn't using Entity Framework in Visual Studio. Maybe I have to make this autoincrement implementation in some different way? Does that sql code look ok? Did you marked the

Re: [Firebird-net-provider] Entity Framework autoincrement problem

I read that article before but the thing that the property Identity is disappering makes me think that I have another problem (I didn't have it disappeared). Now I noticed that the comment in the column on the database side causes the StoreGeneratedPattern property in the SSDL content section of

[Firebird-net-provider] Entity Framework autoincrement problem

Hi, I have a problem with Identity store generation pattern. It seems doesn't work or maybe I'm doing something wrong. I've made the table students and the fields id and name as the key field as well as the generator. The simple insert sql statement - insert into students(name)

Re: [Firebird-net-provider] Entity Framework autoincrement problem

On Wed, Dec 29, 2010 at 13:59, Stan sphinx...@yahoo.com wrote: After context.SaveChanges() has performed I'm getting the id = 0 in my database table and the generator doesn't change its value. The second call raise an exception, because I'm trying to insert id as 0 and it is already stored in

Re: [Firebird-net-provider] Entity Framework autoincrement problem

That's what I have in the database: CREATE GENERATOR GEN_STUDENTS_ID; CREATE TABLE STUDENTS ( ID INTEGER NOT NULL, FIRSTNAME VARCHAR(50) ); ALTER TABLE STUDENTS ADD CONSTRAINT PK_STUDENTS PRIMARY KEY (ID); CREATE TRIGGER STUDENTS_BI FOR STUDENTS ACTIVE BEFORE INSERT POSITION

Re: [Firebird-net-provider] Entity Framework autoincrement problem

It seems that the firebird server performs insert into students(id, firstname) values(0, 'asdf') instead of insert into students(firstname) values('asdf') select id ... -- View this message in context:

Re: [Firebird-net-provider] Entity framework problems

Thanks! It would be good if a note on the firebirdsql website would state that, perhaps where the net provider can be downloaded. Best regards, Bengt Am 04.12.2010 14:11, schrieb Jiri Cincura: http://j.mp/etvhlo --

Re: [Firebird-net-provider] Entity framework problems

http://j.mp/etvhlo -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com -- What happens now with your Lotus Notes apps - do you make another costly upgrade, or settle for

[Firebird-net-provider] Entity framework problems

I am able to connect the new 2.6.0 Net provider to my db and I can see all the tables in vs2010 explorer. Now I try to create an entity framework model from the db. Well, a model is generated, but all fields are marked as being part of the primary key, which they are not. Also, all the foreign

[Firebird-net-provider] Entity Framework and Linq

Hi, I just encountered the same issues reported in Vol 48, Issue #5 Topic #5 and (48,6,2) using VS2010, DDEX provider 2.0.5, Entity Framework 4 with Firebird 2.5.2. I re-generated the emdx file, checked the csdl secttion and have encountered the exact same error using Linqpad to test. I'm not

Re: [Firebird-net-provider] Entity Framework 4.0 delete statements

How is the cascading set? -- Jiri {x2} Cincura (CTO x2develop.com) http://blog.cincura.net/ | http://www.ID3renamer.com -- Download Intel#174; Parallel Studio Eval Try the new software tools for yourself. Speed

[Firebird-net-provider] Entity Framework 4.0 delete statements

Hi Jiri I have a question for you. It looks like the generation of the delete statement has changed inside ef4.0. (I'm not sure if it has changed, but I'm sure it is not the behavior i'm expecting) When one is deleting a record with foreign navigation properties, it includes these

[Firebird-net-provider] Entity Framework Foreign Key Relation

I have the following installed VS 2010 Dot Net Framework 4.0 Firebird 2.5.0 Dot Net Provider 2.5.1 I have following issues, I have a Customer Table which has foreign key relationship with Person and Address Table. I create PK values for these tables using triggers. When I insert a

[Firebird-net-provider] Entity Framework Foreign Key Relation

I have the following installed VS 2010 Dot Net Framework 4.0 Firebird 2.5.0 Dot Net Provider 2.5.1 I have following issues, I have a Customer Table which has foreign key relationship with Person and Address Table. I create PK values for these tables using triggers. When I insert a

Re: [Firebird-net-provider] Entity Framework Foreign Key Relation

On Wed, Jan 20, 2010 at 18:51, Muthu Annamalai pearlamer...@hotmail.com wrote: How would you avoid zero value for all PK’s. Didn't you just said that you're generating PKs with trigger? If so, the trigger should populate the proper value. -- Jiri {x2} Cincura (CTO x2develop.com)

Re: [Firebird-net-provider] Entity Framework Foreign Key Relation

On Wed, Jan 20, 2010 at 18:51, Muthu Annamalai pearlamer...@hotmail.com wrote: a record in customer table using Entity Framework all the PK’s were inserted as 0. I searched online and changed all the PK’s as Identity column, still no luck. See the sample row. Reading this looks like you're

Re: [Firebird-net-provider] Entity Framework Foreign Key Relation

and developers of the Firebird .NET providers Subject: Re: [Firebird-net-provider] Entity Framework Foreign Key Relation On Wed, Jan 20, 2010 at 18:51, Muthu Annamalai pearlamer...@hotmail.com wrote: How would you avoid zero value for all PK's. Didn't you just said that you're generating PKs

Re: [Firebird-net-provider] Entity Framework Foreign Key Relation

At 10:48 AM 21/01/2010, you wrote: Yes. The trigger will make the insert value, only if the PK value is null. But from entity framework, all my PK's are integer and sending zero value to database. If you want your trigger to work, don't include the PK in the INSERT statement! Helen

Re: [Firebird-net-provider] Entity Framework Foreign Key Relation

context.SaveChanges. -Original Message- From: Jiri Cincura [mailto:disk...@cincura.net] Sent: Wednesday, January 20, 2010 5:09 PM To: For customers and developers of the Firebird .NET providers Subject: Re: [Firebird-net-provider] Entity Framework Foreign Key Relation On Wed, Jan 20

Re: [Firebird-net-provider] Entity Framework Foreign Key Relation

: Wednesday, January 20, 2010 6:08 PM To: For users and developers of the Firebird .NET providers Subject: Re: [Firebird-net-provider] Entity Framework Foreign Key Relation At 10:48 AM 21/01/2010, you wrote: Yes. The trigger will make the insert value, only if the PK value is null. But from entity

Re: [Firebird-net-provider] Entity Framework, Firebird and Guid

Put it as FR into tracker. -- Jiri {x2} Cincura (CTO x2develop.com) http://blog.cincura.net/ | http://www.ID3renamer.com -- ___ Firebird-net-provider mailing list

Re: [Firebird-net-provider] Entity Framework, Firebird and Guid

Firebird doesn't have direct support for guids. Not native in Firebird but maybe with your Provider. By using smallint_bool in the ssdl i can use boolean in entities which isn't supported too. When i follow your advise from here

[Firebird-net-provider] Entity Framework, Firebird and Guid

Hello, when i create a SQL-Server database with an uniqueidentifier typed field as primary key the entity wizard creates an entity with a System.Guid typed field. Is something like that possible with FirebirdSQL? It would be really usefull if i can have System.Guid as a field in an entity.

Re: [Firebird-net-provider] Entity Framework, Firebird and Guid

Firebird doesn't have direct support for guids. -- Jiri {x2} Cincura (CTO x2develop.com) http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com -- Crystal Reports - New Free Runtime and 30 Day Trial Check out the new

Re: [Firebird-net-provider] Entity Framework, Firebird and Guid

Firebird doesn't have direct support for guids. Not native in Firebird but maybe with your Provider. By using smallint_bool in the ssdl i can use boolean in entities which isn't supported too. When i follow your advise from here