N Tier - How Should Lookup Values Be Represented In Business Objects
Mar 25, 2011
I'm currently writing an N-Tier architected ASP.NET system with a relatively normalised SQL database backend, but I'm struggling to get my head around how lookup values should be represented in my business objects (I don't get the priviledge of using EF or ORMs). My table (as an example) could be structured like this:
CoreDataTable:
ID | Name | Favourite_Colour
---|-------|-----------------
01 | Peter | 01
02 | John | 03
03 | Mary | 05
ColoursLookup:
ID | Colour | is_active
---|--------|----------
01 | Red | 1
02 | Green | 1
03 | Blue | 1
04 | Pink | 1
05 | Black | 1
Now initially, I had created my business object to look like this:
[code]....
I'm 100% convinced that I'm (a) overthinking this, and (b) making it more complicated than it needs to be. So, is there a preferred way of doing this? Or is there an option that I've overlooked?
View 2 Replies
Similar Messages:
Jan 27, 2011
I am implementing 3-tier architecture. I just wanted to know the role of business layer in 3-tier architecture.
I am developing application in using entity framework. So I have entity object which is accessiable in PL,BL & DL. My question is whether input assignment to entity object should be in PL OR BL.(Consider there is save method)
View 2 Replies
Feb 24, 2010
I'm working on a project in which we have a database, data layer (entity framework), business layer and web/UI layer.I want to use ASP.NET Dynamic Data for the web layer, but don't want it to access the data layer or database, as I want it to be purely running off business logic, and not directly accessing the data.However, it appears that Dynamic Data only allows Linq-to-SQL or entity framework data sources to be used.Has anyone used it with business-layer objects instead?
View 1 Replies
Aug 25, 2010
is there any impact of using static methods in Business Access layer in 3 tier applciation,
View 4 Replies
Mar 20, 2010
designing Business Objects. What a business object class can contain ?
I have looked many sample codes and articles. Some only use properties in them. Some use private members, properties and constructoers. As more I am reading becoming more confuse.
Some sample codes that I checked were making functions in BO classes as well. what a BO class should contain and what is its purpose. Should there be functions in them as well ? If yes how they can be differentiated from Business Logic class functions.
View 5 Replies
Feb 23, 2010
I am new to OOP. Kindly guide me why making business objects is good ? how and what benefit they bring in development. As I am new to OOP if please you decidable with example in simple way will be great help to me.
View 3 Replies
Feb 2, 2010
We are using below class(TypeInterceptor) in one of our project to create the instance of business objects.
To Create any business object, we are using the below code
++++++++++
BLayer.TestBO objTestBO;
this.objTestBO = TypeInterceptor.CreateObject<BLayer.TestBO>();
+++++++++++
I think using this kind of creational pattern makes the application not scalable as the same instance will be shared among all the concurrent users.Is it correct?
Is there any better way to abstract the creation and maintaining instance of business objects
Class code:namespace Microsoft.IT.RelationshipManagement.Internal.CISF.Infrastructure
{
using System;
using System.Linq;
using System.Text;[code].....
View 5 Replies
May 12, 2010
Unit Testing for Business Object
View 2 Replies
Sep 2, 2010
As I began writing web applications with asp.net I started with small projects that used a Linq-To-SQL mapper for database access to a MSSQL Server. After gaining some expierence I switched into a classic 3 tier with Graphic Layer, Business Layer, Data Layer. The only function of the Data Layer was to provide methods insert/update/delete without any logic and logic the form of selection methods.
Over the time I realized that it would be better not to provide the database classes up to the GUI (took some time unfortunately). I switched into using Business classes in the BL that are used for all operations performed by the BL and display by the GUI in the form of getting List from the BL. A great advantage is that I can provide additional properties that are not represented by the database itself. However, I did that mapping inside the BL myself with methods that mapped the corresponding BL class to the database class.
I guess thats where O/R mapper come in handy? Until now I haven't realized their purpose, but I think I just found it. I've recently tried out using the new Entity Framework with .net framework 4, but I'm only using it like the Linq-To-SQL DataContext.
Is there a way to achieve the mapping automatically? If yes, is that something the new Entity Framework provides or do I need to look for a O/R Mapper like NHibernate?
View 4 Replies
Feb 5, 2010
I have two business objects mapped via LINQ to tables. One of the objects contains an instance of the other object and share a key as an identifier.I want to retrieve Class A and within class A all of Class B's values as well. What I am doing is this:
[Code]....
[Code]....
This seems a little clunky, as in slow. Is there a better way to get the Class B (User) information without making a query every time?
View 4 Replies
Jun 22, 2010
If I do thisPublic PageDetail As CoreBO.GetStartUpDetails = PageCoreBLL.InitialSetup(DomainName)
[Code]....
Where GetStartUpDetails is a structure in the Business Objects Layer In my page subs is their a performance differance between writing
sub xx
Dim test as pagedetails.structure1
response.write (test)
end sub
or just response.write (pagedetails.structure1)
View 1 Replies
Apr 14, 2010
UI markup to create the table shown below, which I have mocked up quickly to visualise what I need to do. The data is in the form of custom objects; a SelectedSession object which has a List (Of Students) sorted by AcademicYear, TeachingSet, then name.
So the question is how do I create that table from my custom object?
<table class="style1">
<tr class="academicYear">
<td colspan="3">
[Code]....
View 4 Replies
Mar 26, 2010
I created a class library: PRTreatmentReviews. I created a reference for the class library on the website. I checked the property pages and the reference to the class is there. I put objectdatasource on a page and tried to pick up the PRTreatmentReviews class but it's not there? The Class
[Code]....
View 13 Replies
Oct 20, 2010
In a webform, I have a formview with respective InsertItemTemplate. I have 2 Look Up buttons, one for Student which opens Student LookUp, and one for Mentor which opens the Mentor Look Up.
First on the input screen sequence is allowing the user to choose Student first. User clicks the Student LookUp button, The StudentLookUp Window is shown, user selects a student, the selected student information is returned and displayed on the calling screen.
The user then clicks on the Mentor LookUp button. The Mentor LookUp window is shown. As this is happening, the values for the Student information, which I have populated upon selecting a student from the Student LookUp goes blank. Can anyone tell me why?
[code]....
View 2 Replies
May 15, 2010
I have a database table with three columns of interest
slottypekey (integer)
taskkey (integer)
permission (string)
Lets's say I have a stored procedure that gets this data and puts it into a dataset.
I would like to write a function that has input parameters of slottypekey and taskkey
and that returns the associated permission. What is the best way to do this?
View 4 Replies
Feb 25, 2011
We have a wfc layer that wraps the business classes and database access and use a client that lives on the database layer. Amongst our group we are attempting to form standards. Some want to have the client call the web method and pass the page they are requesting and the page size. Pass that to the database and then page in SQL Server use RowNum.Some want to cache the full list of objects in http cache on the service tier and page in memory. They concern here is memory use on the server.
Which would be best for a medium number of users with potentially large number of records to manage (say 30K) Is it better to cache them all in memory and work from there or page at the database as the application scales?
View 1 Replies
Jan 26, 2011
I have a GridView control that has a SQLDataSource.
The GridView provides me with a list of musical artists (from the tblArtists)
In the Grid, I have a field, FKGenreID, that is a Foreign Key value for music Genres.
(An example of the data in that field would be "7", which upon lookup would mean Classical in the
tblGenreList table.)
What I'd like to do is add a DropDownList control that looks up the tblGenreList table and populates the DropDownList with the ID and Description from the tblGenreList Lookup table.
Now the tricky part is that if the GridView field (FKGenreID) has a value, then I'd like the corresponding Genre Description to be displayed in the DropDownList
Alternately, if there is no value for FKGenreID in the GridView, then I'd like the DropDownList to show that nothing was selected, but have the list of Genres available.
Most importantly here, when the user makes a selection, I'd like the GenreID (from the DropDownList) to be entered into the FKGenreID field in the GridView field.
My thought is that a gridview record may or may not have a value in the FKGenreID field. Either way, the DropDownList is bound to that field. The DropDownList would display a list ofGenre Descriptions for the user to select from. Upon selection, the GenreID column of the DropDownList becomes the value in for the FKGenreID field in the GridView.
Is this possible?
In case it matters, I'm using ASP.NET 4, Visual Studio 2010, and coding in VB
View 1 Replies
Jun 26, 2010
The method has a return type of collection, i am calling the method from the aspx page in order to populate a drop down -> ddlDropDown. I am binding he DataTextField of the ddlDropDown with the BusinessEntity.Name and the DataValueField with BusinessEntity.Id, the business entity contains another id which is BusinessEntity.ProductId. I need to use the ProductId of the value selected in the drop down list in the code behind.
One possible way could be to call the method in the page_Load on the code behind and save the collection in a hidden variable and when required do a loop through in the hidden variable and retrieve the selected value Product Id.
View 1 Replies
Apr 19, 2010
I'm trying to run a SSIS package but getting this error with my script component:
The DateTime represented by the string is not supported in calendar System.Globalization.GregorianCalendar.
Here's what I have in the design script. Does anyone know why I'm getting this and what I need to change it to?
[Code]....
View 2 Replies
Aug 23, 2010
I have to pass the session value to a business logic layer, I can pass it to the function from presentation layer but how can I access it directly in my business logic layer ? Also is it a good approach to pass it directly to business logic layer like
GetMyRecords(Count,Session["userID"].toString()); ?
View 2 Replies
Jun 26, 2010
The method has a return type of collection<businessEntity>, i am calling the method from the aspx page in order to populate a drop down -> ddlDropDown. I am binding he DataTextField of the ddlDropDown with the BusinessEntity.Name and the DataValueField with BusinessEntity.Id, the business entity contains another id which is BusinessEntity.ProductId. I need to use the ProductId of the value selected in the drop down list in the code behind.
One possible way could be to call the method in the page_Load on the code behind and save the collection in a hidden variable and when required do a loop through in the hidden variable and retrieve the selected value Product Id.
View 1 Replies
Mar 8, 2011
At the moment I pass values from one page to another. I need to pass objects between pages, how can I do this.
View 3 Replies
Jan 27, 2010
I have 2 Linq to Entity queries, here they are:
[Code]....
In "query" there are several columns, 2 of them are NIIN and Qty. In "objViewDDRT" there are only 2 columns, they are NIIN and AvailBalance.
What I need to do is for each row in "query" check to see if the NIIN is in "objViewDDRT", and if it is get the AvailBalance for that NIIN from objViewDDRT.
View 3 Replies
Oct 26, 2010
I am new to this .NET what is the difference between N-Tier and 3- Tier Architecture. If they are same. How to pass the values from presentation layer to business logic layer.
For Example
I have 10 controls in presentation layer. I passing values to these controls. How the architecture works.
View 3 Replies
Nov 17, 2010
have some Objects, lets say Employee and Role defined as below and I have defined relationships in my database that gives me a list of objects say employees and thanks to my framework each employee object also has a Role object linked via the RoleIDID, UserName, Password, Email, RoleIDRoleID, RoleNameSo in code I can do something like this
Employee emp = dataService_GetEmployeeByID(1);
string RoleName = emp.Role.RoleName;
Now here is my problemI can bind any object in a repeater and it works fine for the first level in my relationship
For instance <%# Eval("UserName") %>
But I need to be able to show the details for my child objects as well (Role) so something like this (which does not work)
<%# Eval("Role.RoleName") %>
View 2 Replies
