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.
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.
You can check InnerException.
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.
SqlDataSource isn’t working with EF (EDM).
How will i use inner exception?
RTFM http://msdn.microsoft.com/en-us/library/system.exception.innerexception.aspx
I’m pleased to announce that a beta of the Firebird ADO.NET provider with Entity Framework support is
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
Check http://blog.cincura.net/id/228440/ .
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
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.
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
I’ve checked now the 2.5.0.21381 FB snapshot build and it’s working fine as well as my previous.
Finally. I can confirm: it works for me with and only with the FB version 2.5.0.22512.Thanks, Jiří.
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.
FYI (part 2): the download link at the top of this article does not work in Opera, Safari or IE 7 either.
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
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?
Pingback: ADO.NET team blog
Pingback: ADO.NET Entity Framework Provider for Firebird RTM Now Available | Coded Style
Pingback: ADO.NET Entity Framework Provider for Firebird RTM Now Available | Coded Style
Pingback: ADO.NET Entity Framework Provider for Firebird RTM Now Available | ASP NET Hosting
Pingback: ADO.NET Entity Framework Provider for Firebird RTM Now Available | Microsoft Share Point
Pingback: ADO.NET Entity Framework Provider for Firebird RTM Now Available | ASP.NET MVC
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?
You have to install DDEX. The Add References dialog is reading the files from path defined in registry, independently from installation of some tools.
How do I install DDEX? There’s no option for it in the MSI, or is it a separate download?
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 —————————
You’re probably running some 1.5 server or similar outdated version.
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…