Writing Applications

1
Writing Applications
with a

• Managed Code Database for .NET

Jens Ole Lauridsen
2
.NET Application Choices

• Language Delphi, Visual Basic, C, Java
• Application Type Web, Console, VCL, Windows Form
• Database API ADO.NET, BDP
• Database Configuration Server, In-Process
• SQL Embedded, Isolated in Stored Procedures

3
Database Configuration

• Server
• Multiple Processes
• TCP-IP Connection
• Simple or Service Install
• Stored Procs in DLL

• In-Process
• Single App Process
• Improved Performance
• Direct Call
• Simple Installation
• Stored Procs in Application

4
SQL

• Embedded
• Less Indirection
• Better Performance?
• - for simple queries

• In Stored Procedures
• Schema Details hidden
• Schema Changes Isolation
• Controlled Access Privileges
• Better Performance?
• - for advanced SQL on Server

5
1st Demonstration

• Delphi .NET Windows Form
• In-Process use of DataStore.NET
• BDP
• DataGrid and BdpDataAdapter
• Data Explorer

6
2nd Demonstration

• Delphi .NET Windows Form
• In-Process use of DataStore.NET
• ADO.NET for DataStore.NET
• SQL Embedded in Stored Procedures
• Stored Procedures written in Delphi
• Parameters Input, Output, Null Values
• Triggers written in Delphi

7
3rd Demonstration

• Delphi .NET Windows Form
• Out of Process use of DataStore.NET
• ADO.NET for DataStore.NET
• Stored Procedures in a Separate DLL

8
4th Demonstration

• C Smart Device Application
• Deployed on a Pocket PC
• Application ported to C
• Triggers in C
• Remote Debugging of Pocket PC
• File Format is Identical

9
End of Slides