[Gabriel56]

We are using Firebird database and I would like to query it with LINQPad. Is it possible? There is an ADO.NET Driver, but how can use it in "new connection"? I've tried to write my own Data Context Driver, but I don't see where I can connect to the database. Until now I've used components such as FbConnection (with connection string), FbDataAdapter, FbCommand and so on. I have no experiences with Entity Framework.

Regards, Gabriel

[JoeAlbahari]

Hi Gabriel

The simple answer is no: it takes more then FbConnection, FbCommand, etc. You need code that takes a LINQ query and transforms it into SQL that's valid for Firebird.

If you really want to query Firebird in LINQ (and don't mind investing some time into writing a driver), the simplest option right now is to write a driver for Matt Warren's IQueryable toolkit. Once you've got this working, you can write a LINQPad plug-in (I can help you with that).

The other option is to wait for someone else to do it, although it take a while (or forever) given that Firebird isn't terribly popular.

Regards
Joe

[Gabriel56]

Hi Joe,

I've found LINQ provider for Firebird: it's name is DbLinq. I'll try to use it for Linqpad.

Regards, Gabriel

[JoeAlbahari]

Great. Let me know how you get along.

Joe

[Gabriel56]

Great. Let me know how you get along.

Joe

I've tried to modify some functions in AstoriaDynamicDriver, but it'all so new for me... I really don't see how to use DbLinq.Firebird with all it's classes and methods. Where can I connect to Database?

Regards, Gabriel

[Gabriel56]

I've started with IQToolkit. Until now I modified SqlClient to run with Firebird (without testing - some functions are certainly not available there) and now trying to modify AstoriaDynamicDriver to use IQToolkit.

Regards, Gabriel

[JoeAlbahari]

If you can write a driver for Matt Warren's IQueryable toolkit and sent it to me, I'll add it to LINQPad's IQ driver. This will save you the work of writing a LINQPad driver for IQ.

Cheers
Joe

P.S. You might also like to sent it to Matt Warren so he can add it to his project.

This post has been edited by JoeAlbahari: 20 January 2010 - 05:54 AM

[Gabriel56]

I've (almost) written a driver - 200 of 221 tests are passed. There are some functions which are not available in Firebird (ROW_NUMBER, SELECT without FROM). Some test could also run, but the .NET driver returns "invalid data type". After replacing parameters with string values the query is passing the test. Maybe someone here or at codeplex knows the answer.

Regards, Gabriel

[samuelasava]

Gabriel56


I haven't used it, but Kellerman Software has a LINQ provider for Firebird
https://www.kellerma...cess-layer.aspx