tags:

views:

160

answers:

1
Q: 

3 tier with ASP.NET, C# and Oracle 11g

Hi

I am new to .NET, want to follow N-tier approach using Visual Studio 2010(ASP.NET MVC + C#),IIS and Oracle 11g(installed on the remote linux machine). I need to have Presentation, Business Logic, Data Access and Data Tiers. Can anyone give me site/example application with the following fuctionality: insert, retrieve, delete and update/modify data in the database. A step by step guide will be highly appreciated.

Thank you in advance

A: 

Take a look as ASP.net MVC:

http://www.asp.net/mVC/

Lots of good video tutorials:

http://www.asp.net/Learn/data-access/

Shane Cusson  2010-04-18 14:30:29
Thank you ShaneI tried http://www.asp.net/Learn/data-access/ and it gives gentle theory and practicals. But the database used is MSSQL not Oracle. Is the concerpt the same - both in Oracle and MSSQL Server?
ephraim  2010-04-18 19:45:06
There are differences in syntax between Oracle and SQL server. You could use the Entity Framework as an ORM. You'd write your queries as LINQ.Entity Framework http://msdn.microsoft.com/en-us/data/aa937723.aspxOracle's .net Site: http://www.oracle.com/technology/tech/dotnet/index.html
Shane Cusson  2010-04-26 22:51:27

related questions

What should be the responsibility of a presenter here?
Need some clarification on the ANSI/SPARC 3-tier database architecture.
How and where to handle exceptions in a 3-tier web application? Specifically Sql Database Exceptions
n-tier architecture: best place to store business objects?
Service layer is a outer layer or not? If not then it come under which layer?
Best Approach to handle Data Concurrency In 3-Tier Application
MVC - is it just a 3 tier model?
Sample J2EE projects using J2EE design patterns
Business layer, data layer, where to put queries?
How-To Deal with Multi-Criteria Queries in 3-Tier Architecture
Implementing Business Logic in 3 Tier Architecture
How to improve speed of 3-tier application?
using JDBC Connection from presentation tier in 2-tier and 3-tier applications
About 3-tier architecture and symfony framework
How do I reach the middle tier using the memship class?
I need some clarification on the MVC architecture and the three-tier architecture...
Presentation layer referencing data layer
Returning data from the business layer to the presentation layer
BLL errors best practise
LINQ with 3 Tier
3-tiers pattern and large amounts of data
Three-Tier architecture and LINQ to Entities
Need help in login authentication using asp.net
Databinding ASP.net DropDownList with Entity Framework
How many of you do 3-tier design?