Tagged Questions
13
votes
1answer
7k views
PostgreSQL and C# Datatypes
I searched type convertion table between PostgreSQL and C#, but I couldn't find anything.
I'll research empty cell on above table if I have time.
But if you know the web page which has these ...
0
votes
2answers
424 views
How to retrieve randomized data rows from a postgreSQL table?
I have a table on a PostgreSQL server database with almost 3 million rows and I need to save all rows to a CSV file. The problem here is that the rows must be saved in a different random order each ...
2
votes
1answer
127 views
Postgresql use alternative character instead of quote for column and table names
Is it possible to use different character instead of " for PostgreSQL table and column names?
Something like:
select [TableID], [TableColumn] from [TableName]
or
select 'TableID', 'TableColumn' ...
1
vote
2answers
1k views
C# / Postgres / FluentNHibernate : configuring npgsql throws NotSupportedException
Sometimes I really start wondering what's going on in my sourcecode:
I'm trying to connect to PostGres 9.0 using npgsql 2.0.11.0, which I'm damn sure I already did, but right now, my program throws a ...
26
votes
6answers
17k views
C# .NET + PostgreSQL
I'm looking at working on a project which uses C#.NET (sitting on a windows box) as the primary language and PostgreSQL as the backend database (backend is sitting on a linux box). I've heard that ...
6
votes
3answers
1k views
Quoting column names with NHibernate and PostgreSQL
I have started to use NHibernate 3.0 and PostgreSQL for a small project, so far the ride has been a little rough due to the NHibernate site being down and I'm sure this answer is on their website ...
2
votes
2answers
2k views
How to pass parameter to sql 'in' statement?
I want to create this query:
select * from products where number in ('123', '234', '456');
but I can't find any example of achiving this with Npgsql and NpgsqlParameter. I tried like this:
...
4
votes
2answers
10k views
LINQ-to-Entities select clause containing non-EF method calls
I'm having trouble building an Entity Framework LINQ query whose select clause contains method calls to non-EF objects.
The code below is part of an app used to transform data from one DBMS into a ...
2
votes
2answers
556 views
PLINQ on ConcurrentQueue isn't multithreading
I have the following PLINQ statement in a C# program:
foreach (ArrestRecord arrest in
from row in arrestQueue.AsParallel()
select row)
{
Geocoder ...
1
vote
1answer
851 views
How to make PostgreSQL trigger and C# Windows Service work together?
I want to write a windows service in C# that will wait for a change in the particular table in PostgreSQL database and then operate based on the data from the last inserted row.
As far as I know (I'm ...
0
votes
1answer
501 views
Linq to Postgresql
I have a program written in C#, which uses Linq to NHibernate to access the data. The database backend is Postgres.
In my application, I have a table called contractors, which has 10,000 records. ...
7
votes
1answer
332 views
Recommended approach to insert many rows with Castle ActiveRecord and ignore any dupes
I have a webmethod that inserts a bunch of recipes into a queue in the database (to store recipes the user is interested in cooking, similar to NetFlix's movie queue). The user is able to check off a ...
1
vote
1answer
133 views
Lock table in PostgreSQL
I have a table "Links" with some download links.
My .NET application reads this table, takes the link, creates a web client and downloads the associated file.
I want to create several threads that do ...
1
vote
2answers
269 views
Improve MMO game performance
we are all aware of the popular trend of MMO games. where players face each other live.
My area of concern, is storage of player moves and game results.
Using Csharp and PostgreSql v9.0 via ...
1
vote
1answer
623 views
What is the Date type in npgsql?
I am using postgreSQL database. I need to add "Date" parametres with SQL query. What do I have to write where I wrote in the code "XXX"
Here is the source code:
NpgsqlCommand RupCmd = new ...
