473,508 Members | 2,327 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 1216
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
6749
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
1867
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
1705
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
2449
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
5684
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
1317
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
307
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
3463
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
2859
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
7224
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
7120
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7323
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
5626
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
1
5050
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
3180
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1553
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
1
763
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
415
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

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.