Jiří Činčura wrote about his experience with Firebird Embedded and Azure Websites

To sum up. Firebird Embedded works well in Windows Azure Websites. If you need fully featured SQL database for zero extra-money with option to go hassle-free to full server if the need comes, it’s a way to go.

If you have ever worked with Firebird or Interbase using the standard .NET provider for OLE DB (System.Data.OleDb), you will have likely encountered issues like this:

The necessity to add ALL parameters manually.

Even though the OLE DB provider supports parameter generation for commands, the .NET provider doesn’t use it, so you as the programmer must do that work on your own.

The lack of support for named parameters. Although they actually exist, using them in reality requires a whole set of complex manipulations (the steps needed to add a parameter to a collection, etc.).

The impossibility of using multiple DataReader objects at the same time (Multiple Active Result Sets).

No execution of SQL scripts which contain several SQL expressions per command. This list of difficulties a .NET developer has to deal with is far from complete. Now it’s all different in a fundamentally new .NET Data Provider for OLE DB

Database triggers are a nice new feature added to Firebird in version 2.1. And as you can do a lot of stuff with them, sometimes you also might wanna to connect without firing these, especially if you made a mistake there and it’s forcibly closing your connection. To disable these, standard Firebird utilities have a new switches. But it boils down to the API itself, nothing magical.

And if it’s in API, it could be FirebirdClient, right? In last few days among working on other bugs and my daily responsibilities I had a time to dig into this. And now also from .NET world we can use this feature.

Recently viewed a great presentation by of Steve Sanderson (blog.stevensanderson.com) on using SPA with MVC4. I tired with FB 2.5 and it works great. I’ve written my first blog This shows how to change the default behavior from Code First to Database First with these new technologies. I just wanted to contribute the list.
Thanks,