- What versions of the MS.NET Framework are supported?
- Can the provider be used with Mono 1.x?
- Can the provider be used with the MS.NET Compact Framework?
- What versions of Firebird are supported?
- Can i use the provider with the Firebird embedded server?
- Does the provider use gds32.dll/fbclient.dll?
- Can the provider work with Delphi 8 for .NET?
- Can the provider work with Visual Studio .NET?
- Can i generate type datasets at design time using the FbDataAdapter component?
- Why FbDataReader.HasRows returns always true?
- Are weekly builds available?
- What ASP.NET providers are available to be used with the Firebird provider?
- 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. Are weekly builds available?Yes, you can find them
here.
return to top
12. 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
13. Can the provider be integrated inside Visual Studio 2005?Yes, using the Data Designer Extensibility (DDEX) provider.
return to top
