ISYS 512 Business Application Design and Development with .Net - PowerPoint PPT Presentation

Isys 512 business application design and development with net l.jpg
Download
1 / 19

ISYS 512 Business Application Design and Development with .Net. David Chao. Business Applications. 1. Database-centric applications Personal: desktop, PDA/Smart Phone Workgroup / Departmental databases Enterprise database Enterprise Resource Planning (ERP)

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.

Download Presentation

ISYS 512 Business Application Design and Development with .Net

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Isys 512 business application design and development with net l.jpg

ISYS 512Business Application Design and Developmentwith .Net

David Chao


Business applications l.jpg

Business Applications

  • 1. Database-centric applications

    • Personal: desktop, PDA/Smart Phone

    • Workgroup/Departmental databases

    • Enterprise database

      • Enterprise Resource Planning (ERP)

        • Integrate all enterprise functions (manufacturing, finance, sales, marketing, inventory, accounting, human resources)

    • TPS, DSS, ESS


Business applications3 l.jpg

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


Business applications4 l.jpg

Business Applications

  • 3. Multiple platforms

    • Windows-based

    • Web-based

    • Mobile-based


Business applications5 l.jpg

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.


N tier client server structure l.jpg

N-Tier Client/Server Structure

  • Two-Tier

    • Client-based presentation.

    • Processing logic is buried either inside the user interface on the client or within the database on the server, or both.

  • Three-Tier

    • Processing logic is separated from the interface and database.

  • N-Tier:

    • Using services


  • The web as a database application platform l.jpg

    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


    Business applications8 l.jpg

    Business Applications

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


    Course objective l.jpg

    Course Objective

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


    Net architecture l.jpg

    .Net Architecture

    VB.Net

    C#/J#

    C++

    Common Language Specification

    ASP.Net

    Windows Forms

    Data and XML

    Base Class Library

    Common Language Runtime


    Slide11 l.jpg

    • 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.


    Execution of a net program l.jpg

    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.


    Net advantages l.jpg

    .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


    Programming in the net framework l.jpg

    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.


    Hands on techniques l.jpg

    Hands On Techniques

    • Visual Basic .NET

      • 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:

        • Introduction to XML


    Required software l.jpg

    Required Software

    • Visual Studio 2008

      • It has a web server to test web projects.

    • MS SQL Server 2008 Express

    • Windows XP Professional with Service Pack 2

    • Optional:

      • Internet Information Services:

        • Control Panel

        • Add/Remove programs/Windows Components/IIS


    Vs 2008 professional l.jpg

    VS 2008 Professional

    • Copy VS 2008 Professional at the BUS Computer Lab and install it.

    • Upgrade it to SP1:

      • Download and install VS 2008 SP 1

      • http://msdn.microsoft.com/en-us/vstudio/cc533448.aspx


    Download and install ms sql server express 2008 l.jpg

    Download and Install MS SQL Server Express 2008

    • Download page:

      • http://www.microsoft.com/downloads/details.aspx?FamilyID=58ce885d-508b-45c8-9fd3-118edd8e6fff&DisplayLang=en#Overview

    • SQL Server Book Online:

      • http://msdn.microsoft.com/en-us/library/ms130214.aspx

    • SQL Server database file extension: mdf

    • Default database folder: Example: testSQL08.mdf

      • C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\testSQL08.mdf


    To start end sql server l.jpg

    To Start/End SQL Server

    • SQL Server Express is a “service”

    • To start SQL Server service:

      • Control Panel/Administrative Tools/Services/SQL Server Express


  • Login