Really need to recreate database in ADO?

  • Thread starter Thread starter Beverley
  • Start date Start date
B

Beverley

Hi all,

This seems like a dumb question, but I can't find the answer so here I am.
:) The program that I will be writing will be using an SQL database. Every
view, table, relationship, constraint, etc will already be defined in the
SQL database. Do I really need to repeat all of this information in the
ADO.NET part of the program?

The book I'm working with is telling me how to define, name, etc
relationships and I just want to say, "Here's the database. It's already
set up right. Use that schema and don't make me do any more work with it."

Is this not possible, or is it SO obvious that I'm missing it? :)

Thanks much,
Beverley
 
Hi Beverly,

Beverley said:
Hi all,

This seems like a dumb question, but I can't find the answer so here I am.
:) The program that I will be writing will be using an SQL database.
Every
view, table, relationship, constraint, etc will already be defined in the
SQL database. Do I really need to repeat all of this information in the
ADO.NET part of the program?

The book I'm working with is telling me how to define, name, etc
relationships and I just want to say, "Here's the database. It's already
set up right. Use that schema and don't make me do any more work with
it."
Click to expand...

Use that schema for what?
 
Miha Markic said:
Use that schema for what?
Click to expand...

I'm not sure what you mean. It's for use in ADO.NET. I will need to get
the data into the dataset, and work with it, without having to tell it that
this table is related to that table in the following way, etc.

It will be a Windows app with lots of inserts / updates / deletes.
 
The simple answer is no, you don't have to jump through all of those hoops
to access the database. Have you checked out the VS docs, MSDN, or sample
code available on the Web?
 
I've tried, but I must not be looking in the right places, because
everything I've found seems to walk me through creating everything from
(what feels like) scratch.

I've got a new book now that seems like it might be better, so maybe I'm on
the right track now. We'll see... :)

Thanks,
Beverley
 
Back
Top