ADO.NET provider for Firebird is a C# library for connecting Microsoft .Net programs with Firebird SQL server. Use this tag for question on connecting and using Firebird from C# applications using the FirebirdSql.Data.FirebirdClient (Firebird ADO.net provider) driver
I have a regression with a TCP\IP connection string post a firebird 3 migration from v2.5. The FirebirdClient version is 4.6.1 but I've tested with the latest stable version and it also doesn't work (v7.10.1).
The error message is "Your user name…
I currently have an ASP.NET Core 3.1 project and I'm using FirebirdSql.EntityFrameowrk.Core.Firebird v7.5.0.
When trying to update the database from a simple migration with a primary key and a string column
public class TB_CUSTOMER
{
[Key]
…
How I can set this options to FbTransaction
write
nowait
rec_version
read_committed
in my code to execute insert/update sql statements:
FbConnectionStringBuilder fbConnStr = new FbConnectionStringBuilder();
using (FbConnection fbConn = new…
I have COMPUTER_WITH_DATABASE where is superserver firebird (windows) installed.
Now i need to make c# application which will connect to this COMPUTER_WITH_DATABASE and create file .fdb like for example database.fdb to be later able to connect from…
I have narrowed done my problem to small sample where this issue can be easily produced.
Brief -
I am using embeded dll's of firebird for database connectivity i.e. fbembed.dll to connect to firebird databases.
In code, i have three connection…
I have a .Net 7 application that uses scaffolded Identity. I was successfully able to build the scaffolded database using SQLite - I now want to try using Firebird.
I get following error:
Method not…
I am currently trying to port a .NET Framework application to .NET Core. We're using Firebird as a database. I updated the dependencies and most issues could be solved, but when compiling and starting the program I get the error:
Unable to…
I've read the following thread and I was able to make a conversion script (based on C#) that converts all my charset=NONE databases to charset=UTF8 and most of it works great (I still have a few special cases where characters are converted to weird…
How can I check if the value of a field is numeric or not in a Firebird database? This seems like an easy problem but I can't find anything in the FreeUDFLib or standard Firebird library. Here's how I would do it in SQL Server.
Select field
from…
I have a pretty strange problem when trying to connect my C# program to an existing Firebird server.
First of all, this is reproducable with the default connection example from the Firebird documentation at…
I have a Firebird database with tables. I need to generate DbContext, models etc. So provider installed:
Connection string is OK:
Console.WriteLine("Starting");
FbConnection db = new…
I would like to update a list of rows given by a list of IDs. Normally, the parameters of the query can be passed via the parameter property. But if I pass a list of IDs, Firebird will not accept the query. I'm using the…
I am trying to connect to Firebird database using BIML script, but I'm getting errors about not supported keywords like "DataSource". When I change them to "Data Source" it is supported, but then BIML tries to connect to Firebird database via…
