Questions tagged [3-tier]

For issues relating to setting up and utilizing a 3-tier architecture.

3-tier is a software architecture in which the presentation layer, business access layer and data access layer are developed and maintained as independent modules, sometimes on separate platforms.

370 questions
1
vote
1 answer

Removing database dependency from 3 tier architecture

I have worked as part of a team on some 3 tier applications for a considerable amount of time. I like this architecture, but in all of these applications I have noticed a heavy dependency of the topmost two layers on the data abstraction layer. This…
Alex Terreaux
  • 1,881
  • 5
  • 23
  • 39
1
vote
2 answers

vb.net DAL Specify columns returned

I have a Data Access Layer class that has a method (GetPeople) that will retrieve records from a SQL Server table (people). This table has more than 20 fields, including varbinary type. Right now, SQL query is something like SELECT * FROM…
paezinc
  • 339
  • 1
  • 3
  • 13
1
vote
1 answer

Cannot implicitly convert type error

I have subjected error. Why this error is comming, even I used same thing for my other classes. ActCtrl ctrl = new ActCtrl(); Act action = ctrl.GetAct(companyID, actionID); And in Act class. public Act GetAct(string companyID, string actionID) { …
Raja
  • 131
  • 2
  • 16
1
vote
1 answer

Building a c# 3-tier project - database handling issues

I have to create a c# application which I expect it will grow out pretty large so I want to start with a good setup. Because I mostly use PHP and it has been a very long time since I wrote a C# application, I'm having some issues which I cannot get…
randomizer
  • 1,619
  • 3
  • 15
  • 31
1
vote
1 answer

How to Handle caching with 3-tier design pattern in a website

Im developing a asp.net small website and thought about using 3-tier design pattern (Gui, BLL, DAL). My main problem is that i feel bit lost with how should i handle the caching right. 1.First, where should the caching be done? Is it in the GUI…
Popokoko
  • 6,413
  • 16
  • 47
  • 58
1
vote
1 answer

Best practice to connect DAL to UI layer

I've always been told that designing your application using 3 tiers model is the best practice to separate the data layer and the business logic layer from the presentation. But when I come to use modern user interface components (like DevExpress),…
Nour
  • 5,252
  • 3
  • 41
  • 66
1
vote
1 answer

User Profiles in a 3 tiered CouchDB and Laravel app

I'm developing a web application in Laravel 4 that has multiple users, each one with a profile. These profiles may (or may not) have different variables, such as dates, etc. I've looked at some RDBMS solutions for this problem including EAV design,…
1
vote
1 answer

DbSet Object reference not set to an instance of an object

I'm trying to make a universal 3-tier application with generic repositories for any data provider/orm. I just rewrote the code and got stuck on the error of Object reference not set to an instance of an object while trying make action in DbSet. I'm…
1
vote
1 answer

Calling connection string from connection.cs file

Is there any problem with the code?? Its not working and throwing an exception object ref. not set to an instance of object.. The exception is in datageneric.cs file at codeline string DbConnectionString = Connection.ConnectionString; connection.cs …
1
vote
2 answers

OOP Programming with database access

I am working on a project with database access. Here is the outline of the classes i have implemented public class Foo { private String id; private String name; private int x; private String y; private String z; ... …
Jasir
  • 677
  • 1
  • 8
  • 26
1
vote
2 answers

Oracle JDBC Tutorial - Want to understand 2 tier JDBC vs 3 tier

I am reading the oracle JDBC tutorial here - http://docs.oracle.com/javase/tutorial/jdbc/overview/index.html Please refer to Figure 2: Three-tier Architecture for Data Access. It says that - In the three-tier model, commands are sent to a "middle…
david blaine
  • 5,683
  • 12
  • 46
  • 55
1
vote
0 answers

How to call stored procedure dynamically with 3-tier architecture?

Actually I recently made a web application. I have around 20 store procedures [for insert, update and delete] , around 12 store procedures are having different numbers of procedures. I made different functions for every single operation, like see…
Gaurav
  • 557
  • 4
  • 11
  • 28
1
vote
3 answers

Confusion with 3 layer design

I've been reviewing examples on the web of 3 layer design and I've noticed that most samples return either datasets or data tables. The thing that is confusing me is what if you would rather return a generic list of type so you can utlize…
obb-taurus
  • 847
  • 1
  • 7
  • 12
1
vote
2 answers

calculate month different using radMonthYearPicker(telerik)

Exact Duplicate of Calculate month different using radMonthYearPicker I have 2 radMonthYearPicker(1 is for start Date another 1 is for end Date) I want to calculate the month different between this 2 date. for my start Date, I set my month as…
user1861753
  • 91
  • 1
  • 3
  • 11
1
vote
1 answer

Calculate month different using radMonthYearPicker

I have 2 radMonthYearPicker(1 is for start Date another 1 is for end Date) I want to calculate the month different between this 2 date. for my start Date, I set my month as dec and year 2012. for my end Date, I set my month as dec and year 2013 Base…
user1861753
  • 91
  • 1
  • 3
  • 11