Tagged Questions
1
vote
1answer
29 views
Return multiple PostgreSQL values in table format
Pretty much stuck on this for the past few days. I wouldn't normally post here but what I'm trying to come up with just searching on my own doesn't work. I want to query PostgreSQL and come up with ...
0
votes
1answer
21 views
Getting search_path to work with Npgsql
What is the appropriate way to set the search_path for a particular user on either the entire database or just a schema in PostgreSQL in order for it to work via Npgsql?
Let's take my user reader for ...
1
vote
1answer
40 views
insert into postgresql table using c#
i have two postgreSQL tables linked by a foreign key.
I want to insert into the second table the data coming from the first table primary key.
I wrote that in my c# application :
command1.CommandText ...
1
vote
1answer
47 views
error 42601 syntax error at or near
I'm using a c# application to load a postgresql table with appropriate data. Here is the code:
NpgsqlConnection conn = new NpgsqlConnection("Server=localhost;Port=5432;UserId=postgres;Password=***** ...
-4
votes
1answer
45 views
nhibernate mapping by code troubles [closed]
I have an entity:-
public class Employee{
private List<Employee> subbord = new List<Employee>();
private int id;
private string surname;
public virtual Employee Boss { get; set; }
...
0
votes
2answers
46 views
NHibernate - first query is painfully slow
Database table (PostgreSQL) containing 10000 rows:
CREATE TABLE test
(
id bigserial NOT NULL,
text text,
CONSTRAINT test_pkey PRIMARY KEY (id)
)
Classes:
public class Test
{
public ...
0
votes
0answers
28 views
Notify FUNCTION in PGSQL to pass column values to C#
I have a TRIGGER created in PGSQL to NOTIFY my c# app when a new ROW is created in my TABLE with a matching condition on a column value.
FUNCTION to send msgfail to c#:
CREATE OR REPLACE FUNCTION ...
0
votes
1answer
28 views
How do I set encoding in an NpgsqlConnection
I have a PostgreSQL database, which uses character encoding WIN1252.
When querying the database, some records will produce an error when trying to read the data, because it is trying to convert it to ...
0
votes
1answer
30 views
Castle Activerecord error is “relation does not exist” on Postgresql?
ActiveRecord mape:
[ActiveRecord("JobTitle",Schema="public")]
public class JobTitle :ActiveRecordValidationBase<JobTitle>
{
[PrimaryKey(Column = "Id")]
public virtual int Id { get; ...
1
vote
2answers
56 views
Error in TEXT field (PostgreSQL) - NHibernate can't read it
I have this entity:
public class Product
{
public virtual long ID { get; set; }
public virtual string Name { get; set; }
public virtual string Description { get; set; }
public virtual ...
3
votes
1answer
56 views
How to set InsertCommand parameter as function call?
I working on a GIS application which uses the PostgreSQL database with PostGIS extension. I already created the data access logic for entire project and everything works fine except the geometry value ...
0
votes
1answer
33 views
IManyToManyCollectionInstance convention creating extra table
I have a Fluent NHibernate convention-based mapping with a Many-to-Many relationship between my StockPurchase entity and my StockSale entity.
I created the following convention:
public class ...
1
vote
2answers
77 views
Another “There is already an open DataReader associated…”
Any tips how to close the DataReader? I use postgresql and MARS is only for SQL. Or maybe I don't need MARS for this problem I don't know. The error shows in the foreach loop. Thank you for your tips.
...
5
votes
1answer
103 views
timestamp with timezone postgresql mapping
How Can I map "timestamp with time zone" datatype from postgreSql to System.Data.DbType
I need to pass parameter as it will go to the column which has "timestamp with time zone"
following is my ...
0
votes
1answer
86 views
Using DataGridView to add, remove and update records in PostgreSQL
I use a DataGridView to display rows from PostgreSQL, which works fine. Now whnt I want to implement is an editor that can add, edit and remove rows from that DataGridView. To do so, I have created ...
