Improving Performance and Security in .NET Applications with Static SQL

With the IBM^® Database Add-Ins for Visual Studio and IBM Data Studio pureQuery Runtime, you can run SQL in your .NET applications statically. Static SQL avoids the need to prepare certain statements at run time, and can lead to improved security and performance in your applications.

This section provides conceptual information and instructions for using static SQL in your .NET applications.

In this section:

Using Static SQL in .NET Applications: Information about using static SQL in .NET applications and a summary of the steps for using static SQL.
Selecting Data Connections for Capturing SQL Statements: Instructions for specifying the data connection information that is necessary to capture SQL statements in .NET applications.
Capturing SQL Statements in .NET Applications: Instructions for capturing SQL statements in .NET applications.
Reviewing Captured SQL Statements: Instructions for examining the contents of captured SQL files.
Binding Captured SQL Statements in Packages: Instructions for binding captured SQL statements to databases so that you can run the SQL statically.
Running .NET Applications with Static SQL: Instructions for statically running SQL statements in .NET applications.

Improving Performance and Security in .NET Applications with Static SQL (DB2)

In this section: