Release of ADO.NET provider for OLE DB engines!

Hello everyone!

We are pleased to announce the release of our “LCPI ADO.NET provider for OLE DB” which allows to create a professional solutions for Firebird!

Our .NET provider doesn’t force you to use ADO.NET as the exclusive access technology in application. You can use ADODB and work with OLEDB provider directly. Simultaneously!

You can use any .NET programming language and any programming language that supports COM or ActiveX. All at once!

And, of course, you can be sure in quality of this ADO.NET provider. We used TDD from beginning to end of development cycle.

Read the full text of press release here – http://www.ibprovider.com/eng/news/n_150408_adonet_provider_release.html

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...

Windows Azure Web Sites and Firebird

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.

1 Star2 Stars3 Stars4 Stars5 Stars (4 votes, average: 4.25 out of 5)
Loading...

Custom conventions in Entity Framework 6 helping Firebird – part 2

Few days ago I wrote a post “Custom conventions in Entity Framework 6 helping Firebird“.Arthur Vickers from Entity Framework team had a good question whether it works also for columns and tables that are generated by Entity Framework (like join tables for M:N, FK columns (if not in model), etc.). And it actually does not. :) For this you have to dig a little bit deeper and use model-based convention.

1 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 5.00 out of 5)
Loading...

SplendidCRM on FirebirdSQL demo page and Database structure

SplendidCRM (version C# of SugarCRM) is ported from MSSQL over to
FirebirdSQL 2.5.2

It is in a “testable” debug version on this url http://zeos.tetrasys.eu

username : user
password : user

This changes from the usual will/will 🙂

It is the “community” version and I would like to have your feedback on their added value in a CRM, before carrying over the enterprise modules.

Two precision/information points:
1) One is on a small DSL in Finland, so your GSM has more disponibility and bandwidth
2) the data structure is available for viewing here http://blog.tetrasys.eu/zeos-firebirdsql-structure.aspx

Your comments are welcome 🙂

http://www.linkedin.com/groups/SplendidCRM-on-FirebirdSQL-2078215.S.212283698

I will add one more comment from the Firebird porter :

Thanks to Firebird, the memory and processing space has been reduced with two thirds when migrated from MSSQL to FirebirdSQL.
Why don’t everybody switch over to Firebird? 🙂

 

1 Star2 Stars3 Stars4 Stars5 Stars (2 votes, average: 5.00 out of 5)
Loading...

Dozens of new options for Firebird and .NET Framework

Hey!

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

IBProvider Team

Firebird driver

1 Star2 Stars3 Stars4 Stars5 Stars (4 votes, average: 3.00 out of 5)
Loading...

Disabling database triggers in FirebirdClient (.Net)

Via Jiří {x2} Činčura blog:

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.

1 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 5.00 out of 5)
Loading...
1 2 3 5