473,241 Members | 4,349 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,241 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 1179
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: WSeeger | last post by:
When creating a new class, is it encouraged to always include error handling routines within your LET and GET procedures? It's seems that most text books never seem to include much about error...
9
by: Hans-Joachim Widmaier | last post by:
Hi all. Handling files is an extremely frequent task in programming, so most programming languages have an abstraction of the basic files offered by the underlying operating system. This is...
3
by: Master of C++ | last post by:
Hi, I am an absolute newbie to Exception Handling, and I am trying to retrofit exception handling to a LOT of C++ code that I've written earlier. I am just looking for a bare-bones, low-tech...
21
by: Anthony England | last post by:
Everyone knows that global variables get re-set in an mdb when an un-handled error is encountered, but it seems that this also happens when the variable is defined as private at form-level. So...
3
by: Stefan Johansson | last post by:
Hi all I'am moving from Visual Foxpro and have a question regarding "best practice" error handling in vb .net. In VFP I have always used a "central" error handling object in order to have a...
4
by: Al Williams | last post by:
Hi, I have error handling in place throughout my application. I also start the application wrapped in error handling code to catch any unexpected exceptions (i.e. exceptions that occur where I...
9
by: Gustaf | last post by:
I'm confused about structured error handling. The following piece of code is a simplification of a class library I'm working on. It works, and it does what I want, but I'm still not convinced that...
7
by: yogeshnelwadkar | last post by:
Hello, i have a problem with replacing c++ exception handling with structured exception handling. How to replace the " catch(...) " in c++ exception handling with, __except , a structured...
41
by: Zytan | last post by:
Ok something simple like int.Parse(string) can throw these exceptions: ArgumentNullException, FormatException, OverflowException I don't want my program to just crash on an exception, so I must...
0
by: Lysander | last post by:
Thought I would give something back with a few articles. This article is a bit of code to add error handling. When I have time, I want to write articles on multilingual databases, and Access...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...

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.