SqlCeConnectionStringBuilder Class

Provides a simple way to create and manage the contents of connection strings used by the SqlCeConnection class.

Inheritance Hierarchy

System.Object
  System.Data.Common.DbConnectionStringBuilder
    System.Data.SqlServerCe.SqlCeConnectionStringBuilder

Namespace:  System.Data.SqlServerCe
Assembly:  System.Data.SqlServerCe (in System.Data.SqlServerCe.dll)

Syntax

'Declaration
Public NotInheritable Class SqlCeConnectionStringBuilder _
    Inherits DbConnectionStringBuilder
'Usage
Dim instance As SqlCeConnectionStringBuilder
public sealed class SqlCeConnectionStringBuilder : DbConnectionStringBuilder
public ref class SqlCeConnectionStringBuilder sealed : public DbConnectionStringBuilder
[<SealedAttribute>]
type SqlCeConnectionStringBuilder =  
    class
        inherit DbConnectionStringBuilder
    end
public final class SqlCeConnectionStringBuilder extends DbConnectionStringBuilder

The SqlCeConnectionStringBuilder type exposes the following members.

Constructors

  Name Description
Public method SqlCeConnectionStringBuilder() Initializes a new instance of the SqlCeConnectionStringBuilder class using default values.
Public method SqlCeConnectionStringBuilder(String) Initializes a new instance of the SqlCeConnectionStringBuilder class using the specified connection string that provides the data for the instance’s internal connection information.

Top

Properties

  Name Description
Public property AutoshrinkThreshold Gets or sets the percent of free space in the database file that is allowed before autoshrink begins.
Public property BrowsableConnectionString (inherited from DbConnectionStringBuilder)
Public property CaseSensitive Gets or sets a value that indicates whether or not the database collation is case-sensitive.
Public property ConnectionString (inherited from DbConnectionStringBuilder)
Public property Count (inherited from DbConnectionStringBuilder)
Public property DataSource Gets or sets the file path and name of the SQL Server Compact database.
Public property DefaultLockEscalation Gets or sets the number of locks a transaction will acquire before attempting escalation from row to page, or from page to table.
Public property DefaultLockTimeout Gets or sets the default number of milliseconds that a transaction will wait for a lock.
Public property Encrypt Gets or sets a value that indicates whether or not the database is encrypted.
Public property EncryptionMode Gets or sets the encryption mode with which the database is to be created against.
Public property Enlist Gets or sets a value that indicates whether a connection database is opened by using Enlist.
Public property FileMode Gets or sets the mode to use when opening the database file.
Public property FlushInterval Gets or sets the specified interval time (in seconds) before all committed transactions are flushed to disk.
Public property InitialLcid Gets or sets the locale ID (LCID) to use with the database.
Public property IsFixedSize Gets a value that indicates whether the SqlCeConnectionStringBuilder has a fixed size. (Overrides DbConnectionStringBuilder.IsFixedSize.)
Public property IsReadOnly (inherited from DbConnectionStringBuilder)
Public property Item Gets or sets the value associated with the specified key. (Overrides DbConnectionStringBuilder.Item[String].)
Public property Keys Gets an ICollection that contains the keys in the SqlCeConnectionStringBuilder. (Overrides DbConnectionStringBuilder.Keys.)
Public property MaxBufferSize Gets or sets the largest amount of memory, in kilobytes that SQL Server Mobile can use before it starts flushing changes to disk.
Public property MaxDatabaseSize Gets or sets the maximum size of the database, in Megabytes.
Public property Password Gets or sets the database password, which can be up to 40 characters in length.
Public property PersistSecurityInfo Gets or sets a value that indicates whether the security-sensitive information, such as the password is not returned as part of the connection.
Public property TempFileMaxSize Gets or sets the maximum size of the temporary database file, in Megabytes.
Public property TempFilePath Gets or sets the location of the temporary database.
Public property Values Gets an ICollection that contains the values in the SqlCeConnectionStringBuilder. (Overrides DbConnectionStringBuilder.Values.)

Top

Methods

  Name Description
Public method Add (inherited from DbConnectionStringBuilder)
Public method Clear Clears the contents of the SqlCeConnectionStringBuilder instance. (Overrides DbConnectionStringBuilder.Clear().)
Protected method ClearPropertyDescriptors (inherited from DbConnectionStringBuilder)
Public method ContainsKey Determines whether the SqlCeConnectionStringBuilder contains a specific key. (Overrides DbConnectionStringBuilder.ContainsKey(String).)
Public method Equals (inherited from Object)
Public method EquivalentTo (inherited from DbConnectionStringBuilder)
Protected method Finalize (inherited from Object)
Public method GetHashCode (inherited from Object)
Protected method GetProperties (inherited from DbConnectionStringBuilder)
Public method GetType (inherited from Object)
Protected method MemberwiseClone (inherited from Object)
Public method Remove Removes the entry with the specified key from the SqlCeConnectionStringBuilder instance. (Overrides DbConnectionStringBuilder.Remove(String).)
Public method ShouldSerialize Indicates whether the specified key exists in this SqlCeConnectionStringBuilder instance. (Overrides DbConnectionStringBuilder.ShouldSerialize(String).)
Public method ToString (inherited from DbConnectionStringBuilder)
Public method TryGetValue Retrieves a value corresponding to the supplied key from this SqlCeconnectionStringBuilder. (Overrides DbConnectionStringBuilder.TryGetValue(String, Object%).)

Top

Explicit Interface Implementations

  Name Description
Explicit interface implemetationPrivate method IDictionary.Add (inherited from DbConnectionStringBuilder)
Explicit interface implemetationPrivate method IDictionary.Contains (inherited from DbConnectionStringBuilder)
Explicit interface implemetationPrivate method ICollection.CopyTo (inherited from DbConnectionStringBuilder)
Explicit interface implemetationPrivate method ICustomTypeDescriptor.GetAttributes (inherited from DbConnectionStringBuilder)
Explicit interface implemetationPrivate method ICustomTypeDescriptor.GetClassName (inherited from DbConnectionStringBuilder)
Explicit interface implemetationPrivate method ICustomTypeDescriptor.GetComponentName (inherited from DbConnectionStringBuilder)
Explicit interface implemetationPrivate method ICustomTypeDescriptor.GetConverter (inherited from DbConnectionStringBuilder)
Explicit interface implemetationPrivate method ICustomTypeDescriptor.GetDefaultEvent (inherited from DbConnectionStringBuilder)
Explicit interface implemetationPrivate method ICustomTypeDescriptor.GetDefaultProperty (inherited from DbConnectionStringBuilder)
Explicit interface implemetationPrivate method ICustomTypeDescriptor.GetEditor (inherited from DbConnectionStringBuilder)
Explicit interface implemetationPrivate method IEnumerable.GetEnumerator (inherited from DbConnectionStringBuilder)
Explicit interface implemetationPrivate method IDictionary.GetEnumerator (inherited from DbConnectionStringBuilder)
Explicit interface implemetationPrivate method ICustomTypeDescriptor.GetEvents() (inherited from DbConnectionStringBuilder)
Explicit interface implemetationPrivate method ICustomTypeDescriptor.GetEvents(array<Attribute[]) (inherited from DbConnectionStringBuilder)
Explicit interface implemetationPrivate method ICustomTypeDescriptor.GetProperties() (inherited from DbConnectionStringBuilder)
Explicit interface implemetationPrivate method ICustomTypeDescriptor.GetProperties(array<Attribute[]) (inherited from DbConnectionStringBuilder)
Explicit interface implemetationPrivate method ICustomTypeDescriptor.GetPropertyOwner (inherited from DbConnectionStringBuilder)
Explicit interface implemetationPrivate property ICollection.IsSynchronized (inherited from DbConnectionStringBuilder)
Explicit interface implemetationPrivate property IDictionary.Item (inherited from DbConnectionStringBuilder)
Explicit interface implemetationPrivate method IDictionary.Remove (inherited from DbConnectionStringBuilder)
Explicit interface implemetationPrivate property ICollection.SyncRoot (inherited from DbConnectionStringBuilder)

Top

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

See Also

Reference

System.Data.SqlServerCe Namespace