Over a million developers have joined DZone.
{{announcement.body}}
{{announcement.title}}

Embedding a Firebird database in your .Net Project

DZone's Guide to

Embedding a Firebird database in your .Net Project

· Database Zone ·
Free Resource

Compliant Database DevOps and the role of DevSecOps DevOps is becoming the new normal in application development, and DevSecOps is now entering the picture. By balancing the desire to release code faster with the need for the same code to be secure, it addresses increasing demands for data privacy. But what about the database? How can databases be included in both DevOps and DevSecOps? What additional measures should be considered to achieve truly compliant database DevOps? This whitepaper provides a valuable insight. Get the whitepaper

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...

Compliant Database DevOps and the role of DevSecOps DevOps is becoming the new normal in application development, and DevSecOps is now entering the picture. By balancing the desire to release code faster with the need for the same code to be secure, it addresses increasing demands for data privacy. But what about the database? How can databases be included in both DevOps and DevSecOps? What additional measures should be considered to achieve truly compliant database DevOps? This whitepaper provides a valuable insight. Get the whitepaper

Topics:

Published at DZone with permission of

Opinions expressed by DZone contributors are their own.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}