SimpleSQL Simple SQL User Manual

SimpleSQL%20User%20Manual

SimpleSQL%20User%20Manual

SimpleSQL%20User%20Manual

SimpleSQL%20User%20Manual

User Manual:

Open the PDF directly: View PDF .
Page Count: 66

Scroll down to view the document on your mobile browser.

SimpleSQL
Table of Contents
1. Overview
2. Workflow
3. Setting Up Your Project
4. Creating a Database
5. Creating a Database Manager
6. Data Structure
- 6.1 Using .NET's System.Data
- 6.2 Using the ORM
  - Sample Classes
    - Attributes
7. Queries
- 7.1 Query Examples
- 7.2 System.Data Query Examples
  - Retrieve data from a table and store in a DataTable
8. Inserting Records
- 8.1 Insert Record Examples
  - Insert with SQL Statement
  - Insert with Class Definition
9. Updating Records
- 9.1 Update Record Examples
  - Update with SQL Statement
  - Update with Class Definition
10. Deleting Records
- 10.1 Delete Record Examples
  - Delete With SQL Statement
  - Delete With Class Definition
11. Transactions
- 11.1 Transaction Examples
  - Transactions with SQL Statements
  - Transactions With Class Definitions
12. Creating, Altering, and Dropping Tables
13. Upgrading Databases
14. Options and Optimization
- 14.1 Optimize Platform
- 14.2 Optimize Data Library
15. FAQ and Troubleshooting
- 15.1 Questions / Errors
- 15.2 Answers / Resolutions
16. Revisions

Navigation menu