Generating CRUD - PowerPoint PPT Presentation

1 / 7
About This Presentation
Title:

Generating CRUD

Description:

Generating CRUD. Mark Jarzebowski. bms_at_bms.com.au. www.bms.com.au. Business Model Systems (Victoria) Pty Ltd. What is CRUD. CReate Update Delete from Database ... – PowerPoint PPT presentation

Number of Views:1667
Avg rating:3.0/5.0
Slides: 8
Provided by: Ma123
Category:
Tags: crud | crud | generating

less

Transcript and Presenter's Notes

Title: Generating CRUD


1
Generating CRUD
  • Mark Jarzebowski
  • bms_at_bms.com.au
  • www.bms.com.au

Business Model Systems (Victoria) Pty Ltd
2
What is CRUD
  • CReate Update Delete from Database
  • We have to do this in all Business Apps
  • After 10 years of Visual Studio we still dont
    have good tools for this
  • Data Tier Generator

3
Best Practice for small apps
  • Data Layer
  • bmsDB.dll
  • Direct database access for 1 to 100 users
  • Greg Hudson has 3000 users of Access database
  • Use embedded SQL
  • Move data as string arrays
  • Light and fast
  • Tried and proven in DAO, ADO, ADO.NET

4
Best Practice for large apps
  • Large app 100s to 1000s of users
  • Use SQL Server
  • Scalable, reliable
  • Easy to use
  • Use middle tier business objects
  • User interface independence
  • Data independence
  • Use parameterized stored procedures
  • Optimized for data access (no longer
    pre-compiled)
  • More secure than embedded SQL

5
Large App Design
6
Solution
  • A lot of work to move the data around
  • Data Tier Generator
  • Should be part of Visual Studio

7
Code
  • Original Data Tier Generator
  • http//sourceforge.net/projects/csharpdatatier/
  • SQL 2000, .NET 1.1
  • Enhanced version
  • www.bms.com.au
  • SQL 2005, .NET 2.0
  • Field selection
  • Save specs
Write a Comment
User Comments (0)
About PowerShow.com