473,386 Members | 1,973 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,386 software developers and data experts.

SQL Tables to Objects guidelines

I have a quick question.

I am redefining a monolithic application i made when I was first
getting into dotnet and have a question about OOP architecture.

I laid out all my objects and came along one sql table that is a
lookup table, but it is used to lookup values in more than one other
table.

does this justify creating this SQL table into it's own object since
it will be used across multiple other objects? other lookup tables are
used in only one object so therefore i decided there is no need to
create seperate objects for them.

any help would be greatly appreciated. thank you.

dkode
Jul 21 '05 #1
1 1214
Overall, it is easier to work with individual data tables in a DataSet than
custom business objects. Rocky Lhotka would argue that this is not true OO,
but I see a DataSet as true OO, so I would disagree. The DataSet is a wise
direction to go, especially considering where MS is going with Whidbey.

There is an ASP.NET architecture webcast
(http://www.microsoft.com/usa/webcasts/) that covers business objects using
DataSets. I am not 100% convinced of the methodology yet, but it is quite
easy to program with. The session is run by Paul Sherriff, and is rather
easy to pick up on. Make sure you look at part 1, as part 2 is more Tips and
Tricks of architecture.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

************************************************** ********************
Think Outside the Box!
************************************************** ********************
"DKode" <dk***@cfl.rr.com> wrote in message
news:b1**************************@posting.google.c om...
I have a quick question.

I am redefining a monolithic application i made when I was first
getting into dotnet and have a question about OOP architecture.

I laid out all my objects and came along one sql table that is a
lookup table, but it is used to lookup values in more than one other
table.

does this justify creating this SQL table into it's own object since
it will be used across multiple other objects? other lookup tables are
used in only one object so therefore i decided there is no need to
create seperate objects for them.

any help would be greatly appreciated. thank you.

dkode

Jul 21 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: Andreas Lauffer | last post by:
I changed from Access97 to AccessXP and I have immense performance problems. Details: - Access XP MDB with Jet 4.0 ( no ADP-Project ) - Linked Tables to SQL-Server 2000 over ODBC I used...
9
by: Aguilar, James | last post by:
Hey guys. A new question: I want to use an STL libarary to hold a bunch of objects I create. Actually, it will hold references to the objects, but that's beside the point, for the most part. ...
1
by: Eshrath Ali Khan | last post by:
Hi, I have a requirement where I am creating table object with different ids using XSL by taking an XML as input. The no of objects (tables) is not fixed. I want to write a javascript to invoke...
4
by: serge | last post by:
I tried all the INFORMATION_SCHEMA on SQL 2000 and I see that the system tables hold pretty much everything I am interested in: Objects names (columns, functions, stored procedures, ...) stored...
4
by: =B= | last post by:
Hi, I was wondering if anyone has any opinions on naming conventions for ASP.NET objects? Up until now I've been using txtThis for Text Boxes, ddlThat for DropDownList, etc because I think it...
4
by: kd | last post by:
Hi All, What is the naming convention for objects? I checked the MSDN and found naming conventions for class members, etc; but could not find information on the objects. It would be great if...
1
by: DKode | last post by:
I have a quick question. I am redefining a monolithic application i made when I was first getting into dotnet and have a question about OOP architecture. I laid out all my objects and came...
22
by: amygdala | last post by:
Hi, I'm trying to grasp OOP to build an interface using class objects that lets me access database tables easily. You have probably seen this before, or maybe even built it yourself at some...
3
by: KNN | last post by:
Hi I have some tables with hidden attribute set to 1. In the query desgn view , I do not see these tables as expected. But, If I choose the query wizard to create a new query, then i do see...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

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.