VistaDB 4 
Recent Help File Changes 
Introduction to VistaDB 
Why VistaDB? Importance of Managed and Typesafe Code Types of Applications and Platforms Supported What about LINQ? Entity Framework Intro Learning Resources for .Net How does VistaDB work? Components for the .NET Framework Serverless Database Engine VistaDB Zero Config ADO.NET Overview Connected ADO.NET Objects Disconnected ADO.NET Objects Data Engine and SQL Query Processor Engine Features Zero config deployment Scalable to SQL Server or SQL Express Direct Data Access Objects - DDA Physical Database File Storage Data Types and Mapping from SQL Server to VistaDB Database limits based upon pagesize Database rowsize limits Pagesize performance implications VDC4 Files Data Management Tools Visual Studio Known Visual Studio Issues VistaDB Data Builder Startup Landing Page Data Builder Redistribution Importing data into VistaDB Data Migration Command Line Access 2007 Conversion SQL CE Conversion SQL Server Upsizing Exporting Data out of VistaDB VistaDB Licensing Ways to License VistaDB VistaDB Runtime Engine Embedded Assembly Licenses Common License Scenario Examples Open Source Projects Runtime License App runs locally and fails on remote machine Entity Framework Runtime License What is a licenses.licx file? You must have a valid license to use VistaDB EULA - End User License Agreement Third party support ADO.NET Factory Objects in your app.config or web.config Binding redirect support for provider factories SQL Function Reference Differences from SQL Server SQL Operators LEFT JOIN DEFAULT column entries ORDER BY GROUP BY SQL Functions Notes on SQL performance in VistaDB String Functions ASCII LOWER UNICODE UPPER CHAR NCHAR CHARINDEX LEN LTRIM RTRIM REVERSE SPACE LEFT RIGHT REPLACE REPLICATE STR STUFF 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 *deprecated* DATEADD DATEDIFF DATENAME DATEPART DAY GETDATE GETUTCDATE MONTH YEAR Remove TIME from a DATETIME 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() PRINT Subscribing to PRINT output in your application Control of Flow Statements IF / ELSE BEGIN / END SET @VAR DECLARE SET OPTIMIZATION CHECK VIEW WHILE / BREAK / CONTINUE TRY / CATCH RAISERROR System Variables Temp Tables Table Variable Example Temp Table Example Database Schema VistaDBConnection GetSchema Examples VistaDBDataReader GetSchemaTable example CASE in a WHERE clause Optimizing conditionals in where clauses Reserved Keywords Future Reserved Keywords ODBC Reserved Keywords Unsupported SQL Server Features and Syntax TSQL Stored Procedures and Functions TSQL Proc Creation Executing stored procedures TSQL Proc Removal Error handling in TSQL Procs Tips for SQL Server migration SQL User Defined Function Example ALTER a FUNCTION Example CLR Stored Procedures and Functions Registering CLR Methods as SQL Functions Loading CLR Assemblies into VistaDB Calling CLR Procedures and Functions Overview Calling CLR Code using ADO.NET Objects Calling CLR Functions using SQL Script Sample SQL CLR Project CLR Proc Sample Basic Steps Overview Example CLR Function and CLR Procedure Technical Details of CLR Procs and Functions Database Connections in a CLR Procedure CLR Methods and Attributes CLR Aggregate Functions Debugging CLR Procs and Functions Application Samples DBA Sample Tool Company Information Getting Support 
VistaDB.Net Product Website Online Account Manager Community Support Forums HOWTO tasks for VistaDB Sample Projects included with VistaDB 4 NTier TODO Sample Timesheet Website Sample Ticket System Sample Help Search FTS Sample UAC on Windows Vista and Windows 7 HOWTO Redistribute VistaDB with your project HOWTO Determine your database version HOWTO Build and Visualize Foreign Key References Adding a Foreign Key Foreign Key Integrity Actions Foreign Key Integrity Operation Types Foreign Key Indexes SQL Server Foreign Key Differences 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 Query a full text index Unsupported syntax HOWTO Use the VistaDBCommandBuilder HOWTO Get database schema using SQL HOWTO Test Medium Trust ASP.NET applications HOWTO Handle Transactions in SQL Number of open transactions HOWTO Work with isolated storage Working with a database in isolated storage Calculating free space in isolated storage HOWTO Fix Server Explorer entries that won't delete Fix broken datasets from 4.0 to 4.1 HOWTO use Connection Pooling Clearing Connection Pools Basic connection string concepts Example ConnectionStrings HOWTO Handle SQL and VistaDB Exceptions Serialization of Exceptions Load exception Data extended information HOWTO Check for bad encryption key at load time (password) HOWTO using VistaDB Providers for ASP.NET Websites Sample web.config for membership providers Forcing app database connections closed Data Builder Menu Commands File Database Table View CLR Procs Add Assembly SQL Script Tools Options Window Help Toolbar Commands Main Content Pane Context Sensitive Screens Data File Information SQL Query Pane SQL Query Results Keyboard Shortcuts VSQL4 Files and sql file management Syntax Editor Advanced Options LINQ Query Pane LINQ Entity Model Tab LINQ Script CRUD Examples 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 User Defined Functions API 
Namespace VistaDB 
Class DDAChannel 
Constructor 
CurrentDatabase IsAvailable Pipe Class FallBackToVistaDBDesignTimeLicenseAttribute Constructor Class SQLChannel Constructor CurrentTransaction IsAvailable Pipe TriggerContext Class TriggerContext 
IsUpdatedColumn ColumnCount TriggerAction Class UseVistaDBDesignTimeLicenseAttribute Constructor Class UseVistaDBEmbeddedLicenseAttribute Constructor Constructor ManifestResourceName Class VistaDBClrProcedureAttribute Constructor FillRow Kind Class VistaDBContext Constructor Class VistaDBLicense Constructor UseDesignTimeLicenseCheckAssembly UseEmbeddedLicenseCheckAssembly 
Enumeration TriggerAction 
AfterDelete AfterInsert AfterUpdate Enumeration VistaDBClrProcedureKind Aggregate Default Enumeration VistaDBDatabaseOpenMode ExclusiveReadOnly ExclusiveReadWrite NonexclusiveReadOnly NonexclusiveReadWrite SharedReadOnly Enumeration VistaDBType BigInt Bit Char DateTime Decimal Float Image Int Money NChar NText NVarChar Real SmallDateTime SmallInt SmallMoney Text Timestamp TinyInt Uninitialized UniqueIdentifier Unknown VarBinary VarChar 
Interface IVistaDBValue IsNull SystemType Type Value Namespace VistaDB.Build Class Version Constructor BuildString EditionString Namespace VistaDB.Compatibility.SqlServer Class SqlContext Constructor IsAvailable Pipe TriggerContext WindowsIdentity Class SqlDataRecord Constructor GetBoolean GetByte GetBytes GetChar GetChars GetData GetDataTypeName GetDateTime GetDecimal GetDouble GetFieldType GetFloat GetGuid GetInt16 GetInt32 GetInt64 GetName GetOrdinal GetString GetValue GetValues IsDBNull SetBoolean SetByte SetBytes SetChar SetChars SetDateTime SetDecimal SetDouble SetFloat SetGuid SetInt16 SetInt32 SetInt64 SetString SetValue SetValues FieldCount Item Class SqlFunctionAttribute Constructor DataAccess FillRowMethodName IsDeterministic IsPrecise Name SystemDataAccess TableDefinition Class SqlMetaData Constructor Constructor Constructor Constructor AllowNull MaxLength Name VistaDBType Class SqlMethodAttribute Constructor InvokeIfReceiverIsNull IsMutator OnNullCall Class SqlProcedureAttribute Constructor Name Class SqlTriggerAttribute Constructor Event Name Target Enumeration DataAccessKind None Read Enumeration SystemDataAccessKind None Read Namespace VistaDB.DDA Class VistaDBEngine Connections Clear Contains ContainsKey CopyTo GetEnumerator OpenDDA TryGetValue Count IsReadOnly Item Keys Values 
Delegate DDAEventDelegate Constructor BeginInvoke EndInvoke Invoke Delegate OperationCallbackDelegate Constructor BeginInvoke EndInvoke Invoke Enumeration DDAEventDelegateType AfterDelete AfterInsert AfterUpdate BeforeDelete BeforeInsert BeforeUpdate NewVersion Enumeration VistaDBOperationStatusTypes BackupOperation BinaryOperation ClrProcOperation ConstraintOperation DataExportOperation DataImportOperation EncryptOperation FreeSpaceOperation FullTextOperation IndexOperation RowOperation SchemaChangeOperation SqlProcOperation SyncDataOperation SyncSchemaOperation TransactionOperation ViewOperation Enumeration VistaDBReferentialIntegrity Cascade None SetDefault SetNull Enumeration VistaDBXmlReadMode All DataOnly Enumeration VistaDBXmlWriteMode All DataOnly SchemaOnly Interface IVistaDBAssemblyCollection Interface IVistaDBAssemblyInformation COFFImage FullName ImageRuntimeVersion Name Procedures Triggers VistaDBRuntimeVersion Interface IVistaDBClrProcedureCollection Interface IVistaDBClrProcedureInformation AssemblyName FullHostedName Name Signature Interface IVistaDBClrTriggerCollection Interface IVistaDBClrTriggerInformation AssemblyName FullHostedName Name Signature TableName TriggerAction Interface IVistaDBColumn Compare AllowNull MaxLength MaxValue MinValue Modified Name ReadOnly Interface IVistaDBColumnAttributes Compare CodePage Description Encrypted ExtendedType FixedType IsSystem Name Packed RowIndex UniqueId Interface IVistaDBColumnAttributesDifference IsCaptionDiffers IsCodePageDiffers IsDescriptionDiffers IsEncryptedDiffers IsMaxLengthDiffers IsNullDiffers IsOrderDiffers IsPackedDiffers IsReadOnlyDiffers IsRenamed IsTypeDiffers Interface IVistaDBConnection Id LCID LockTimeout PageSize PersistentLockFiles Interface IVistaDBConstraintCollection Interface IVistaDBConstraintInformation AffectsDelete AffectsInsertion AffectsUpdate Expression Name Interface IVistaDBDatabase ActivateSyncService AddAssembly AddToXmlTransferList AlterTable BeginTransaction BeginTransaction ClearXmlTransferList CommitTransaction ContainsTable CreateTable DeactivateSyncService DropAssembly DropTable ExportXml GetAssemblies GetClrProcedures GetClrTriggers GetClrTriggers GetLastIdentity GetLastTimestamp GetTableNames ImportXml ImportXml InvokeClrProcedure InvokeClrProcedureFillRow NewTable OpenTable PrepareClrContext PrepareClrContext RegisterClrProcedure RegisterClrTrigger RollbackTransaction TableSchema TestDatabaseObjectName UnprepareClrContext UnregisterClrProcedure UnregisterClrTrigger UpdateAssembly CaseSensitive Culture Description IsolatedStorage IsolationLevel Mode NestedTransactionLevel PageSize Relationships VersionGuid Interface IVistaDBDatabaseObject Description Name Interface IVistaDBDDA CreateDatabase CreateInMemoryDatabase CreateInMemoryDatabase CreateIsolatedDatabase OpenDatabase OpenIsolatedDatabase PackDatabase PackDatabase PackDatabase PackDatabase RepairDatabase RepairDatabase RepairDatabase Interface IVistaDBDDAEventDelegate EventDelegate Type UsersData Interface IVistaDBDefaultValueCollection Interface IVistaDBDefaultValueInformation ColumnName Expression UseInUpdate Interface IVistaDBIdentityCollection Interface IVistaDBIdentityInformation ColumnName SeedValue StepExpression Interface IVistaDBIndexCollection Interface IVistaDBIndexInformation FKConstraint FullTextSearch KeyExpression KeyStructure Name Primary Temporary Unique Interface IVistaDBKeyColumn Descending RowIndex Interface IVistaDBKeyedCollection<TKey,TValue> ContainsKey TryGetValue Item Keys Values Interface IVistaDBOperationCallbackStatus Message ObjectName Operation Progress Interface IVistaDBPipe Send Interface IVistaDBRelationshipCollection Interface IVistaDBRelationshipInformation DeleteIntegrity ForeignKey ForeignTable Name PrimaryTable UpdateIntegrity Interface IVistaDBRow ClearModified Compare CompareKey InitBottom InitTop Count Item RowId Interface IVistaDBTable Close CreateConstraint CreateDefaultValue CreateForeignKey CreateFTSIndex CreateIdentity CreateIndex CreateTemporaryIndex Delete DropConstraint DropDefaultValue DropForeignKey DropFTSIndex DropIdentity DropIndex Evaluate ExportData Find Find First Get Get GetFilter GetScope GetToFile GetToFile Insert Last Lock MoveBy Next Post Post Prev Put Put Put PutBinary PutBinary PutBoolean PutBoolean PutByte PutByte PutDateTime PutDateTime PutDecimal PutDecimal PutDouble PutDouble PutFromFile PutFromFile PutGuid PutGuid PutInt16 PutInt16 PutInt32 PutInt32 PutInt64 PutInt64 PutNull PutNull PutSingle PutSingle PutString PutString RenameIndex ResetEventDelegate ResetFilter ResetScope SetDDAEventDelegate SetFilter SetOperationCallbackDelegate SetScope SetScope Unlock ActiveIndex CurrentKey CurrentRow EndOfTable EnforceConstraints EnforceIdentities IsClosed LastSessionIdentity LastTableIdentity Name RegularIndexes RowCount ScopeKeyCount StartOfTable TemporaryIndexes Interface IVistaDBTableNameCollection Interface IVistaDBTableSchema AddColumn AddColumn AddColumn AlterColumnName AlterColumnOrder AlterColumnType AlterColumnType DefineColumnAttributes DefineConstraint DefineDefaultValue DefineIdentity DefineIndex DropColumn DropConstraint DropDefaultValue DropIdentity DropIndex ColumnCount Constraints DefaultValues Description DroppedColumns ForeignKeys Identities Indexes IsSynchronized IsSystemTable IsTombstoneTable Item Name RenamedColumns Triggers Namespace VistaDB.Diagnostic Class Errors ado_CBSchemaCannotBeGenerated ado_ChangePropWhileConnOpened ado_ChangePropWhileDataAdapter ado_CommandTextEmpty ado_ConnectionMustBeAssigned ado_ConnectionMustBeOpened ado_ContextConnNotAvailable ado_InvalidNamePrefix ado_InvalidNameSuffix ado_KeywordNotSupported ado_ReadCommittedIsolationOnly ado_SecondDataReader ado_SupportedOnlyCommand ado_UnknownDataType dda_ActivateDatabase dda_ActivateDefaultRow dda_ActivateHeader dda_ActivateHeaderStructure dda_ActivateIndex dda_ActivateLink dda_ActivateLockPolicy dda_ActivateNodeAtPosition dda_ActivateSyncService dda_AfterDeletingRow dda_AfterInsertingRow dda_AfterUpdatingRow dda_AllocateRowStructure dda_AlterSystemColumn dda_AlterTable dda_AnchorTablename dda_AssemblyAddFault dda_AssemblyDeleteFault dda_AssemblyNameRegistered dda_AssemblyNotRegistered dda_AssemblyUpdateFault dda_BeforeInsertingRow dda_BeforeUpdatingRow dda_BeginTransaction dda_CannotAlterRelationship dda_CannotAssignEnvironmentVariable dda_CannotDropFKIndex dda_CannotFindKey dda_CannotRenameFKIndex dda_CannotSynchKey dda_CleanStorage dda_CloseStorage dda_CloseTable dda_ClrProcedureFillRowNotRegistered dda_ClrProcedureInvokeFailed dda_ClrProcedureNotRegistered dda_ClrProcedureReferenced dda_ClrProcedureRegisterFailed dda_ClrProcedureRemoveFailed dda_ClrTriggerInvalidEvent dda_ClrTriggerNotRegistered dda_ClrTriggerReferenced dda_ClrTriggerRegisteringFault dda_ClrTriggerUnregisteringFault dda_ColumnType dda_CommitHasNoBegin dda_CommitTransaction dda_CompactFrameworkMode dda_CompileExpression dda_CompileKeyExpression dda_ConstraintFault dda_ConstraintNotExist dda_CreateDatabase dda_CreateDefaultRow dda_CreateForeignKey dda_CreateHeader dda_CreateIndex dda_CreateIsolatedDatabase dda_CreateLink dda_CreateLinks dda_CreateRow dda_CreateStorage dda_CreateTable dda_CreateTableHeader dda_CreateTemporaryDatabase dda_CreateTransactionLogTable dda_DataExport dda_DataImport dda_DatastorageDeclaration dda_DatatypeConversion dda_DeactivateIndex dda_DeactivateSyncService dda_DefaultValueFault dda_DefaultValueNonExist dda_DeleteLink dda_DeleteLinks dda_DeleteRow dda_DropConstraint dda_DropDefaultValue dda_DropForeignKey dda_DropIdentity dda_DropIndex dda_DropSyncTable dda_DropTable dda_DuplicateClrProcedureName dda_DuplicateClrTriggerName dda_DuplicateColumnName dda_DuplicateIndexName dda_DuplicateKey dda_DuplicateSPName dda_DuplicateTableName dda_DuplicateTimestamp dda_DynamicRange dda_EmptyIndexInformation dda_EmptyTableSchema dda_EncryptionKeyEmpty dda_EncryptionKeyInvalid dda_EvaluateExpression dda_EvaluateKey dda_EvaluateOperator dda_ExportTable dda_ExpressionTypeCheck dda_Filter dda_FtsActiveIndex dda_FullTextSingle dda_IdentityExist dda_IdentityNonExist dda_IncompleteExpression dda_IncorrectString dda_IncorrectTpIsolationLevel dda_IndexKeyColumnCountExceeds dda_IndexKeyColumnInvalid dda_InitRecycling dda_InitSpool dda_InvalidCharLength dda_InvalidClrProcedureName dda_InvalidColumnByIndex dda_InvalidColumnByName dda_InvalidDelimiter dda_InvalidExpression dda_InvalidFloatFormat dda_InvalidIdentityStep dda_InvalidIfElse dda_InvalidLogicalExpression dda_InvalidName dda_InvalidOperation dda_InvalidOrderToFindKey dda_InvalidPageCount dda_InvalidPageSize dda_InvalidParameter dda_InvalidRowInDelete dda_InvalidRowInUpdate dda_InvalidVDBFormat dda_IsolateStorageAccessMode dda_LockRow dda_LockStorage dda_LockStreamPosition dda_LockTimeout dda_MaximumColumns dda_MissingStringDelimiter dda_ModifySystemTable dda_NestedTransactionsNotSupported dda_NewerSpecification dda_NodeDecryption dda_NodeEncryption dda_NonExistedIndex dda_NonExistedTable dda_NonSupportedDataType dda_NonSupportedDefaultValue dda_NonSupportedFileExtension dda_NonSupportedIdentity dda_NullFault dda_NullValue dda_OpenDatabase dda_OpenIsolatedDatabase dda_OpenStorage dda_OpenTable dda_OpenTransactionLogTable dda_PackDatabase dda_PackStorage dda_PackViaDDA dda_ParametersNumberInClrProcedure dda_ParenthesisMismatch dda_PrimaryKeyCannotBeSelfReferenced dda_PrimaryKeyContainsNull dda_PrimaryKeyIdenticalForeignKey dda_PrimaryKeyNotFound dda_PrimaryKeyRefencedInDelete dda_PrimaryKeyReferenced dda_PrimaryKeySingle dda_ReadHeader dda_ReadonlyFault dda_ReadOnlyMode dda_ReadStorage dda_RelationshipDoesNotExist dda_RelationshipExist dda_ReleaseLocks dda_RollbackHasNoBegin dda_RollbackTransaction dda_RowExceedsPage dda_RowOutdated dda_RowsetExlusiveMode dda_SchemaChanges dda_SeedNullValue dda_SetConstraint dda_SetDefaultValue dda_SetIdentity dda_SharedMode dda_SPRegisteringFault dda_SPUnregisteringFault dda_StepNullValue dda_StorageReadOnlyMode dda_StringExceedMaximum dda_TableClosed dda_TableToDropOpened dda_TombstoneName dda_TransactionConcurrency dda_TransactionModeOff dda_TransactionModeOnlyOff dda_UnexpectedElse dda_UnexpectedThen dda_UnlockRow dda_UpdateFTSSpecification dda_UpdateLink dda_UpdateLinks dda_UpdateRow dda_UpdateSpecification dda_VDBType dda_WriteHeader dda_WriteStorage dda_ZapStorage dt_ActiveIndex dt_DeleteRow dt_FindRow dt_HideNewRow dt_InsertRow dt_LastKeyPosition dt_OpenTable dt_Position dt_ReadData dt_ReadSchema dt_Reset dt_ResetScope dt_RowIsNotExist dt_RowsAdded dt_SetFilter dt_SetScope dt_UpdateRow lic_Invalid lic_WrongVersion Nonsupported sql_AggColumnNotInGroupBy sql_AggregateAllAsterix sql_AggregateDistinctAsterix sql_AggregateTableAsterix sql_AssemblyNameNotDefined sql_AssignValueSelect sql_CaseMustHaveWhen sql_CaseWhenMustBeBoolean sql_CaseWhenMustBeInputDataType sql_CLRProcExecutionError sql_ColumnDoesNotExist sql_ConstraintNotExist sql_CreateTableColumnsDuplicated sql_CreateTableConstraintDuplicated sql_CustomError sql_DatabaseNotOpened sql_DataTypeLenIsTooLong sql_DuplicateAction sql_ExpectedBooleanExpression sql_ExpectedConstraintEnd sql_ExpectedExprButFound sql_ExpectedExpression sql_ExpectedKeyword sql_ExpectedOutParameter sql_ExpectedSymbol sql_ExprAlreadyPresentInGroup sql_ExprNotPresentInGroup sql_FillRowDoesNotExist sql_FirstParameterMustBeObject sql_FtsIndexRequired sql_FunctionNotExist sql_IdentityAndDefaultValue sql_IncorrectSyntax sql_IncorrectTypeProvided sql_InsertColumnFewerThanSelect sql_InsertColumnFewerThanValues sql_InsertColumnMoreThanValues sql_InsertSelectFewerThanColumn sql_InvalidBreakUsing sql_InvalidCaseResultDataType sql_InvalidCaseSyntax sql_InvalidCLRProcParamType sql_InvalidColumnCountInView sql_InvalidColumnName sql_InvalidConstraintExpr sql_InvalidContinueUsnig sql_InvalidCreateDatabaseParams sql_InvalidDataTypeSpec sql_InvalidExprInResultColumn sql_InvalidForeignKeyCount sql_InvalidFtsPattern sql_InvalidGroupStatic sql_InvalidGroupWithAggregate sql_InvalidGroupWithoutAggregate sql_InvalidHavingClauseCondition sql_InvalidHavingExpressions sql_InvalidHavingWithoutAggregate sql_InvalidIdentifier sql_InvalidJoinCondition sql_InvalidLikeMatchExpression sql_InvalidNewNameInRename sql_InvalidObjectTypeInRename sql_InvalidOperandDataType sql_InvalidOutParam sql_InvalidParameterCount sql_InvalidParameterDataType sql_InvalidParamForm sql_InvalidParamName sql_InvalidPatternEscapeSymbol sql_InvalidPatternFirstCharacter sql_InvalidPrimaryKeyInReferences sql_InvalidQueryIndex sql_InvalidSchemaName sql_InvalidStatement sql_InvalidTableName sql_InvalidToken sql_InvalidTriggerDeclaration sql_InvalidUnionColumnCount sql_InvalidUnionColumnTypes sql_InvalidUsingOfIS sql_NestedAggregateFunction sql_NumericParameterRequired sql_OnlySingleExpressionInSelectList sql_ParameterIsNotDefined sql_ParamNotDeclared sql_ParamRedeclaration sql_PatternMustBeString sql_PrimaryKeyDoesNotExist sql_PrimaryKeyDuplicated sql_ReservedWordNameOrAlias sql_SameColumnInSomeTables sql_StoredProcIsReadOnly sql_SubQueryIsReadOnly sql_TableAliasDuplicated sql_TableNotExist sql_TooManyArguments sql_TwoClusteredIndexes sql_UnableToImplicitCastType sql_UnexpectedError sql_UnknownDataType sql_UnterminatedColumnName sql_UnterminatedComment sql_UnterminatedPattern sql_UnterminatedString sql_UnterminatedTableName sql_ViewIsReadOnly sql_ViewNameDuplicated sql_ViewNotExist sql_WhereCannotHaveAggregate sql_WithIsUnsupported sql_wrongRowGuidCol GetMessage Class Support Constructor BeginLogging BeginLogging EndLogging EndLogging LogMessage IncludeCommandSQL IncludeDataReaderRows Class VistaDBDataTableException Constructor Constructor IsCritical Class VistaDBException Contains GetObjectData ErrorId LevelMessage Message Class VistaDBSQLException GetObjectData ColumnNo LineNo Namespace VistaDB.Extra Class VistaDBDataTable Constructor Constructor 
ListChanged ClearFilter ClearScope Close Find GetCurrentRowId SetActiveIndex SetFilter SetScope ActiveIndex Count Exclusive GetExtendedNames OptimisticLock ReadOnly TableSchema Namespace VistaDB.Provider Class ParameterEnumerator MoveNext Reset Current Class PlanBlockCollection Count Item Class SchemaConstants SCHEMA_COLUMNS SCHEMA_DATASOURCEINFORMATION SCHEMA_DATATYPES SCHEMA_FOREIGNKEYCOLUMNS SCHEMA_FOREIGNKEYS SCHEMA_INDEXCOLUMNS SCHEMA_INDEXES SCHEMA_METADATACOLLECTIONS SCHEMA_RESERVEDWORDS SCHEMA_RESTRICTIONS SCHEMA_SPPARAMETERS SCHEMA_STOREDPROCEDURES SCHEMA_TABLES SCHEMA_VIEWCOLUMNS SCHEMA_VIEWS Class VistaDBCommand Constructor Constructor Constructor Cancel CreateParameter ExecuteNonQuery ExecuteReader ExecuteReader ExecuteScalar Prepare ResetCommandTimeout CommandText CommandTimeout CommandType Connection DesignTimeVisible HasDDLCommands Parameters Transaction UpdatedRowSource Class VistaDBCommandBuilder Constructor Constructor DeriveParameters GetDeleteCommand GetDeleteCommand GetInsertCommand GetInsertCommand GetUpdateCommand GetUpdateCommand QuoteIdentifier UnquoteIdentifier DataAdapter QuotePrefix QuoteSuffix SchemaSeparator Class VistaDBConnection Constructor Constructor Constructor InfoMessage SystemSchema SystemTableType UserTableType BeginTransaction BeginTransaction ChangeDatabase ClearAllPools ClearPool Close CreateCommand GetSchema GetSchema GetSchema GetTableSchema IsConstraintSyntaxCorrect IsSyntaxCorrect IsViewSyntaxCorrect Open PackDatabase PackDatabase PackDatabase PackDatabase PackDatabase PackDatabase RepairDatabase RepairDatabase RepairDatabase RepairDatabase ConnectionString ContextConnection Database DataSource IsolatedStorage LockTimeout OpenMode Password PersistentLockFiles ServerVersion State TransactionMode Class VistaDBConnectionStringBuilder Constructor Constructor Clear ContainsKey Remove ShouldSerialize TryGetValue ConnectTimeout ContextConnection Database DataSource EncryptDatabase IsFixedSize IsolatedStorage Item Keys MaxPoolSize MinPoolSize OpenMode Password Pooling TransactionMode Values Class VistaDBDataAdapter Constructor Constructor Constructor Constructor RowUpdated RowUpdating DeleteCommand InsertCommand SelectCommand UpdateCommand Class VistaDBDataPermission Constructor Class VistaDBDataReader Close GetBoolean GetByte GetBytes GetChar GetChars GetDataTypeName GetDateTime GetDecimal GetDouble GetEnumerator GetFieldType GetFieldVistaDBType GetFloat GetGuid GetInt16 GetInt32 GetInt64 GetName GetOrdinal GetSchemaTable GetString GetValue GetValues IsDBNull NextResult Read Depth FieldCount HasRows IsClosed Item RecordsAffected Class VistaDBExecutionPlan FirstBlock Class VistaDBInfoMessageEventArgs Message Source Class VistaDBParameter Constructor Constructor Constructor Constructor Constructor Constructor ResetDbType DbType Direction IsNullable ParameterName Size SourceColumn SourceColumnNullMapping SourceVersion Value VistaDBType Class VistaDBParameterCollection Add Add Add Add Add Add AddRange AddWithValue Clear Contains Contains CopyTo GetEnumerator IndexOf IndexOf Insert Insert Remove Remove RemoveAt RemoveAt Count IsFixedSize IsReadOnly IsSynchronized Item SyncRoot Class VistaDBPipe ExecuteAndSend Send Send Send SendResultsEnd SendResultsRow SendResultsStart Class VistaDBPlanBlock Childs PlanBlockType Class VistaDBPlanFunctionBlock FunctionName Class VistaDBPlanResultBlock PlanResultType QueryText Class VistaDBPlanTableBlock IndexName JoinedTable TableName Class VistaDBProviderFactory Instance CreateCommand CreateCommandBuilder CreateConnection CreateConnectionStringBuilder CreateDataAdapter CreateParameter CreatePermission CanCreateDataSourceEnumerator Class VistaDBRowUpdatedEventArgs Constructor Command Class VistaDBRowUpdatingEventArgs Constructor Command Class VistaDBTransaction Commit Rollback Connection IsolationLevel Delegate VistaDBInfoMessageEventHandler Constructor BeginInvoke EndInvoke Invoke Delegate VistaDBRowUpdatedEventHandler Constructor BeginInvoke EndInvoke Invoke Delegate VistaDBRowUpdatingEventHandler Constructor BeginInvoke EndInvoke Invoke Enumeration BlockType AggregateStream Batch DistinctSort Function InnerJoin LeftJoin Merge Result Scalar Sort Table Top Union Enumeration ResultType Delete Insert Other Select Update Enumeration TransactionMode Ignore Off On Namespace VistaDB.VistaDBTypes Class VistaDBBinary Constructor Constructor GetValueOrDefault GetValueOrDefault GetValueOrDefault SystemType Type Value Class VistaDBBoolean Constructor Constructor GetValueOrDefault GetValueOrDefault GetValueOrDefault SystemType Type Value Class VistaDBByte Constructor Constructor GetValueOrDefault GetValueOrDefault GetValueOrDefault SystemType Type Value Class VistaDBDateTime Constructor Constructor GetValueOrDefault GetValueOrDefault GetValueOrDefault SystemType Type Value Class VistaDBDecimal Constructor Constructor GetValueOrDefault GetValueOrDefault GetValueOrDefault SystemType Type Value Class VistaDBDouble Constructor Constructor GetValueOrDefault GetValueOrDefault GetValueOrDefault SystemType Type Value Class VistaDBGuid Constructor Constructor GetValueOrDefault GetValueOrDefault GetValueOrDefault SystemType Type Value Class VistaDBInt16 Constructor Constructor GetValueOrDefault GetValueOrDefault GetValueOrDefault SystemType Type Value Class VistaDBInt32 Constructor Constructor GetValueOrDefault GetValueOrDefault GetValueOrDefault SystemType Type Value Class VistaDBInt64 Constructor Constructor GetValueOrDefault GetValueOrDefault GetValueOrDefault SystemType Type Value Class VistaDBSingle Constructor Constructor GetValueOrDefault GetValueOrDefault GetValueOrDefault SystemType Type Value Class VistaDBString Constructor Constructor GetValueOrDefault GetValueOrDefault GetValueOrDefault SystemType Type Value Class VistaDBValue HasValue IsNull SystemType Type Value Web Providers API Namespace VistaDB.Web Class Version Constructor BuildString Edition MajorBuildVersion MajorVersion MinorBuildVersion ReleaseMode Class VistaDBMembershipProvider Constructor ChangePassword ChangePasswordQuestionAndAnswer CreateUser DeleteUser FindUsersByEmail FindUsersByName GeneratePassword GetAllUsers GetNumberOfUsersOnline GetPassword GetUser GetUser GetUserNameByEmail Initialize ResetPassword UnlockUser UpdateUser ValidateUser ApplicationName EnablePasswordReset EnablePasswordRetrieval MaxInvalidPasswordAttempts MinRequiredNonAlphanumericCharacters MinRequiredPasswordLength PasswordAttemptWindow PasswordFormat PasswordStrengthRegularExpression RequiresQuestionAndAnswer RequiresUniqueEmail Class VistaDBProfileProvider Constructor DeleteInactiveProfiles DeleteProfiles DeleteProfiles FindInactiveProfilesByUserName FindProfilesByUserName GetAllInactiveProfiles GetAllProfiles GetNumberOfInactiveProfiles GetPropertyValues Initialize SetPropertyValues ApplicationName Class VistaDBRoleProvider Constructor AddUsersToRoles CreateRole DeleteRole FindUsersInRole GetAllRoles GetRolesForUser GetUsersInRole Initialize IsUserInRole RemoveUsersFromRoles RoleExists ApplicationName