Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 800
  • Last Modified:

Should I use ADODB, OLEDB or ADOX?

Dear experts,

I am writing a C# Windows form program to integrate some data from Access databases. A lot of INSERT and UPDATE will be made. What is the best way to establish the database connection, ADODB, OLEDB, ADOX? Thanks in advance.
0
quziguang
Asked:
quziguang
2 Solutions
 
Jeffrey CoachmanMIS LiasonCommented:
Define "Integrate" in terms of exactly what you will be doing.

I think I see more ADO than anything else..
0
 
rockiroadsCommented:
I reckon either ado.net or oledb would be good enough. I am not sure but I did read somewhere ado.net slightly slower but don't quote me on that.

some alternatives to throw at you. Have a look at linq (though I don't think there is much out there for msaccess) and if u want to hide more of the coding, nhibernate though it probably not worth it if you are just doing some updates
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
rockiroadsCommented:
0
 
quziguangAuthor Commented:
Thanks to all for answering.
I'd like to accept both minhvc and rockiroads' answers. It looks like OLE DB is the one to use.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:

 All are the same thing.   OLEDB is a data provider, ADO a consumer.  ADOX is ADO extentions for security, etc., which you may not need.

 In short, you'll be using ADO, which will talk to the JET OLDEDB provider.

Jim.
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now