SQL Tables to Objects guidelines

DKode

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

Subscribe Reply

1238

Cowboy \(Gregory A. Beamer\)

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.c om> wrote in message
news:b1******** *************** ***@posting.goo gle.com...

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

Similar topics

6764

Bad performance in queries with Jet4.0 and linked ODBC-tables to SQL-Server 2000

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 the SQL Profile to watch the T-SQL-Command which Access ( who creates the commands?) creates and noticed:

Microsoft SQL Server

1881

Deleting objects obtained from a STL library

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. Here's the question: I want to be able to change the references (including deleting them). Is there any way to do that besides using pointers rather than references for the STL library? I'd also prefer to avoid using const_cast, if it is indeed...

C / C++

1722

How to get the object ids of all the tables and use them to invoke a function of the object.

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 all these objects. I can pass the number of objects (Tables) available in the documents as a parameter to the javascript function. Can you please tell me how to invoke all those objects. Basically these objects are nothing but a active X...

Javascript

2453

Anything that you find in SQL object scripts, you can also find them in system tables?

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 procedure statements in syscomments table. My questions are: If you script your whole database everything you end up having in the text sql scripts, are those also located in the system tables? That means i could simply read those system tables...

Microsoft SQL Server

5691

Naming conventions for ASP.NET objects?

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 helps the readability. When working with a code-behind file you can tell what type of object you're accessing. Of couse, this Hungarian notation is frowned upon by the Microsoft guidelines for classes at

ASP.NET

1333

Naming convention for objects

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 anybody could provide me the link to the same. Thanks. kd

Visual Basic .NET

307

SQL Tables to Objects guidelines

by: DKode | last post by:

.NET Framework

3494

OOP database tables <-> php interface (semi LONG)

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 point in time. I have studied some examples I found on the internet, and am now trying to build my own from scratch. I have made a default table class (DB_Table), a default validation class (Validator) which is an object inside DB_Table and my...

PHP

2878

Hidden tables in query wizzard

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 these hidden tables. How to hide these tables in the query wizard. Thanks

Microsoft Access / VBA

8438

What is ONU?

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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

8863

Problem With Comparison Operator <=> in G++

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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

8779

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

8549

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

8636

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

7376

AI Job Threat for Devs

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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

6187

Access Europe - Using VBA to create a class based on a table - Wed 1 May

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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

2765

transfer the data from one system to another through ip address

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 we have to send another system

C# / C Sharp

1761

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

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 can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General