Showing posts with label Firebird. Show all posts
Showing posts with label Firebird. Show all posts

Sunday, January 15, 2012

Embedding a Firebird database in your .Net Project

Nazmi Altun's Blog - Using Embedded Firebird Database In .Net Projects

"...

This post will show an example of using an embedded firebird database in .NET/C# projects.

What is FireBird?

From its official web-site( http://www.firebirdsql.org) , Firebird is a powerful, open-source relational database system, with high performance and extensive support for powerful SQL features with close adherence to the SQL standards. Whether you're developing a small program or a large enterprise information system, Firebird is the database for you. Take a look at the Case Studies to get an impression of other people using Firebird.

So, firebird is a database system that has stored procedure and trigger functionality. It also be used as server database or embedded database. This post will be about using embedded Firebird database in your .NET application.

Creating Database Tables

Since this is just a sample that show basic things , we will create a small student-classroom system. Each class has students and user will add students under each class.

...

Application

In this sample , we create a Windows Forms applications. Since , .NET doesn’t have Firebird data provider , we need to download it from Firebirds web-site. Here’s link

http://www.firebirdsql.org/en/net-provider/

After we download it, we add FirebirdSql.Data.FirebirdClient .dll as reference in our project. For embedded usage of firebird database we also need to download some dll files and add our project.

...

Firebird Data Access Application Block

For simplifying and optimizing , database access codes we use Data Access Application Block.

Data Access Application Block for FireBird can be downloaded from here http://www.codeproject.com/KB/cs/FireBirdSqlHelper.aspx

...

image..."

It's been a few years since I've blogged about Firebird and this post looks like a good one too break that silence...

 

Related Past Post XRef:
Firebird ADO.NET Provider (with source) for Entity Framework Beta Released
Enterprise Library Data Provider for Firebird
DotNetFirebird - Using Firebird SQL in .NET
MS SQL Server to FireBird migration

Tuesday, January 13, 2009

Firebird ADO.NET Provider (with source) for Entity Framework Beta Released

ADO.NET team blog - Beta of Firebird ADO.NET Provider with Entity Framework Support Available

“I'm pleased to announce that a beta of the Firebird ADO.NET provider with Entity Framework support is now available.  Congratulations to Jiří Činčura and to everyone else who has worked on this project so far!

For more information, please see Jiří's blog post here or access the download page for the provider here.

…” [Post leached level: 99%]

Jiří {x2} Činčura - 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.” [Post leached in full]

Firebird - Firebird .Net Providers Downloads

image

It’s been a few years since I’ve posted about Firebird, so after seeing this I felt it was time…

 

Related Past Post XRef:
Enterprise Library Data Provider for Firebird
DotNetFirebird - Using Firebird SQL in .NET
MS SQL Server to FireBird migration

Tuesday, June 19, 2007

MyGeneration is now OSS (BSD Licensed and Available on SourceForge)

SourceForgeMyGeneration Code Generator

"MyGeneration is an extremely flexible template based code generator written in Microsoft.NET. MyGeneration is great at generating code for ORM architectures. The meta-data from your database is made available to the templates through the MyMeta API."

MyGeneration - Code Generation, O/R Mapping, and Architectures

"...

  • MyGeneration's dOOdads Architecture Included for Both C# and VB.NET (Quickstart
  • Supported Architectures - dOOdadsEntitySpacesEasyObjects.NET/EntLibGentle.NETOpf3NHibernateMicrosoft's DAAB,  DotNetNukeiBatis
  • Support for Twelve Different Database Systems. 
    Microsoft SQLOracleIBM DB2,   PostgreSQLMicrosoft AccessFireBirdInterbaseVistaDBSQLiteMySQL, Advantage and Pervasive
  • Template Based Code Generator Supporting Four Template Languages - JScript, VBScript, C# and VB.NET
  • Ability to Create Your Own Embedded User Interface in your Templates
  • Online Template Library for Publishing and Downloading Templates
  • ..."

    Interesting... I dig code generation as I'm a pretty lazy guy and hate writing cookie-cutter code. Heck I'll write SQL statements to generate my VB.Net code if I have too (which I have ;)

    I'll have to find some time to check this out...

    (via DotNetKicks - MyGeneration Goes Open Source on SourceForge.net

    Monday, April 11, 2005

    Enterprise Library Data Provider for Firebird



    "Enterprise Library for Firebird
    Enterprise Library data provider for the Firebird database. Distributed under the terms of the LGPL license.
    -----------------
    Releases
    April 5th 2005, version 0.7.0: download"


    When I start playing with Firebird I'll want to check this out...

    Also it shows how cool MS's Enterprise Library is and how it can be extended to other databases...

    (via DotNetFirebird - Enterprise Library Data Access Application Block for Firebird)

    Friday, February 04, 2005

    MS SQL Server to FireBird migration

    The Code Project - MS SQL Server to FireBird migration. That's a Pain! - C# Database

    "Recently I read article Embedded Firebird at Code Project and decided to try FireBird. I like the idea of embedded database. FireBird allows .Net developer to put a dll into bin directory, create database file and use usual database access. It sounds very attractive and simple. In theory. So I decided to migrate from SQL Server to FireBird.

    ..."


    This article covers some lessons learned when migrating an app (and experience) from MS SQL to Firebird.

    Through I don't necessarily agree with conclusion of the article's author (i.e. um.. of course it's not plug and play... it's a totally different DB engine. Of course there will be things you are not used to, that work different, etc...) it still contains some good info...

    If I play with FireBird like I talked about here, then this info might come in handy.

    Friday, January 21, 2005

    DotNetFirebird - Using Firebird SQL in .NET

    DotNetFirebird - Using Firebird SQL in .NET

    Dan at dotnetfirebird.org just emailed me, pointing me to DotNetFirebird: Using Firebird SQL in .NET, http://www.dotnetfirebird.org

    As quoted from the DotNetFirebird home page,
    "Firebird SQL is a powerful open source database that can be easily used in .NET. I believe it has a big potential (it is full-featured, requires zero administration, can be embedded, etc.). However this potential has not been fully discovered by .NET developers who rely on Microsoft SQL Server heavily."

    Firebird has been getting some airplay recently. And with the "dude, check out this site..." [paraphrased] email from Dan, well it's time I took a closer look.

    For those of you who have a life (err, I mean... um... yeah :), Firebird is based on/derived from/a child of/etc Borland's Interbase (who I believe purchased it from someone else, bla bla bla). I'm not going to do a long history of Firebird/Interbase, but it does have a long "under the radar" history. For example, I briefly played with Interbase when it was bundled with Delphi (v1 or 2 I think... i.e. about a million tech years ago).

    It "really" doesn't compare to Access (apples and oranges). It does compare, and compare well to MSDE. Where it has a good head start. SQL Express is closer to Firebird in the embedded space, but we have a while to wait for that... And of course Firebird is not only free but also open source.

    Another thing I find really interesting is the work on integrating/linking/using Firebird and DotLucene. You know I've been jones'ing to play with DotLucene/OpenLucene (here and here.

    On http://www.dotnetfirebird.org/ you'll find a ADO.NET provider for Firebird, links to download Firebird, code snips, and generally a bunch of information on using Firebird and .Net together.


    Thanks for the cool tip Dan.

    Thursday, August 19, 2004

    Freeware Suggestions under Windows (OSNews)

    Freeware Suggestions under Windows

    Nice two page article on freeware apps for Windows. Grouped by category (Audio, Video, Browser, Productivity, etc) there's also a little blurb on each app.

    Mostly names you probably already know (firebird, MyIE, OpenOffice,etc), still nice to have them in one article.

    (via theofficeweblog)