Tagged Questions
0
votes
0answers
14 views
Change the schema from elmah_error table in Postgres
I wanto to change the schema of the elmah_error table from public to elmah.
I'm getting this error: Npgsql.NpgsqlException: relation "elmah_error" does not exist. It keep's searching for this table ...
1
vote
0answers
27 views
Is there way to get PostgreSQL service name?
Is there way to get PostgreSQL service name?
I mean something like SELECT @@SERVICENAME as in MS SQL Server. Or maybe it is declared in one of config files?
It's called Service ID:
2
votes
4answers
44 views
Sending an automatic email periodically
I have Windows server with PostgreSQL database. I stored in the database employees data including contract expiry date.
I would like to send an automatic email for each employee 30 days before the ...
0
votes
0answers
16 views
Can not update a PostgreSQL table with auto id under FluentNHibernate
When using SchemaUpdate() to export a mapped class with auto-incremented id to a PostgreSQL server the following exception is thrown:
"ERROR: 42P07: relation "seq_wuf" already exists".
The exception ...
0
votes
1answer
60 views
Unable to create database in PostreSQL using Npgsql and Entity Framework code first
I am attempting to set up my application to use Entity Framework with PostgreSQL, but I have run up against a problem. I have added Npqsql via nuget, and added the following provider factory to ...
0
votes
2answers
54 views
Postgres analog for c# SQL Server´s stored procedure CLR
It is know that SQL Server offers some extensibility mechanisms like user-defined functions, stored procedures, triggers...
I have C# code that runs in SQL Server 2008 (it is a stored procedure that ...
0
votes
0answers
25 views
SchemaValidator fails with my quoted table name
I'm using NHibernate for my database layer and Fluent NHibernate to generate the mappings for it, and I'm having a trouble (could be a bug?) when I specify a quoted custom table name for one of my ...
0
votes
0answers
45 views
Weird error on transactions -> using NonQuery getting Reader must be closed
I'm developing a client in C# and POSTGRESQL.
It needs to parse some texts and insert data in the tables correctly, so we have a parsed which gives me a Dictionary for each tables (4 at the moment).
...
1
vote
4answers
125 views
LINQ to PostgreSQL errors when using DbLINQ
I'm using LINQ to SQL (PostgreSQL) via DbLINQ.
I have a problem doing LINQ to PostgreSQL. I succesfully generated .dbml and .cs files with dbmetal and I think I got all the references, the code ...
1
vote
0answers
30 views
Connecting to PostgreSQL through proxy
I use in my C# Winform project PostgreSQL via Npgsql. I connect my app to PostgreSQL using the below connection string:
String connstring = String.Format("Server={0};Port={1};" +
...
1
vote
1answer
71 views
Count + List with Futures not working
I'm having problems with Futures in Nhibernate 3 and can't realize what's wrong.
The following code (without Futures), works as expected:
SessionHandler.DoInTransaction(transaction =>
...
0
votes
0answers
54 views
PostgreSQL Connection random errors
I'm running a set of tests using NUnit. Each test does connect to PostgreSQL database and does something there.
Sometimes I'm getting NullReferenceException with this stack trace:
at ...
0
votes
0answers
19 views
Npgsql can't make a query with lowecase table name [duplicate]
Possible Duplicate:
Disable Table Name Double Quoting on FluentNhibernate
My tables in Postgre db are in lower case ( [customer] for example ). The problem is when I try to use Fluent ...
2
votes
1answer
32 views
PostgreSQl, How to establish OdbcConnection in C#
I want to connect PostgreSQl DB to my C# project and i have found this code
OdbcConnection DbConnection = new OdbcConnection("connection_string");
My problem is:-
what i can use as the connection ...
2
votes
1answer
54 views
Composite Key not trying to persist the key value
OK, I'm scratching my head once again. I have a class like so:
public class ReconciliationReportLineItem
{
public virtual int ID { get; set; }
public virtual int Category { get; set; }
...
