Stack Overflow
Stack Overflow

Questions tagged [firebird-.net-provider]

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

58 questions
0
votes
1 answer

How to read data with charset NONE from Firebird database?

There are some old database that is based on NONE encoding and have unique Latin characters like á and are read like ? . Now, the correct form is to read DB in correct charset form NONE and it was specified in connection string, but the library…
Ionaș Cristian
  • 5
  • 5
0
votes
0 answers

Charset problems in Entity Framework Core 3.12 Firebird.Core 7.10.1 while filtering or inserting

Is it possible to set charset for filtering, inserting in Entity Framework not changing database default charset If I execute raw SQL, filtering works, but if I use objects, it fails if there are special characters. Working var sql =…
xcold
  • 1
  • 3
0
votes
1 answer

FirebirdSql.Data.FirebirdClient connecting with a user other than Sysdba - username and password are not defined

I use FirebirdSql.Data.FirebirdClient to connect to a Firebird database (WPF desktop app). Server Version: WI-V3.0.5.33220 Firebird 3.0, and ADO.net provider version is 7.5.0 (NuGet) I created a user other than SYSDBA that only has read only access…
dsungaro
  • 148
  • 1
  • 11
0
votes
1 answer

Firebirdclient and Select statements are slow for no reason

I have a .Net 4.6.1 Winforms application which has more or less 10 years. It has worked pretty well since the beginning, but in the last few weeks I faced a problem I never had. Firebird 2.5 (latest version available) .net client (latest version…
Francesco Giossi
  • 158
  • 9
0
votes
1 answer

EntityFramework Firebird Database First

I am trying to create models from database using Firebird EF from Nuget packages. I am running this command: Scaffold-DbContext "User=SYSDBA;Password=xxxxxxx;Database=XXXXXXXXX;DataSource=XXXXXXXXXX;Port=3050;Dialect=3;Charset=NONE;Role=;Connection…
mpp94
  • 23
  • 1
  • 6
0
votes
0 answers

DataSet not updating Database

I have a dataset with about 6 rows. I can confirm the dataset's table is filled by getting its row count. I fill the dataset with rows from a previously filled dataset from a different source. According to all the articles I've found here and on the…
Artur S.
  • 185
  • 3
  • 15
0
votes
0 answers

Defining a "one-to-one-to-one" relationship on Firebird 2.5 EF Core

I'm working with EF Core and a third-party Firebird 2.5 database and, for some reason, they decided to, rather than do a simple one-to-one relationship, create a single table with two columns that do that relationship itself,…
Artur S.
  • 185
  • 3
  • 15
0
votes
0 answers

String cast to decimal in Where, C# FbConnection

There is a condition on column written in text: SomeDecimalColumn = 1234567890 and I need to have a query to a Firebird database to include this condition. Naturally I tried: //query is a QueryObject of firebird…
Alexandr Crit
  • 111
  • 1
  • 14
0
votes
1 answer

Prevent Firebird from printing queries in Visual Studio debug output window

We have newly adopted Firebird in our project, using it via Entity Framework. I now noticed that Firebird prints every query to Visual Studio's debug output window. Here's a simplified example: FirebirdSql.Data.FirebirdClient Information: 0 :…
herzbube
  • 13,158
  • 9
  • 45
  • 87
0
votes
0 answers

C# Firebird BLOB_SUB_TYPE_0 Image Save

I have a field like "BLOB_SUB_TYPE_0" in the Firebird database using C#. How can I export pictures? C# Console.App using (var conn = new FbConnection(connectionString)) { conn.Open(); using (var command = new…
Barış Sakızlı
  • 23
  • 5
0
votes
1 answer

Generators Firebird - Entity Framework Code First .Net

I used Code First to create 2 tables (Master and Details), the problem is that Entity Framework inserted the same Generator for both tables, so when I insert a new record the trigger skips the ID numbering (1,3,5... for Master and 2,4,6... for…
Fernando Donizeti Ito
  • 33
  • 7
0
votes
0 answers

Firebird Client connection pooling doesn't work correctly

A connection pool in FirebirdClient seems to be broken. It should queue my queries when is already empty but I get an exception instead. I need a help how to deal with this problem. I'm using FirebirdClient version 7.1.1. I am running a console .Net…
Piotr Kościelniak
  • 11
  • 4
0
votes
0 answers

C# SQL Command .Fill takes too long when called upon Firebird server, join a table with stored procedure

I'm trying to dump data from Firebird SQL 2.5 database with little or no success, because I'm trying to make a join between a table and stored procedure. The code representing the problematic query is following: select U.SYMBOL , '0' AS…
Krzysztof Jakóbczyk
  • 149
  • 1
  • 6
1 2 3
4