6
Jan
Tags: .NET, Databases in general, Entity Framework, Firebird, LINQ, OData/Data Services (Astoria), Visual Studio, Windows | 30 Comments »
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.
There's 30 Comments So Far
January 9th, 2009 at 18:30
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.
January 9th, 2009 at 19:04
You can check InnerException.
January 9th, 2009 at 19:09
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.
January 9th, 2009 at 19:20
SqlDataSource isn’t working with EF (EDM).
January 9th, 2009 at 19:46
How will i use inner exception?
January 9th, 2009 at 22:35
RTFM http://msdn.microsoft.com/en-us/library/system.exception.innerexception.aspx
January 13th, 2009 at 02:16
I’m pleased to announce that a beta of the Firebird ADO.NET provider with Entity Framework support is
January 26th, 2009 at 03:49
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
January 26th, 2009 at 09:15
Check http://blog.cincura.net/id/228440/ .
January 26th, 2009 at 22:37
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
January 26th, 2009 at 22:41
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.
January 28th, 2009 at 00:43
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
January 28th, 2009 at 09:12
I’ve checked now the 2.5.0.21381 FB snapshot build and it’s working fine as well as my previous.
January 30th, 2009 at 02:09
Finally. I can confirm: it works for me with and only with the FB version 2.5.0.22512.Thanks, Jiří.
March 1st, 2009 at 15:53
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.
March 1st, 2009 at 15:56
FYI (part 2): the download link at the top of this article does not work in Opera, Safari or IE 7 either.
April 16th, 2009 at 23:21
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
April 16th, 2009 at 23:27
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?
June 8th, 2009 at 12:23
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?
June 8th, 2009 at 12:31
You have to install DDEX. The Add References dialog is reading the files from path defined in registry, independently from installation of some tools.
June 8th, 2009 at 12:47
How do I install DDEX? There’s no option for it in the MSI, or is it a separate download?
June 8th, 2009 at 14:44
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 —————————
June 8th, 2009 at 15:06
You’re probably running some 1.5 server or similar outdated version.
June 8th, 2009 at 19:36
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…
Who Linked To This Post?
Share your thoughts, leave a comment!