ISYS 512 Business Application Design and Development with .Net

1
ISYS 512Business Application Design and
Development with .Net

• David Chao

2
Business Applications

• 1. Database-centric applications
• Transaction Processing Systems, TPS
• Transaction support database
• Internal, detailed and historical data
• Decision Support Systems, DSS
• Decision support database
• Data warehouse

3
Business Applications

• 2. Client/Server structure
• a. Presentation user interface
• Menus, forms, reports, etc
• b. Processing logic
• Business rules
• c. Database

SQL queries
Client
Database Server
Results
4
Business Applications

• 3. Multiple platforms
• Windows-based
• Web-based
• Mobile-based

5
Business Applications

• 4. Component and service oriented architecture
• Component-based software development focuses on
  building large software systems by integrating
  previously-existing software components.
• A service-oriented architecture is an information
  technology approach or strategy in which
  applications make use of services available in a
  network such as the World Wide Web.

6
N-Tier Client/Server Structure

• Three-Tier
• Client-based presentation
• Processing logic
• Database.
• N-Tier
• Using services
• Fat client/Thin client

7
The Web as a Database Application Platform

• Three-tier architecture
• Browser - interface
• Server
• web server, database server
• processing logic
• Advantages
• Cross-platform support
• Graphical user interface

8
Business Applications

• 5. Object-oriented, GUI, event-driven

9
Course Objective

• Develop database-centric, multiple platforms,
  component and service oriented business
  applications with .Net.

10
.Net Architecture
VB.Net
C/J
C
Common Language Specification
ASP.Net
Windows Forms
Data and XML
Base Class Library
Common Language Runtime
11

• Common Language Runtime
• Manages execution of compiled .NET program.
• Provides .Net basic services, such as memory
  management, garbage collection, etc.
• Base Class library define all the basic data
  types such as system.object, numeric, date, etc.
• Data and XML Classes work with database
  (ADO.NET) and XML document.
• ASP.Net and Forms Classes that generate user
  interface.
• CLS CLS dictates the minimum group of features
  that a .Net language must have.

12
Execution of a .Net Program

• Language must compliance with Common Language
  Specification, CLS.
• Compile the language into Microsoft Intermediate
  Language (MSIL) code.
• The MSIL code is then executed in the Common
  Language Runtime (CLR), which conceptually is
  same as the Java Virtual Machine, where it is
  translated into machine code by a compiler.
• It is a server-side technology.

13
.Net Advantages

• It is independence from a specific language.
• Developers can create a .Net application in any
  .Net compatible language.
• .Net moves most of the functionality from the
  language to the .Net Framework. All .Net
  languages can use these classes.
• It can exist on multiple platforms
• Windows, Web, Mobile devices
• Facilitate application development
• Tools, wizards
• Universal data access Data can be accessed by
  any Internet-connected device.
• ADO.Net
• Implement latest development technologies.
• Ex. AJAX, web service

14
Programming in the .Net Framework

• Programming in the .Net Framework means making
  use of the classes, objects, and members exposed
  by the Framework, building your own classes on
  top of these and manipulating the resulting
  objects using a .Net language.

15
Hands On Techniques

• VB.NET, C
• Interface and event-driven programming
• Class and component programming
• Database programming
• Embedded SQL
• ADO.NET programming model
• LINQ
• Web Techniques
• Server side scripting ASP.NET
• ASP.Net and ADO.Net
• Web services

16
Required Software

• Visual Studio 2010 Professional
• It has a web server to test web projects.
• Access/MS SQL Server 2008 Express (installed with
  VS 2010)
• Operating Systems
• Windows XP (x86) with Service Pack 3 - all
  editions except Starter Edition
• Windows Vista (x86 x64) with Service Pack 2 -
  all editions except Starter Edition
• Windows 7 (x86 x64)

17
Download and Install VS 2010 Professional

• Microsoft DreamSpark website
• https//www.dreamspark.com/
• VS 2010 Service Pack 1
• http//www.microsoft.com/download/en/details.aspx?
  id23691

18
To Start/End SQL Server

• SQL Server Express is a service
• To start SQL Server service
• Control Panel/Administrative Tools/Services/SQL
  Server Express