• KellermanSoftware.Ninja-Database-Pro Assembly
  • Overview
  • Namespaces
    • KellermanSoftware.NinjaDatabasePro Namespace
      • Overview
      • Classes
        • BaseCompositeIndex<T>
          • Overview
          • Members
          • Methods
            • Clear Method
            • ClearLazyLoadedValues Method
            • Delete Method
            • GetAllPrimaryKeys Method
            • GetAllPrimaryKeysDescending Method
            • GetIndexRecordExactMatch Method
            • GetPrimaryKeys Method
            • Insert Method
            • Query Method
            • SortIndex Method
            • Update Method
          • Properties
            • ClassName Property
            • DatabaseReference Property
            • IndexName Property
            • IsDirty Property
            • NeedsSorted Property
            • Properties Property
            • SerializedDictionary Property
            • Style Property
        • BaseSingleIndex<T,TIndex>
          • Overview
          • Members
          • Methods
            • Clear Method
            • ClearLazyLoadedValues Method
            • Delete Method
            • GetAllPrimaryKeys Method
            • GetAllPrimaryKeysDescending Method
            • GetIndexRecordExactMatch Method
            • GetPrimaryKeys Method
            • Insert Method
            • Query Method
            • SortIndex Method
            • Update Method
          • Properties
            • ClassName Property
            • DatabaseReference Property
            • IndexName Property
            • IsDirty Property
            • NeedsSorted Property
            • PropertyName Property
            • SerializedDictionary Property
            • Style Property
        • CompositeIndex<T>
          • Overview
          • Members
          • CompositeIndex<T> Constructor
          • Methods
            • Clear Method
            • ClearLazyLoadedValues Method
            • Delete Method
            • GetAllPrimaryKeys Method
            • GetAllPrimaryKeysDescending Method
            • GetIndexRecordExactMatch Method
            • GetPrimaryKeys Method
            • Insert Method
            • Query Method
            • SortIndex Method
            • Update Method
          • Properties
            • SerializedDictionary Property
          • Fields
            • NonUniqueItems Field
            • UniqueItems Field
        • CompositeIndexRecord<T>
          • Overview
          • Members
          • CompositeIndexRecord<T> Constructor
          • Methods
            • Equals Method
            • GetHashCode Method
          • Properties
            • Indexes Property
            • LazyValue Property
          • Fields
            • PrimaryKey Field
        • DisableAutoAttribute
          • Overview
          • Members
          • DisableAutoAttribute Constructor
        • Field
          • Overview
          • Members
          • Field Constructor
          • Properties
            • FieldType Property
            • Name Property
        • FileDatabase
          • Overview
          • Members
          • FileDatabase Constructor
          • Methods
            • CopyDirectory Method
            • CreateDirectory Method
            • DeleteDirectory Method
            • DeleteFile Method
            • DirectoryExists Method
            • Dispose Method
            • FileExists Method
            • StreamFactory Method
        • ForeignKeyAttribute
          • Overview
          • Members
          • ForeignKeyAttribute Constructor
          • Properties
            • Relationship Property
        • FullTextIndex<T>
          • Overview
          • Members
          • FullTextIndex<T> Constructor
          • Methods
            • SearchAllKeywords Method
            • SearchAnyKeywords Method
            • SearchByRegex Method
            • SearchPhrase Method
        • IgnoreColumnAttribute
          • Overview
          • Members
          • IgnoreColumnAttribute Constructor
        • IsolatedStorageDatabase
          • Overview
          • Members
          • IsolatedStorageDatabase Constructor
          • Methods
            • CopyDirectory Method
            • CreateDirectory Method
            • DeleteDirectory Method
            • DeleteFile Method
            • DirectoryExists Method
            • Dispose Method
            • FileExists Method
            • StreamFactory Method
        • MemoryDatabase
          • Overview
          • Members
          • MemoryDatabase Constructor
          • Methods
            • CopyDirectory Method
            • CreateDirectory Method
            • DeleteDirectory Method
            • DeleteFile Method
            • DirectoryExists Method
            • Dispose Method
            • FileExists Method
            • StreamFactory Method
        • NinjaDbPro
          • Overview
          • Members
          • NinjaDbPro Constructor
          • Methods
            • AddCompositeIndex Method
              • AddCompositeIndex<T>(BaseCompositeIndex<T>) Method
              • AddCompositeIndex<T>(String,List<String>,IndexStyle) Method
            • AddFullTextIndex<T> Method
            • AddIndex Method
              • AddIndex<T,TIndex>(BaseSingleIndex<T,TIndex>) Method
              • AddIndex<T,TIndex>(String,String,IndexStyle) Method
            • Backup Method
            • BeginBulkOperation Method
            • BeginTransaction Method
            • ClearLazyLoadedValues Method
            • CloseDatabase Method
            • CommitBulkOperation Method
            • CommitTransaction Method
            • CreateCompositeIndexQuery Method
              • CreateCompositeIndexQuery<T>(String) Method
              • CreateCompositeIndexQuery<T>(String,List<Object>) Method
            • CreateIndexQuery Method
              • CreateIndexQuery<T,TIndex>(String) Method
              • CreateIndexQuery<T,TIndex>(String,TIndex) Method
            • CreateObjectQuery<T> Method
            • Delete Method
              • Delete<T>(T) Method
              • Delete<T>(Int64[]) Method
              • Delete<T>(Int64) Method
            • DeleteBackup Method
            • DeleteEntireDatabase Method
            • Dispose Method
            • DoesDatabaseExist Method
            • ExportSchema Method
            • ExportTableToXml<T> Method
            • Flush Method
            • GetIndex<T> Method
            • GetNextPrimaryKeyValue<T> Method
            • ImportTableFromXml<T> Method
            • IndexExists Method
              • IndexExists<T>(String) Method
              • IndexExists(Type,String) Method
            • Load Method
              • Load<T>(Int64) Method
              • Load(Type,Int64) Method
            • LoadAll<T> Method
            • LoadAllByIndex<T> Method
            • LoadAllWithChildren<T> Method
            • LoadPage<T> Method
            • LoadPageByIndex<T> Method
            • LoadPageWithChildren<T> Method
            • LoadPartial<T> Method
            • LoadSchema Method
            • OpenDatabase Method
            • Pack Method
            • ReCalculateUnusedSpace Method
            • ReIndex<T> Method
            • RemoveIndex<T> Method
            • Restore Method
            • RollbackBulkOperation Method
            • RollbackTransaction Method
            • RowCount<T> Method
            • Save Method
              • Save<T>(T) Method
              • Save<T>(List<T>) Method
            • SavePartial<T> Method
            • SaveSchema Method
            • SearchAllKeywords<T> Method
            • SearchAnyKeywords<T> Method
            • SearchByRegex<T> Method
            • SearchPhrase<T> Method
            • Truncate<T> Method
          • Properties
            • CacheExpirationTime Property
            • DatabaseAssemblyVersion Property
            • DatabaseDirectory Property
            • DatabaseFileVersion Property
            • DatabaseName Property
            • DataFileSize Property
            • DataFormat Property
            • EncryptionBlockSize Property
            • EncryptionKeySize Property
            • EncryptionPassword Property
            • EncryptionSalt Property
            • Encryptor Property
            • IndexFileSize Property
            • IndexPadding Property
            • IsDatabaseOpen Property
            • IsTransactionOpen Property
            • LicenseKey Property
            • MaxCacheSize Property
            • SchemaEncryptionPassword Property
            • SchemaFileSize Property
            • Storage Property
            • TotalFileSize Property
            • Triggers Property
            • UserName Property
        • NinjaDbProException
          • Overview
          • Members
          • NinjaDbProException Constructor
          • Properties
            • Message Property
        • ObjectArrayStringSerializer
          • Overview
          • Members
          • Methods
            • Deserialize Method
            • Serialize Method
        • ObjectQuery<T>
          • Overview
          • Members
          • ObjectQuery<T> Constructor
          • Methods
            • GetEnumerator Method
        • PrimaryKeyAttribute
          • Overview
          • Members
          • PrimaryKeyAttribute Constructor
        • SchemaClass
          • Overview
          • Members
          • SchemaClass Constructor
          • Fields
            • CreateDate Field
            • Definition Field
            • FullName Field
            • Name Field
            • UpdateDate Field
        • SingleIndex<T,TIndex>
          • Overview
          • Members
          • SingleIndex<T,TIndex> Constructor
          • Methods
            • Clear Method
            • ClearLazyLoadedValues Method
            • Delete Method
            • GetAllPrimaryKeys Method
            • GetAllPrimaryKeysDescending Method
            • GetIndexRecordExactMatch Method
            • GetPrimaryKeys Method
            • Insert Method
            • Query Method
            • SortIndex Method
            • Update Method
          • Properties
            • SerializedDictionary Property
          • Fields
            • NonUniqueItems Field
            • UniqueItems Field
        • SingleIndexRecord<T,TIndex>
          • Overview
          • Members
          • SingleIndexRecord<T,TIndex> Constructor
          • Methods
            • Equals Method
            • GetHashCode Method
          • Properties
            • LazyValue Property
          • Fields
            • Index Field
            • PrimaryKey Field
        • SterlingCompositeIndex<T>
          • Overview
          • Members
          • SterlingCompositeIndex<T> Constructor
          • Methods
            • Clear Method
            • ClearLazyLoadedValues Method
            • Delete Method
            • GetAllPrimaryKeys Method
            • GetAllPrimaryKeysDescending Method
            • GetIndexRecordExactMatch Method
            • GetPrimaryKeys Method
            • Insert Method
            • Query Method
            • SortIndex Method
            • Update Method
          • Properties
            • SerializedDictionary Property
          • Fields
            • Records Field
        • SterlingSingleIndex<T,TIndex>
          • Overview
          • Members
          • SterlingSingleIndex<T,TIndex> Constructor
          • Methods
            • Clear Method
            • ClearLazyLoadedValues Method
            • Delete Method
            • GetAllPrimaryKeys Method
            • GetAllPrimaryKeysDescending Method
            • GetIndexRecordExactMatch Method
            • GetPrimaryKeys Method
            • Insert Method
            • Query Method
            • SortIndex Method
            • Update Method
          • Properties
            • SerializedDictionary Property
          • Fields
            • Records Field
        • Table
          • Overview
          • Members
          • Table Constructor
          • Properties
            • Fields Property
            • Indexes Property
            • TableType Property
        • TableIndex
          • Overview
          • Members
          • TableIndex Constructor
          • Properties
            • Id Property
            • IsDirty Property
          • Fields
            • Indexes Field
      • Enumerations
        • EncodingFormat
        • IndexStyle
        • Relationship
        • TriggerAction
      • Interfaces
        • ICompositeIndex
          • Overview
          • Members
          • Methods
            • Insert Method
            • Update Method
          • Properties
            • Properties Property
        • IIndex
          • Overview
          • Members
          • Methods
            • Clear Method
            • ClearLazyLoadedValues Method
            • Delete Method
            • GetAllPrimaryKeys Method
            • GetAllPrimaryKeysDescending Method
            • GetPrimaryKeys Method
            • SortIndex Method
          • Properties
            • ClassName Property
            • DatabaseReference Property
            • IndexName Property
            • IsDirty Property
            • NeedsSorted Property
            • Style Property
        • ISingleIndex
          • Overview
          • Members
          • Methods
            • Insert Method
            • Update Method
          • Properties
            • PropertyName Property
        • IStorage
          • Overview
          • Members
          • Methods
            • CopyDirectory Method
            • CopyStream Method
            • CreateDirectory Method
            • DeleteDirectory Method
            • DeleteFile Method
            • DirectoryExists Method
            • FileExists Method
            • StreamFactory Method
        • IStorageStream
          • Overview
          • Members
          • Methods
            • Close Method
            • Flush Method
            • Read Method
            • ReadByte Method
            • Seek Method
            • Write Method
            • WriteByte Method
          • Properties
            • Length Property
            • Position Property
        • ITrigger
          • Overview
          • Members
          • Methods
            • ExecuteTrigger Method
          • Properties
            • TriggerAction Property
            • TriggerType Property
    • KellermanSoftware.NinjaDatabasePro.Constraint Namespace
      • Overview
      • Classes
        • CaptionAttribute
          • Overview
          • Members
          • CaptionAttribute Constructor
          • Properties
            • Caption Property
        • DefaultValueAttribute
          • Overview
          • Members
          • DefaultValueAttribute Constructor
          • Properties
            • DefaultValue Property
        • MaxLengthAttribute
          • Overview
          • Members
          • MaxLengthAttribute Constructor
          • Properties
            • MaxLength Property
        • NotNullAttribute
          • Overview
          • Members
          • NotNullAttribute Constructor
        • RequiredAttribute
          • Overview
          • Members
          • RequiredAttribute Constructor
• Basic Tasks
  • Read Me First
  • Add Load Update Delete Records
  • Adding Columns
  • Changing Column Types
  • Class Setup
  • Creating A Database
  • Creating Indexes
  • Creating Composite Indexes
  • Creating Full Text Indexes
  • Creating Tables
  • Database Constraints
  • Deleting Columns
  • Deleting Records
  • File Structure
  • Inserting and Updating Records
  • Limitations
  • Loading Records
  • Object Children vs. Relational Children
  • Optimizing Performance
  • Primary Keys
  • Renaming Columns
  • Schema
  • Setting Up Relationships
  • Silverlight Out Of Brower Database
  • Supported Types
  • Transactions
  • Using Caching
  • Using IsDeleted
  • Using IsDirty
  • Using LinqPad
  • Using Triggers
• Contact Information
• Licensing
  • Copyright
  • EULA
  • Distribution
  • Using Your License Key
• System Requirements
• Uninstalling
• Troubleshooting
  • Cannot Open Database Missing Type
  • Cannot find record of type
• Frequently Asked Questions
• Buy Now