Most voted "npgsql" questions
Npgsql is an open source ADO.NET data provider for Postgresql, which allows programs written in C#, Visual Basic . NET, F# and other languages implemented in . NET access the Postgresql database server.
Learn more…15 questions
Sort by count of
-
6
votes1
answer230
viewsFilter Postgresql Information on Windows Forms screen using Entity Framework
Is there any way to search for the information in postgresql by nickname? But without using alias, only in the field register in the table I already enter the real name for the field? Example:…
-
5
votes1
answer459
viewsError Connecting Postgresql to Entity Framework
I am trying to connect the EF in Postgresql. You are presenting the following message: An unhandled Exception of type 'System.Configuration.Configurationerrorsexception' occurred in…
-
4
votes1
answer456
viewsProblems restoring a Postgresql database 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…
-
2
votes2
answers232
viewsInheritance with Entity Framework
I have a doubt in the inheritance part, I have the person and user classes. Person has its basic attributes and the user inherits from the person. So far so good is right. My problem is that in…
-
2
votes2
answers311
viewsReturn Value ID C# Npgsqlcommand
After inserting a row of information in a given table, I need to recover the ID value to fill my object, my code is like this: using (NpgsqlConnection pgsqlConnection = new NpgsqlConnection(conn) {…
-
2
votes0
answers77
viewsProblem running a function in Asp.net.core.webapi + postgresql + npgsql+Dapper
I have a Webapi in Asp.net core, using postgresql as a database. Inside postgresql, I have the following function: CREATE OR REPLACE FUNCTION evento_distancia( IN lat numeric, IN lng numeric, IN…
postgresql asp.net-web-api asp.net-core dapper npgsqlasked 5 years, 3 months ago Thiago Oliveira 147 -
1
votes1
answer997
viewsAccentuation problem in postgresql with npgsql
I have a database postgresql raised with encoding SQL_ASCII and template0. When I try to select lines with accents like NAY gives error, but if the records have no accent works normally. Mistakes:…
-
1
votes1
answer57
viewsDatagridview with Custom Value Dataset
Hello, good morning, sir. I would like to ask you for help on the following situation: Use the Postgresql database integrated with Visual Studio Enterprise with the package (Npgsql Postgresql…
-
1
votes2
answers350
viewsHow 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,…
-
1
votes0
answers33
viewsUpdate does not commit bank changes
Good night, you guys! I’m new to ASP NET MVC and I’m making a CRUD simple with bench Postgresql. I’ve already implemented the Insert, delete and Get, but the Update is not saving the changes in the…
-
0
votes0
answers113
viewsQuery takes time to complete
Good afternoon, you guys, am having a problem executing a query in c# using NPGSQL. try { bdConn.Open(); NpgsqlCommand sql = new NpgsqlCommand(); sql.Connection = bdConn; sql.CommandText = query;…
-
0
votes1
answer81
viewsError while disconnecting from Postgresql
I am trying to make an application in C# using SGDB Postgresql, but always when I close the connection gives the following error: Undefined object reference for an object instance. I’m using the…
-
0
votes0
answers27
viewsRemove Row from table and adjust Ids
Greetings. I’m a beginner in the database and wanted to know the correct way to remove an item from the table and update the identification number of the others. This is the typical novice problem,…
-
0
votes0
answers26
viewsNpgsql.Postgresexception: 53300: remaining Connection slots are reserved for non-replication superuser Connections
I am using Dotnet Core and C# to fetch data from an API and saving to a Postgresql database. And arrives at a certain part of the process in which this error appears: Exception has occurred:…
-
-1
votes1
answer30
viewsHow to read a 'Boolean' column using NPGSQL?
I have the following code at the event Validated textbox: NpgsqlConnection conn = new NpgsqlConnection( "Server=127.0.0.1; port=5432;User; Id=postgres; Password=572600;Database=Sistema");…