postsql and c#

[pLatonet]

Hi,

I have a psql database, but i don't know how to acces it with Visual Studio 2008, in c#.
I have used a lot of connectionstrin gs but none of these works. And if i use the wizard of data sources (add new data source) i don't know which one to choose.

Thank you

[Frinavale]

Have you checked out:

• How to use a database in your program
• How to use a database in your program part II

The first article explains how to use a database in your program and gives an example of how to connect to an MS Sql Server database. The second article extends the first one by explaining how to connect to databases that are not MS Sql Server.

If you are still having problems, please post any code that you have for connecting to the database and any error messages you are getting.

-Frinny

[r035198x]

If you are talking about Postgresql, then the efficient way would be to use Npgsql. Be sure to read their manual to find out how to use it.

[pLatonet]

Thx r035198x!!! The connection works! Is it true that postgresql is much faster than ms acces?

[r035198x]

I would never compare MS Access with any real database on any day but I'll just say that don't believe everything you hear.

[pLatonet]

Okay, i just asked it because i work with a timed import with an interval of 2000 miliseconds. and i hope i can read that fast 3 querys with columns like sum, avg, count..

[r035198x]

The most important factors to consider for database performance on queries are usually number of records and whether the tables are properly indexed.