Questions tagged as 'npgsql'

Tagged questions
1
answer

Filtering PostgreSQL information on Windows Forms using Entity Framework

Is there any way to find the information in postgresql by nickname? But without using alias , just in the field record in the table do I already enter the real name for the field? Example:    customer_id will be called "Customer Code"  ...
asked by 17.04.2017 / 22:36
1
answer

Error when connecting PostgreSQL to the Entity Framework

I'm trying to connect to EF in Postgresql. You are running the following message:   An unhandled exception of type   'System.Configuration.ConfigurationErrorsException' occurred in   System.Configuration.dll       Additional information: An...
asked by 24.03.2017 / 02:11
2
answers

Inheritance with Entity Framework

I have a question on the inheritance part, I have the classes person and user. Person has its basic attributes and the user inherits from the person. So far so good, that's right. My problem is that in context mapping I'm passing the user, bu...
asked by 06.04.2017 / 03:57
2
answers

Return Value ID C # NpgsqlCommand

After inserting a line of information into a given table, I need to retrieve the ID value to fill my object, my code looks like this: using (NpgsqlConnection pgsqlConnection = new NpgsqlConnection(conn) { pgsqlCo...
asked by 06.09.2018 / 23:38
1
answer

DataGridView with DataSet Custom Value

Hello, good morning. I would like to ask you for help on the following situation: I use the PostgreSQL database integrated with Visual Studio Enterprise with the (PostgreSQL Integration) Npgsql package. For those who do not yet know this pa...
asked by 13.09.2018 / 15:58
1
answer

Problems restoring a database in PostgreSQL with C #

private void btnRestore_Click(object sender, EventArgs e) { if (clsB.ConectaBanco()) { //Executo a seguinte função para limpar a base de dados, para poder dar o restore. clsB.ExecutarSQL("drop schema public cascade; create...
asked by 14.09.2017 / 19:44
1
answer

Problem with accentuation in postgresql with npgsql [duplicate]

I have a postgresql database created with encoding SQL_ASCII and template0 . When I try to select rows with accents like NOT it gives error, however if the records do not have an accent it works normally. Errors:    Error parsing...
asked by 25.08.2016 / 14:44
1
answer

Error when disconnecting from PostgreSQL

I'm trying to make a C # application with PostgreSQL SGDB, but whenever I close the connection it gives the following error:    Object reference not set to an instance of an object. I'm using mono.security and npgsql2 but I...
asked by 12.12.2016 / 16:03
0
answers

Npgsql 3.2.2 or higher my application is running very slow

I installed the new version of Npgsql (4.0.3), but my application started to get very slow. The whole process, including opening a window that does not use a connection. I tested and upgraded to version 3.2.1 my application runs normally. I do n...
asked by 27.11.2018 / 19:52
2
answers

How to configure PostgreSQL AutoIncrement using EF Core

I have a table mapping (Entity Framework Core 2.0) in which the Id field needs to be AutoIncrement. The problem is that PostgreSQL is starting with high value and often jumps to very high sequences, type, increasing by 10 from 10. What am...
asked by 21.09.2018 / 23:49