Click here to Skip to main content
Click here to Skip to main content
Go to top

FireBird SqlHelper - A Data Access Application Block for FireBird

, 17 Jan 2007
Rate this:
Please Sign up or sign in to vote.
FireBird.SqlHelper is a C# porting of Microsoft Data Access Application Block V2. Just like the Microsoft Data Access Application Block V2, FireBird.SqlHelper encapsulates performance and resource management best practices and can easily be used as a building block in your own .NET FireBird applicat
Sample Image - FireBirdSqlHelper.jpg

Introduction

FireBird.SqlHelper is a C# porting of Microsoft Data Access Application Block V2. Just like the Microsoft Data Access Application Block V2, FireBird.SqlHelper encapsulates performance and resource management best practices and can easily be used as a building block in your own .NET FireBird application. If you use it, you will reduce the amount of custom code you need to create, test and maintain.

Features

A pre-written data access library is always handy. Basically FireBird SqlHelper has similar features as MSDAB. Following are the important features: The FireBird SqlHelper Data Access Application Block for .NET consists of a single .NET-based assembly, which contains all of the functionality necessary to perform the most common data access tasks against a FireBird database. Specifically, the Data Access Application Block helps you:

  • Call stored procedures or SQL text commands
  • Specify parameter details
  • Return SqlDataReader, DataSet objects, or single values
  • Use strongly typed table and field names
  • Support parameter caching, where required
  • Allow additional tables to be added by passing in pre-existing datasets
  • Update a dataset with user-specified update commands
  • Create SqlCommand objects
  • Allow strongly typed data rows to be passed in place of parameters

Using the Code

Compile FireBird.SqlHelper project and add the reference of FireBird.SqlHelper.dll in your application. Following are the important methods that you could use:

  • ExecuteNonQuery - Executes a command that does not return rows
  • ExecuteDataset - Executes a command that returns rows as a DataSet
  • ExecuteReader - Executes a command that returns rows as a SqlDataReader
  • ExecuteScalar - Executes a command that returns a single value as an object
  • FillDataset - Executes a command that populates a DataSet that is provided as a parameter
  • UpdateDataset - Executes a given command for each inserted, updated, or deleted row in a DataSet
  • CreateCommand - Creates a command object given a stored procedure and parameters
  • ExecuteNonQueryTypedParams - Executes a command that does not return rows using a DataRow’s column values as parameters
  • ExecuteDatasetTypedParams - Executes a command that returns rows as a DataSet using a DataRow’s column values as parameters
  • ExecuteReaderTypedParams - Executes a command that returns rows as a SqlDataReader using a DataRow’s column values as parameters.
  • ExecuteScalarTypedParams - Executes a command that returns a single value as an object using a DataRow’s column values as parameters.

The following code is from the demo application:

private void RefreshData()
{
    this.dataGridView1.DataSource = 
    SqlHelper.ExecuteDataset(SQLHelp.Connectionstring, CommandType.Text, 
    "SELECT * FROM COUNTRY").Tables[0];
}

You could call a stored procedure like:

SqlHelper.ExecuteReader(connectionString, "getProductsByCategory",  categoryID);

You could download MSDAB V2 with documentation from here.

The documentation along with MSDAB covers everything about the SqlHelper class which also applies to FireBird SqlHelper.

There are also a great deal of samples available for MSDAB V2 which you could also use for FireBird SQLHelper.

History

  • 17th January, 2007: Initial post

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

Rafey
Web Developer
Pakistan Pakistan
Software engineer developing solutions using Microsoft technologies.

Comments and Discussions

 
GeneralMy vote of 5 PinmemberNazmi Altun7-Jan-12 7:50 
Questionhi,how to update a table Pinmemberyunhai1321-Sep-11 0:50 
AnswerRe: hi,how to update a table Pinmemberyunhai1321-Sep-11 15:52 
GeneralYou can get beeter and simple one Pinmembersam4u2u13-Nov-09 16:34 
GeneralFirebird SQLHelper PinmemberbuyValu11-Dec-07 11:18 
GeneralStored Procedures PinmemberbuyValu5-Jun-07 8:22 
I am attempting to call a Stored Procedure (SP) and need help with the syntax. The example in the source
int result = ExecuteNonQuery(connString, CommandType.StoredProcedure, "PublishOrders");)
implies that you simply insert the name of the SP in quotes. Either I have missed something, which is probably the case, or more information needs to be obtained before making the call. I am attempting to save a new record using an existing SP in the database. I would be most grateful to anyone who could point me in the right direction. It would really be nice if some has an example program showing how to call each of the overload functions. (I know that's wishful thinking)
 
TIA
QuestionUsing with Visual Studio 2003 pro PinmemberAndrewPoole30-Jan-07 23:24 
AnswerRe: Using with Visual Studio 2003 pro PinmemberRafey30-Jan-07 23:57 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Mobile
Web04 | 2.8.140916.1 | Last Updated 17 Jan 2007
Article Copyright 2007 by Rafey
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid