471,317 Members | 1,459 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,317 software developers and data experts.

DB handling in C#

JW
What classes and APIs are available in .NET if program need database
support?

I have used OleDB but are there others too? Pooling such be supported,

Cheers, JW
Dec 3 '05 #1
4 1140
The ADO.NET related namespaces and classes (System.Data, System.Data
SqlClient and other providers) all have extensive support for database work.
In addition, there are interfaces that one can use to write your own custom
provider classes such as IDbCommand, IDbDataReader, IDbConnection et. al.

There is plenty of good sample code in the Quickstarts applications as well
as in the installable Samples. These are avaiable as installation options
either from Visual Studio.NET or the free .NET Framework SDK.
Peter
--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com


"JW" wrote:
What classes and APIs are available in .NET if program need database
support?

I have used OleDB but are there others too? Pooling such be supported,

Cheers, JW

Dec 3 '05 #2
Hi JW,
here we go, the system.data class:
http://www.kleinurl.de/?3mw7p9vj

system.data.odbc:
http://www.kleinurl.de/?uuwzv8o1

system.data.oledb:
http://www.kleinurl.de/?nfsq6kcj

system.data.oracleclient (.net 1.1 only)
http://www.kleinurl.de/?jfooktkx

and some other helpful classes you will find somewhere near these classes in
the online msdn library.

greetings from germany
chris

Dec 3 '05 #3
There are several different classes to access a db but I think the
easist and "type-safest" way is to use VS to create data adapters and
generate data sets. They're quirky and there's a bit of a learning
curve but it really saves a lot of work.

I'm developing a db and a WinForms front end for it as I go, constantly
making changes the db (adding tables, changing schema and constraints
etc.) It's a pretty complicated project with about 35 interrelated
tables. To keep the program code in sync with the db would be a
nightmare w/o generated data sets.

Unfortunately the MSDN documentation on data sets is rather of sparse,
I had to figure out a lot through trial-and-error. (Same with the
winforms DataGrid control.)

Paul

Dec 4 '05 #4
BTW I'm using VS 2003

Dec 4 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

9 posts views Thread by Hans-Joachim Widmaier | last post: by
3 posts views Thread by Master of C++ | last post: by
3 posts views Thread by Stefan Johansson | last post: by
9 posts views Thread by Gustaf | last post: by
7 posts views Thread by yogeshnelwadkar | last post: by
41 posts views Thread by Zytan | last post: by
reply views Thread by rosydwin | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.