By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,117 Members | 1,093 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,117 IT Pros & Developers. It's quick & easy.

postsql and c#

P: 3
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 connectionstrings 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
Jan 21 '09 #1
Share this Question
Share on Google+
6 Replies


Frinavale
Expert Mod 5K+
P: 9,731
Have you checked out:
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
Jan 21 '09 #2

10K+
P: 13,264
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.
Jan 21 '09 #3

P: 3
Thx r035198x!!! The connection works! Is it true that postgresql is much faster than ms acces?
Jan 21 '09 #4

10K+
P: 13,264
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.
Jan 22 '09 #5

P: 3
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..
Jan 22 '09 #6

10K+
P: 13,264
The most important factors to consider for database performance on queries are usually number of records and whether the tables are properly indexed.
Jan 22 '09 #7

Post your reply

Sign in to post your reply or Sign up for a free account.