Contact Us | Site Map
Firebird is used by approximately 1 million of software developers worldwide. High compatibility with industry standards on many fronts makes Firebird the obvious choice for developing interoperable applications for homogeneous and hybrid environments.
Join Firebird!
Join Firebird Foundation to support Firebird SQL development and receive multiple bonuses
Follow Us
Select your media preference
Google+ Twitter Facebook RSS
Newsletter
Subscribe to Firebird’s Newsletter to receive the latest news
Firebird .NET Provider — FAQ
  1. What versions of the MS.NET Framework are supported?
  2. Can the provider be used with Mono 1.x?
  3. Can the provider be used with the MS.NET Compact Framework?
  4. What versions of Firebird are supported?
  5. Can i use the provider with the Firebird embedded server?
  6. Does the provider use gds32.dll/fbclient.dll?
  7. Can the provider work with Delphi 8 for .NET?
  8. Can the provider work with Visual Studio .NET?
  9. Can i generate type datasets at design time using the FbDataAdapter component?
  10. Why FbDataReader.HasRows returns always true?
  11. What ASP.NET providers are available to be used with the Firebird provider?
  12. Can the provider be integrated inside Visual Studio 2005?

1. What versions of the MS.NET Framework are supported?

.NET 1.0, .NET 1.1, .NET 2.0 and the .NET Compact Framework 2.0

return to top

2. Can the provider be used with Mono 1.x?

Yes.

return to top

3. Can the provider be used with the MS.NET Compact Framework?

Yes, using the .NET Compact Framework 2.0 and the v2.0 of the ADO.NET Data Provider.

return to top

4. What versions of Firebird are supported?

Firebird 1.0.x, 1.5.x and 2.0 (it should work with InterBase 6.0 too).

return to top

5. Can i use the provider with the Firebird embedded server?

Yes, since v1.6, you should add a ServerType=1 to the connection string.

The provider will look by default (unless the assembly was built using the GDS32, FBCLIENT or VULCAN defines) for the fbembed.dll.

The embedded server documentation states that the fbembded.dll should be renamed to fbclient.dll or gds32.dll, that is not needed in the .NET provider (as mentioned before unless the provider wasn't build with the default defines).

return to top

6. Does the provider use gds32.dll/fbclient.dll?

No, you don't need to install the Firebird client to work with the .NET provider.

return to top

7. Can the provider work with Delphi 8 for .NET?

Yes, but no with the Borland Data Provider, for that you will need to use the Borland Data Provider for Firebird.

You need to add a reference to the provider assembly in your project and you can add the provider components to the Delphi 8 Toolbox.

return to top

8. Can the provider work with Visual Studio .NET?

Yes. You need to add a reference to the provider assembly in your project and you can add the provider components to the Visual Studio .NET Toolbox.

See this for a detailed explain.

return to top

9. Can i generate type datasets at design time using the FbDataAdapter component?

No, design time support is limited to the FbConnection and FbCommand components.

You can generate typed datasets by code using the TypedDataSetGenerator .NET class.

FbConnection connection = new FbConnection(connectionString);

DataSet employees = new DataSet("Employees");
FbCommand command = new FbCommand("select * from employee", connection);
FbDataAdapter adapter = new FbDataAdapter(command);
adapter.MissingSchemaAction = MissingSchemaAction.AddWithKey;

adapter.Fill(employees, "Employees");

// Generate the employee TypedDataSet
string fileName = @"d:\employee.cs";

StreamWriter tw = new StreamWriter(new FileStream(fileName,
FileMode.Create,
FileAccess.Write));

CodeNamespace cn = new CodeNamespace("employees");
CSharpCodeProvider cs = new CSharpCodeProvider();

System.Data.Design.TypedDataSetGenerator.Generate(dataSet, codeNamespace, csharpCodeProvider);

cg.GenerateCodeFromNamespace(cn, tw, null);

tw.Flush();
tw.Close();

employees.WriteXmlSchema(@"d:\employee.xsd");

connection.Close();

return to top

10. Why FbDataReader.HasRows returns always true?

The FbDataReader.HasRows property is implemented for compatibility only. It returns always true because Firebird doesn't have a way for know if a query returns rows of not without fetching the data.

return to top

11. What ASP.NET providers are available to be used with the Firebird provider?

Available providers can be found in the FirebirdSql.Web.Providers assembly are:
  • Membership Provider
  • Profile Provider
  • Role Provider
  • Session State Store Provider
return to top

12. Can the provider be integrated inside Visual Studio 2005?

Yes, using the Data Designer Extensibility (DDEX) provider.

return to top

Home About Firebird Documentation Downloads Community Support Development Case Studies Back to Top
This site and the pages contained within are Copyright © 2000-2014, Firebird Project. Firebird® is a registered trademark of Firebird Foundation Incorporated. Developed by DQ Team.