13
Jul
Tags: , , , | 8 Comments »

Another progress on Entity Framework provider for Firebird

Today, after some days/weeks, I finally created some noticable (= not only internals) progress with Entity Framework provider for Firebird.

Now, the provider is able to use, map, call, … stored procedures (and functions [very experimental]). You can select stored procedures from database, map these to some operations in EF, create “function imports” etc. You can see this working on picture:

I have not tested all available options of calling etc. SPs, so feel free to report any problems with it. Current version can be downloaded from netprovider.cincura.net (aka weekly builds).

Also take into account, that current latest stable (old ones too) version of FB has left outer join bug, so all columns in table are marked as primary key(s) (and so must be not null). I’m wondering how this (from my POV) really serious bug can go thru QA tests?!

Known Issue: When you select “Update Model from Database” in Visual Studio you get error. I’m now working on it.
Anyway for testing, I recommend you to use EdmGen (or EdmGen2), it’s faster and more controlled. :)

There's 8 Comments So Far

  • Cesar De la Rosa
    May 29th, 2009 at 13:34

    Is the problem of all columns marked as primary key fixed? If so, is there any update available to solve the problem?Thanks in advance.

  • cincura.net
    May 29th, 2009 at 13:42

    Yes, in Firebird 2.5 Beta 1. Check comments on http://blog.cincura.net/id/230290/ .

  • Cesar De la Rosa
    June 2nd, 2009 at 09:57

    Hi května.I’m using Firebird 2.5 alpha release and the Firebird Client 2.5 and I’m still having the same problem (all columns marked as primary key). I don’t know how to solve it.

  • cincura.net
    June 2nd, 2009 at 13:09

    You have to use Beta 1. It’s one comment above yours.

  • Cesar De la Rosa
    June 2nd, 2009 at 17:06

    Thanks jirka. I finally solved it :)

  • Cesar De la Rosa
    June 4th, 2009 at 17:51

    Hi again JirkaI’ve been working with Firebird and the Entity Framework and everything seems to be working well except for the autoincrement fields. Whenever I try to add a new record to a table its autoincrement field doesn’t increment.Do you have any clue of how to solve this?

  • cincura.net
    June 8th, 2009 at 10:12

    There’s no autoincrement field in Firebird. We have more poweful concept of generators/sequences.

Who Linked To This Post?

  1. Firebird News » Progress on the Entity Framework Provider for Firebird

Share your thoughts, leave a comment!