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