VistaDB 3 
Recent Help File Changes 
Introduction to VistaDB 3 
Why VistaDB? Importance of Managed and Typesafe Code Types of Applications and Platforms Supported How does VistaDB 3 work? Components for the .NET Framework and Compact Framework Data Engine and SQL Query Processor Engine Features Zeroclick deployment Scalable to SQL Server 2005 or SQL Express 2005 Direct Data Access (tm) Objects - DDA Database (.VDB3) Data Store Data Types and Mapping from SQL Server to VistaDB Data Management Tools VistaDB Data Builder Data Builder Redistribution Importing data into VistaDB Data Migration Command Line Licensing and Deployment Ways to License VistaDB VistaDB Subscription VistaDB Express VistaDB Source Edition VistaDB Runtime Engine Technology Requirements Runtime License EULA - End User License Agreement Third party support App.Config support for precompiled assemblies SQL Function Reference SQL Operators DEFAULT column entries SQL Functions String Functions ASCII LOWER UNICODE UPPER CHAR NCHAR CHARINDEX LEN LTRIM RTRIM REVERSE SPACE LEFT RIGHT REPLACE REPLICATE STR SRUFF SUBSTRING PATINDEX Mathematical Functions ABS ACOS ASIN ATAN ATN2 CEILING COS COT DEGREES EXP FLOOR FRAC INT LOG LOG10 MAXOF MINOF PI POWER RADIANS RAND ROUND SIGN SIN SQRT SQUARE TAN Date and Time Functions DATE DATEADD DATEDIFF DATENAME DATEPART DAY GETDATE GETUTCDATE MONTH YEAR System Functions CAST ISNULL NULLIF CONVERT CASE CONTAINS LASTIDENTITY LASTTIMESTAMP COALESCE NEWID SP_RENAME Aggregate Functions AVG COUNT COUNT_BIG MAX MIN SUM STDEV Special Functions GETVIEWS GETVIEWCOLUMNS SP_UDF() SP_STORED_PROCEDURES() Control of Flow Statements IF / ELSE BEGIN / END SET @VAR DECLARE SET OPTIMIZATION CHECK VIEW WHILE / BREAK / CONTINUE System Variables Database Schema Examples Reserved Keywords Future Reserved Keywords ODBC Reserved Keywords TSQL Stored Procs Features not currently supported TSQL Proc Creation Executing stored procedures TSQL Proc Removal Error handling in TSQL Procs Tips for SQL Server migration VistaDB Software, Inc. Getting Support 
VistaDB Website Support Forums HOWTO tasks for VistaDB3 Sample Projects included with VistaDB 3 HOWTO Redistribute VistaDB with your project HOWTO Determine your database version HOWTO Run NUnit tests NUnit overview VistaDB.NUnit namespace and project Running NUnit tests Debugging with NUnit Other Unit Testing frameworks HOWTO Pack a database HOWTO Create a new database in code SQL Create Database DDA CreateDatabase HOWTO Use Full Text Search What is a full text search index? FTS Concepts and terminology List of Stop Words Creating a full text search index CreateFTSIndex using DDA Code Query a full text index HOWTO Use the VistaDBCommandBuilder HOWTO Create a CLR Proc HOWTO Get database schema using SQL HOWTO Test Medium Trust ASP.NET applications HOWTO Handle Transactions in DDA and SQL Number of open transactions HOWTO Work with isolated storage Working with a database in isolated storage Calculating free space in isolated storage HOWTO use Connection Pooling Clearing Connection Pools Basic connection string concepts Example ConnectionStrings HOWTO Handle SQL and VistaDB Exceptions HOWTO Check for bad passwords at load time HOWTO using VistaDB Providers for ASP.NET Websites Sample web.config Data Builder Menu Commands File Database Table Default Value for a column View CLR Procs Add Assembly Tools Options Window Help Toolbar Commands Main Content Pane Context Sensitive Screens Data File Information Query Pane Tables Pane Per Table Options Views Alter View Relationships Programmability Assemblies Stored Procedures Add a new Stored Procedure Dialog Modify an existing stored procedure Functions Create or alter UDF Articles SQL query optimization and testing Performance numbers and VistaDB The GC does not solve all memory leaks The VistaDB business case VistaDB business case - Compatibility VistaDB business case - Source Code VistaDB business case - Scalability Protect and Authenticate .NET Applications New Feature Frenzy? 3.3 API Changes and more - Nullable is not null? New way to distribute samples – Crazy idea? SQL Server 2008 (Katmai) Information Looking ahead to 2008, and back at 2007 Set any Resolutions for 2008? Connection Pooling update VistaDB Express Announcement VistaDB Customer Survey Fall 2007 Unit testing Explicitly Hidden Methods Using SqlBulkCopy to move data from VistaDB to SQL Server Subscription renewals, dog food, and upcoming changes Strongly typed performance gains Generics and Dictionaries are fast data caches Class vs Struct