Ok,
My staff has determined that we will be using custom business objects
for a new app we are creating. we have an object that is called
Employee.
The employee object has about 8 lookup tables with a FK in the
employee table and two other tables that will be custom objects
themselves.
My question is, what is the best way to handle these lookup tables
data in my Employee class? when i create stored procs for getting an
employee should i just use joins and then make public propertys so a
user can change the lookup table fk's and just setup another property
for the lookup table text value? or is there a better way to handle
something like this.
Example:
Employee table
employeeID
stateID
sexID
State table
stateID
State
Sex table
sexID
Sex
i just want to make sure everything is optimized and setup correctly
so we don't run into scalability problems once our app is deployed and
requires structure changes.
any help would be appreciated. thank you.
2  1598 
You can use a DataRelation object to accomplish this if they all reside in
the same dataset.
"DKode" <dk***@cfl.rr.c om> wrote in message
news:b1******** *************** ***@posting.goo gle.com... Ok,
My staff has determined that we will be using custom business objects
for a new app we are creating. we have an object that is called
Employee.
The employee object has about 8 lookup tables with a FK in the
employee table and two other tables that will be custom objects
themselves.
My question is, what is the best way to handle these lookup tables
data in my Employee class? when i create stored procs for getting an
employee should i just use joins and then make public propertys so a
user can change the lookup table fk's and just setup another property
for the lookup table text value? or is there a better way to handle
something like this.
Example:
Employee table
employeeID
stateID
sexID
State table
stateID
State
Sex table
sexID
Sex
i just want to make sure everything is optimized and setup correctly
so we don't run into scalability problems once our app is deployed and
requires structure changes.
any help would be appreciated. thank you.
Well,
We are going to be using a dataset as the transfer method between the
data access tier and the business tier, but what we are trying to
determine is the best way to store the lookup table information in our
business layer as i mentioned.
"William Ryan" <do********@nos pam.comcast.net > wrote in message news:<eT******* *******@tk2msft ngp13.phx.gbl>. .. You can use a DataRelation object to accomplish this if they all reside in
the same dataset.
"DKode" <dk***@cfl.rr.c om> wrote in message
news:b1******** *************** ***@posting.goo gle.com... Ok,
My staff has determined that we will be using custom business objects
for a new app we are creating. we have an object that is called
Employee.
The employee object has about 8 lookup tables with a FK in the
employee table and two other tables that will be custom objects
themselves.
My question is, what is the best way to handle these lookup tables
data in my Employee class? when i create stored procs for getting an
employee should i just use joins and then make public propertys so a
user can change the lookup table fk's and just setup another property
for the lookup table text value? or is there a better way to handle
something like this.
Example:
Employee table
employeeID
stateID
sexID
State table
stateID
State
Sex table
sexID
Sex
i just want to make sure everything is optimized and setup correctly
so we don't run into scalability problems once our app is deployed and
requires structure changes.
any help would be appreciated. thank you. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: CoreyWhite |
last post by:
The future of computer architecture will use lookup tables. Currently
computer processor speed outweighs the benefits of using computer
memory for lookup tables, except in some cases. As computer memory
increases, new ROM chips will be built with lookup tables hardcoded
into them. Here is an example of what using a lookup table can do for
you. The following program divides to integers from 0 to 4 using
lookup tables and times itself...
|
by: my-wings |
last post by:
I've been reading about how evil Lookup fields in tables are, but I've got
to be missing something really basic. I know this subject has been covered
before, because I've just spent an hour or two reading about it on google,
but there is something I still don't understand, and I'm hoping someone will
be willing to explain it to me in small words.
Let's say I have a table for addresses, and it includes a field for state.
What I would...
|
by: google |
last post by:
I have a database with four table. In one of the tables, I use about
five lookup fields to get populate their dropdown list. I have read
that lookup fields are really bad and may cause problems that are hard
to find. The main problem I am having right now is that I have a report
that is sorted by one of these lookup fields and it only displays the
record's ID number. When I add the source table to the query it makes
several records...
|
by: dskillingstad |
last post by:
I've been struggling with this problem for some time and have tried
multiple solutions with no luck.
Let me start with, I'm a novice at Access and I'm not looking for
someones help to design my database,just help in getting me pointed in
the right direction.
I have a database with 8 tables, which from what I have read, cannot be
linked on a single form, and be updatable. I have created a query
which includes all 8 tables, and then...
|
by: henk |
last post by:
Hi,
I have a vb.net application where I need multiple "Lookup windows".
I could make 10 lookup window with each there own datagrid and table
style, but I want to do it Nice.
I was thinking about 1 Lookupwindow with 2 parameters (SQL and the
tablestyle).
The problem is: When calling the lookup window, it works ok. But when
calling another Lookup window the table style won't update. (it still
uses the first one).
| | |
by: DKode |
last post by:
Ok,
My staff has determined that we will be using custom business objects
for a new app we are creating. we have an object that is called
Employee.
The employee object has about 8 lookup tables with a FK in the
employee table and two other tables that will be custom objects
themselves.
|
by: Robert Bravery |
last post by:
Hi all,
I have now correctly set up my dataset and two grids, so that the parent
navigates the child.
THe thing is that the child table is actually a lookup type table. It lists
billing types for the parent table, so that I just store a key in the parent
table, and the show the billing type description from the child
I need to set this up in one grid. I have played arround with the tables and
columns collection in the ID, but cant seem to...
|
by: mkjets |
last post by:
I have worked for hours on trying to find a solution and have not
figured it out. I am working in Access 2003. I need to create a query
that takes values from 1 table and displays them in multiple fields. I
don't have the option of changing the structure of the existing tables
because I am importing them from a separate data source on a regular
basis. I also need to use a query instead of a form because I then
need to be able to export...
|
by: Jerim79 |
last post by:
I am trying to create a search system for an existing database.
Because of the way the database is setup, I need to traverse three
different tables, gathering information:
1) Go into table1 and lookup show_id by show name. (For instance,
let's say I am looking for the Mickey Mouse show. I look it up and
find that it's show_id is 6)
2) Go into table2 and lookup all attendee_ids for show_id 6. (For
instance, I lookup show_id 6 and find...
|
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...
|
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,...
| | |
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...
|
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...
|
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...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
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
| |
