Npgsql is the .NET data provider for Postgresql. It allows any program developed for .NET framework to access a Postgresql database server. It is implemented in 100% C# code. Postgresql versions since 9.0 are officially supported, others may work.
I get this:
1>C:\Program Files (x86)\Microsoft Visual Studio\2019\Community\MSBuild\Current\Bin\Microsoft.Common.CurrentVersion.targets(1175,5): error MSB3644: The reference assemblies for .NETFramework,Version=v5.0 were not found. To resolve this, install the Developer Pack (SDK/Targeting Pack) for this framework version or retarget your application. You can download .NET Framework Developer Packs at https://aka.ms/msbuild/developerpacks
but I'm not sure which one to download
@fmakowski yeah, as discussed in npgsql/doc#58 are incorrect - GetProperty is a method on JsonElement, so you need to call JsonDocument.RootElement. But you're saying you have issues using JsonElement too?
2 replies
I'm trying to use the method at https://docs.microsoft.com/en-us/ef/core/saving/transactions#controlling-transactions
Hello guys, I'm in a project at my university that need to work with spatial data which is geometry type (linestring). And I chose ASP .Net core 3.1 mvc to work with.
I have connected to postgres successfully. my database have 1 table which has fields as above
I have connected to postgres successfully. my database have 1 table which has fields as above
and now I dont know how to put that data in my view. I've try to get the geometry directly but it throw an exception about CordinateSystem type
thats how you create a view
and I cant find it on internet
I dont know my direction is right or wrong I just try to do it on asp.net core 3.1
https://www.npgsql.org/doc/types/geojson.html even the part about how to read an write that type of value?
thank you for spending time response me
Hello! Tell me please. I have the following situation:
- I open a connection to server A and send a test request
- After server B starts to process the request, I simulate a loss of connection with server B
(just setting up a rule for iptables on server B that does something like iptables -A OUTPUT -p tcp --dport {ephemeral_port_number} -j DROP) - After 10 seconds in a separate thread, I close the connection (in the hope that the ExecuteReader will stop executing). But in the end, the ExecuteReader is waiting for the Command Timeout allocated for it.
Is this considered normal behavior of a synchronous ExecuteReader?
In my scenario, I cannot use the asynchronous API (a lot of legacy code), so my task is to reverse the synchronous operation without waiting for the Command Timeout.
I will be glad to hear advice on which direction to move to solve the problem.
There is a graceful cancellation of the reader, so it should consume all data before closing the connection. To cancel the running command immediately, use
NpgsqlCommand.Cancel which will open a new connection and send a request to stop the current command running on the first connection.
@ruslanen to add to what @YohDeadfall wrote, you can indeed trigger PG cancellation (via a separate command) by calling NpgsqlCommand.Cancel. For 5.0 (to be released in two weeks) we've redone the whole cancellation/timeout mechanism to be much better; if the PG cancellation isn't successful after 2 seconds (by default), the socket will be closed and the connection will be broken.