Introduction to ASP.NET, ADO.NET – dead ringer for Oracle ADF?

Lucas Jellema 3
0 0
Read Time:8 Minute, 47 Second

After quite a few encounters with .NET in recent years, primarily up against Java/J2EE technology – and some with VB before the release of .NET in 2002 – yesterday I had my first real immersion in .NET technology. Our Knowledge Center (database) Server Development and Programming Languages had organized a session on .NET, to let a group of seasoned Oracle and Java/J2EE developers get a first glimpse of what all the buzz is about.

.NET architecture

Arjaan – one of our Java and .NET developers – gave us an overview of what the .NET framework is about, what the archiecture is and what underlying technologies are. Some of it was very familiar, other bits and pieces rather new. Also see:

The multi-tier model for .NET is of course very similar to the one we know for Java/J2EE. There is the Virtual Machine, CLR for .NET vs. JVM for Java. There is ADO.NET for database connectivity and data services. For HTML based Web Application Development, .NET developers use ASP.NET – very, very similar to JSP with JSF components. For GUI Forms development, there is .NET WindowsForms, very similar to for example Java Swing or Oracle Forms (Client/Server).

The use of WebServices turns out to be far less widespread in .NET than I had thought. There are many services (and a method is already a type of low level service) but not all that many WebServices. Entire .NET WebApplications can be compiled into a single DLL. Interaction between ASP.NET components and ADO.NET based data services are very direct and not at all through WebServices or even EJB like remote invocations. From a performance point of view this makes a lot of sense – the overhead with service invocation and untyped data with serialization/deserialization steps can be huge. It also means that typical .NET WindowsForms applications are not all that much different from for example Java Swing or Oracle Forms applications from an architectural perspective. And most Java/J2EE Web Application with their typical explicit MVC implementations are probably more open, more loosely coupled and better structured tier-wise – as well as often slightly less performant??

We concluded that the multi-language, single platform support in .NET – it has to be Windows platform but the set of potential programming languages includes C#, VB.NET and also C++, Cobol, Pascal, J#, Oberon, Python, JScript, Fortran, Perl, and many more somewhat obscure languages – as opposed to Java’s single language run anywhere theme, is somewhat hype-like. In theory, it sounds good to have so many languages at your disposal but in reality 95% or more of .NET development will use either C# or VB.NET – with no clear winner between these two. Being tied to the Windows platform for runtime deployment is a quite severe limitation that prevents adoption of .NET in some quarters.

ADO.NET, databases and data services

I had heard about ADO.NET but was not very well acquainted with it. Now I can position it against JDBC in combination with an Object Relation Mapping Framework. ADO.NET can communicate with most relational databases, through Database Drivers. Some of the drivers for popular databases are collected in the Microsoft Data Access Components (MDAC)product. Most database vendors not only have their own JDBC driver but nowadays also ship their own ADO.NET driver. Usually the vendor’s driver for a particular database is to be preferred over the Microsoft driver for that database. Microsoft prefers us all to use the SQL Server database with .NET applications, so it will not feel the zeal to produce the best possible driver for competing databases. By the way: the role the SQL Server database plays in the .NET framework does not seem to be any different from the role any other database plays. SQL Server is not necessarily any better for .NET applications, with the possible exception of the integration in the Visual Studio 2005 IDE.

The DataSet constructs in ADO.NET is very much like a ViewObject in Oracle’s ADF Business Components for example. The DataSet Reader looks very much like a read only ViewObject. There are many parallels to be drawn between ADO.NET and for example ADF Business Components. However, we did a workshop using (the free) Visual Web Developer 2005 Express Edition and it was my impression that ADF Business Components and its wizards and generators are more database savvy than the comparable tools in Visal Web Developer 2005. For example I had to type full queries and column names rather than simply select columns and have the tool create joins and select statements.

Arjaan explained that it is considered good practice to not have the ASP.NET application access the DataSet directly – which would be a lot like including JDBC calls or even SQL statements in JSP which we tend to avoid. Instead, a .NET application should have a DAO like service object that decouples data operations from the underlying table definitions. On top of the DAOs, there could very well be a Business Service like object – Facade like – that provides more coarse grained services that may involve several DAOs and indirectly DataSets.

We did a workshop in which we created a DataSet on top of a table in a SQLServer Express database. On top of the DataSet, we created a DAO and on top of that also a Service Class. We made use of C# as it was portrayed as being close to Java, with which most of us are more familiar. To say it is close to Java is almost an understatement. We wrote code that could have been Java – apart from the using keyword that replaces the import we know in Java and the apparent convention of starting method names with a Capital (perhaps that was just this workshop though). It is very, very similar!

Developing a web application using ASP.NET

The workshop continued with building a simple Web (HTML) Application on top of the Data Service. Our page would use a DataGrid – a multi-record table with single-record update/delete functionality as well as paging and sorting support. Very similar at first glance to the ADF DataTable on top of an ADF BC Data Control. And that similarity is not just superficial: it extends right to the property level and the IDE look and feel.

This was my first dive into the world of Visual Studio 2005 – that wonder of IDEs. To be frank, I was a bit disappointed. Do not get me wrong, it is a fine IDE. But it does not outrank IDEs like Eclipse (with a bunch of plugins) or JDeveloper (out of the box). In fact, I think from this brief first impression that JDeveloper 10.1.3 is a more powerful IDE, but that can be a matter of taste and personal experience. Visual Studio did not offer me features or tricks that were entirely new or quite surreal. A lot of drag and drop, a lot of property palettes and context sensitive popup menus. IntelliSense in XML and ASP documents – the same as the Code Completion I know from for example JDeveloper 10.1.3 in HTML, XML, JSP, JSF, UIX and even CSS files. Useful, but nothing new.

An ASP.NET page definition looks an awful lot like a JSP page, especially a JSP page with custom tags such has the ones used with JSF components. It is a bunch of HTML with specials tags that are interpreted at runtime. We can drag and drop components from Component Palettes. There are Data, Validation, HTML, etc. palettes that each present a different category of components. We dragged a Data Grid, connected it to a DataSource – at first a SQLDataSource, a direct reference to the DataSet we created earlier and later an ObjectDataSource that connect to the DataService wrapping the DAO wrapping the DataSet that we created later. Again very much like DataBinding in ADF, where we can base a DataTable on a DataControl’s iterator – in an even easier way. I was surprised to find a lot of the DataSource configuration stuff in the ASP.NET file. It is easy to find but not as easy to maintain and configure it would seem. Well, time and experience will tell.

Events like button and hyperlink clicking or data entry can very easily be linked to methods in a class behind the ASP page – like a Backing Bean in ADF JSF terms or the DataAction in ADF Struts/JSP. Adding validation or derivations in this way is very simple.

Interesting was the notion of MasterPages, a sort of built-in Tiles or SiteMesh functionality. Well, almost – as the reference to the MasterPage resides in the child pages rather than the other way round. MasterPages can be used to provide common page elements such as headers and footers and navigation bars, much like UIX templates did and somewhat more advanced than included JSP resources can do.


We managed to develop a simple web-application with a number of interesting features – database driven, data grid with sort, pagination and even filtering – rather quickly. Compared to traditional Java/J2EE Web Development – ORM, Struts and JSP based with poor IDE support – this is very productive. Compared with modern Java/J2EE Web Development, based on JSF, a data binding framework and done using modern IDEs like JDeveloper 10.1.3, it is still okay but nothing spectacular. I would expect us to be more productive using ADF Faces on top of ADF Binding and ADF Business Components than anyone doing Data Driven WebApp development using Visual Studio 2005, ASP.NET and ADO.NET, though the difference probably would not be very large and might depend on the particular components required for specific UI requirements.

It was very interesting to finally meet up with .NET. Some of the mystery is gone. Most of the aversion as well. The .NET framework and associated technologies are uncannily similar to their Java/J2EE counterparts. Both technologies evolve in productive mutual inspiration: no useful feature in either of the two stacks will be absent from the other stack for very long. A developer well versed in the combination Visual Studio, ADO.NET and ASP.NET can very quickly – some weeks or even days – be productive in a Java development stack such as Oracle ADF. And the reverse is true as well.

I expect we will get to .NET even better in the near future. To compete against it, integrate with it and even sometimes use it ourselves.

About Post Author

Lucas Jellema

Lucas Jellema, active in IT (and with Oracle) since 1994. Oracle ACE Director and Oracle Developer Champion. Solution architect and developer on diverse areas including SQL, JavaScript, Kubernetes & Docker, Machine Learning, Java, SOA and microservices, events in various shapes and forms and many other things. Author of the Oracle Press book Oracle SOA Suite 12c Handbook. Frequent presenter on user groups and community events and conferences such as JavaOne, Oracle Code, CodeOne, NLJUG JFall and Oracle OpenWorld.
0 %
0 %
0 %
0 %
0 %
0 %

Average Rating

5 Star
4 Star
3 Star
2 Star
1 Star

3 thoughts on “Introduction to ASP.NET, ADO.NET – dead ringer for Oracle ADF?

  1. I forgot to mention the Mono project: “Mono provides the necessary software to develop and run .NET client and server applications on Linux, Solaris, Mac OS X, Windows, and Unix. Sponsored by Novell (, the Mono open source project has an active and enthusiastic contributing community and is positioned to become the leading choice for development of Linux applications.”

    An Open Source project that provides the .NET runtime environment for platforms other than Windows. That sounds interesting, does it not? See

    The Mono Project is an open development initiative sponsored by Novell to develop an open source, UNIX version of the Microsoft .NET development platform. Its objective is to enable UNIX developers to build and deploy cross-platform .NET Applications.

    Mono contains a number of components useful for building new software:

    * A Common Language Infrastructure (CLI) virtual machine that contains a class loader, Just-in-time compiler, and a garbage collecting runtime.

    * A class library that can work with any language which works on the CLR. Both .NET compatible class libraries as well as Mono-provided class libraries are included.

    * A compiler for the C# language. In the future we might work on other compilers that target the Common Language Runtime.

  2. Lucas gave a very good overview of my presentation and workshop.

    If you want to get started yourself start with downloading Visual Studio Express
    it is free, contains a lot of tutorials and gives you a good impression of the possibilities

    I’ve collected some usefull links on

    In reaction to Lucas conception that .Net applications are webservices everywhere: Yes, you can, but i would not to advise to do so. Why losely couple components just because they are different layers in your design?

  3. A very interesting article on the main functionalities of .NET. I certainly like the way
    you compared each individual .NET aspect to the Oracle ADF and JDeveloper

    I have spent time looking for the main differences and advantages between .NET
    and the ADF Framework on the net, but with no clear views.

    I hope there will be more to come on this topic.

    Thank you for this,


Comments are closed.

Next Post

Profiling PL/SQL met het package dbms_profiler (dutch)

Oracle biedt sinds Oracle 8i via het package DBMS_PROFILER ondersteuning voor profiling. In dit artikel, dat ook in Optimise zal verschijnen, zal dit package onder de loep genomen worden en zal het pldbg package geoptimaliseerd worden waarbij het gebruik van dynamisch PL/SQL wordt verbeterd en conditionele compilatie wordt gebruikt om […]
%d bloggers like this: