Firebird ADO.NET Data Provider 2.5.0 Beta 1 for .NET 3.5/2.0 [with Entity Framework support]

I’m pleased to announce 2.5.0 Beta 1 for .NET 3.5/2.0 [with Entity
Framework support] version. It contains several bugfixes as well as
brand new Entity Framework support (still beta!). Looking forward to
your feedback.

Binary as well as sources can be downloaded from
http://www.firebirdsql.org/index.php?op=files&id=netprovider.

  • Twitter
  • Facebook
  • Share/Bookmark
This entry was posted in .* and tagged , , , , , , , . Bookmark the permalink.

30 Responses to Firebird ADO.NET Data Provider 2.5.0 Beta 1 for .NET 3.5/2.0 [with Entity Framework support]

  1. Ali Erdogan says:

    I use this provider. Thank you.The worst problem is we cannot see the error message returning from a query. We always get “Exception of type ‘FirebirdSql.Data.Common.IscException’ was thrown.” message if something is wrong. If this is a select query it is easy to try in other place but when it is update or insert query it is very very difficult to debug it. There is not an English version of your blog.

  2. cincura.net says:

    You can check InnerException.

  3. Ali Erdogan says:

    The other problem is if we try to insert or update something and if some parameters are empty in sqldatasource it gets feil. If we set parameters ConvertEmptyStringToNull=”false” then it cleans existing data on the field.

  4. cincura.net says:

    SqlDataSource isn’t working with EF (EDM).

  5. re:re: Firebird ADO.NET Data Provider 2.5.0 Beta 1 for .NET 3.5/2.0 [with Entity Framework support] says:

    How will i use inner exception?

  6. I’m pleased to announce that a beta of the Firebird ADO.NET provider with Entity Framework support is

  7. Cezary says:

    Hello, I’m trying to use the new ADO.NET provider with the Entity Framework EDMX Designer. When I create a model from the FB database using the wizard, I get all the tables with entity key property set on all of their columns. Also, there are no relationships generated. Is this a normal behavior or am I doing something wrong?Regards,Ceary

  8. Cezary says:

    Hi Jiří, Thanks for the quick response. I have actually read that post. I tried different versions of the embedded FB to work with the EDMX designer. That is: 2.0.5.13206, 2.1.1.17910, 2.1.2.18116, 2.5.0.20343. So far, no success. Do you maybe know when that ridicolous bug is going to be scheduled for a fix? Or maybe you could point me to the working version of the FB.Regards,Cezary

  9. cincura.net says:

    It’s fixed in post-2.5 Alpha 1. At least your 2.5.0.20343 should work, because I’m using little bit previous version.

  10. Cezary says:

    Hi Jiří, I’m afraid you’re wrong. I’ve double tested the database created under FB 2.5.0.20343. It doesn’t work with the EDMX designer. The wizard produces the ouput I’ve described previously: no relationships generated, all data columns are set as entity keys.The FirebirdClient is set to use the 2.5.0.20343 driver.The EdmGen prints some warnings and errors:warning 6035: The relationship ‘*********’ has columns that are not part of the key of the table on the primary side of the relationship which is not supported, the relationship was excluded.error 0075: Key Part: ‘***********’ fortype ********** is not valid. All parts of the key must be non nullable.Any bit of hope for fixing things up?Regards,Cezary

  11. cincura.net says:

    I’ve checked now the 2.5.0.21381 FB snapshot build and it’s working fine as well as my previous.

  12. Cezary says:

    Finally. I can confirm: it works for me with and only with the FB version 2.5.0.22512.Thanks, Jiří.

  13. Fred Morrison says:

    FYI: The download link at the top of this article generates a Page Load error when I click on it using FireFox 3.0.6 browser.

  14. Fred Morrison says:

    FYI (part 2): the download link at the top of this article does not work in Opera, Safari or IE 7 either.

  15. Padcom says:

    Guys, please provide an example usage of EdmGen2 with the Firebird provider. Every time I’m trying it out (and it’s been a few times already) I’ve ended up abandoning it because of the same error:Unhandled Exception: System.ArgumentException: The specified store provider ‘FirebirdSql.Data.FirebirdClient’ cannot be found in the configuratin or it’s not valid. —> System.ArgumentException: Unable to find the requested .Net Framework Data Provider. It may not be installed.Either your installer is not doing the installation right or I’m missing something else. Please advice.Best regards,Padcom

  16. cincura.net says:

    There’s nothing special on EdmGen2, if you have working EdmGen, it simply works.Anyway, did you put FirebirdClient into GAC and register in machine.config?

  17. Pingback: ADO.NET team blog

  18. Pingback: ADO.NET Entity Framework Provider for Firebird RTM Now Available | Coded Style

  19. Pingback: ADO.NET Entity Framework Provider for Firebird RTM Now Available | Coded Style

  20. Pingback: ADO.NET Entity Framework Provider for Firebird RTM Now Available | ASP NET Hosting

  21. Pingback: ADO.NET Entity Framework Provider for Firebird RTM Now Available | Microsoft Share Point

  22. Pingback: ADO.NET Entity Framework Provider for Firebird RTM Now Available | ASP.NET MVC

  23. Rowland Shaw says:

    I’ve installed the MSI, but I don’t have the option to use the provider in the wizard (I’m using VS 2008) – I also don’t see the provider in the “Add References” dialog. Are there manual steps that need to be done to use this?

  24. cincura.net says:

    You have to install DDEX. The Add References dialog is reading the files from path defined in registry, independently from installation of some tools.

  25. Rowland Shaw says:

    How do I install DDEX? There’s no option for it in the MSI, or is it a separate download?

  26. Rowland Shaw says:

    Found DDEX (was expecting it to be part of the MSI, but apparently not)…Although I can now connect to it, I still get:—————————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 ErrorSQL error code = -104Token unknown – line 6, column 8SELECT’.The inner exception caught was of type ‘FirebirdSql.Data.Common.IscException’, with this error message: ‘Exception of type ‘FirebirdSql.Data.Common.IscException’ was thrown.’.’.—————————OK —————————

  27. cincura.net says:

    You’re probably running some 1.5 server or similar outdated version.

  28. Rowland Shaw says:

    How would I be able to tell, given it’s a database in a third party application? Even if this were the cause, I’d expect it to handle the issue a bit more gracefully…

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>