SQL Language Reference
SQL Data Types	Data Definition Statements
DUAL Table	Data Manipulation Statements
Access Control Statements	SQL/PSM Statements
Session & Transaction Statements	Miscellaneous SQL Statements
SQL Built-In Functions
Built-In Roles	INFORMATION SCHEMA
Standard SQL Language Features	Size Limits

ADO.NET Provider
EfzConnection	EfzCommand	EfzTransaction
EfzConnectionStringBuilder	EfzDataAdapter	EfzDataReader
EfzException	EfzFactory	EfzLob
EfzParameter	EfzParameterCollection	MonthSpan
EfzMetaDataCollectionNames	Connection String Parts

Silverlight ADO.NET Style Provider
EfzConnection	EfzCommand	EfzTransaction
EfzException	EfzLob	EfzDataReader
EfzParameter	EfzParameterCollection	MonthSpan
Connection String Parts	CommandBehavior	CommandType
ConnectionState	IsolationLevel	ParameterDirection

ADO.NET Code Samples
ADO.NET Sample 1: Create a memory Database. Insert rows into a table and fetch rows via DbDataReader
ADO.NET Sample 2: Create a file based Database. Insert rows into a table and fetch rows via DbDataReader
ADO.NET Sample 3: How to use named parameters with ADO.NET provider
ADO.NET Sample 4: Read Committed transaction isolation level in EffiProz database
ADO.NET Sample 5: Repeatable Read transaction isolation level in EffiProz database
ADO.NET Sample 6: Read-only transactions in EffiProz database
ADO.NET Sample 7: Transaction Savepoints
ADO.NET Sample 8: How-to fetch identity (auto-increment) column values via DbDataReader
ADO.NET Sample 9: Delete rows with DbDataAdaptor
ADO.NET Sample 10: Insert rows with DbDataAdaptor
ADO.NET Sample 11: How two EffiProz databases can participate in a distributed transaction. Also demonstrate use of EfzFactory and EfzConnectionStringBuilder.
ADO.NET Sample 12: How-to use EffiProz database connection pooling and ClearAllPools functionality.
ADO.NET Sample 13: Execute SQL stored procedure.
ADO.NET Sample 14: Execute SQL function using DUAL table.
ADO.NET Sample 15: Execute SQL function using DUAL table. Fetch result using a ReturnValue parameter.
ADO.NET Sample 16: Execute SQL stored procedure with OUT parameter
ADO.NET Sample 17: Execute SQL stored procedure with INOUT parameter
How-to use CLR stored functions
Calling SQL statements from CLR stored procedures
ADO.NET Sample 18: Fetch BLOB column as a byte array
ADO.NET Sample 19: Update BLOB value via EfzLob stream
ADO.NET Sample 20: Fetch CLOB column as a char array
ADO.NET Sample 21: Update CLOB value via EfzLob stream
ADO.NET Sample 22: Accessing INTERVAL type columns
ADO.NET Sample 23: How-to create an encrypted database

Native Interface Programming Samples
Native Sample 1: Execute none-query statement	Native Sample 2: How-to fetch results of a query statements
Native Sample 3: Prepare SQL statement	Native Sample 4: Execute Prepared SQL statement
Native Sample 5: Insert records to a updatable result set	Native Sample 6: Delete records from a updatable result set
Native Sample 7: Update records in a updatable result set	Native Sample 8: Execute batch of update statements

SQL Language Samples
SQL Procedural Language	Dynamic SQL Execution
SQL Sample 1: CREATE VIEW ... WITH CHECK OPTION	UNION, EXCEPT, INTERSECT
SQL Sample 2: CREATE VIEW ... WITH LOCAL CHECK OPTION	JOINs (CROSS JOIN, INNER JOIN, LEFT JOIN, RIGHT JOIN, NATURAL JOIN)
SQL Sample 3: CREATE VIEW ... WITH CASCADED CHECK OPTION	Common Table Expressions (Recursive and Non-Recursive CTEs)
SQL Sample 4: Create Generated (Computed) column - GENERATED ALWAYS AS
SQL Sample 5: ALTER COLUMN ... DROP GENERATED
SQL Sample 6: CREATE TABLE ... LIKE ... EXCLUDING GENERATED
SQL Sample 7: CREATE TABLE ... LIKE ... INCLUDING GENERATED
SQL Sample 8: CREATE TABLE ... AS ... WITH DATA
SQL Sample 9: CREATE TABLE ... AS ... WITH NO DATA
SQL Sample 10: GENERATED BY DEFAULT AS IDENTITY
UniqueIdentifier Data Type (From EffiProz 1.2)
Check Constraints
Group By, Having Clauses