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

Top

Methods

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

Top

Explicit Interface Implementations

	Name	Description
	IDictionary.Add	(inherited from DbConnectionStringBuilder)
	IDictionary.Contains	(inherited from DbConnectionStringBuilder)
	ICollection.CopyTo	(inherited from DbConnectionStringBuilder)
	ICustomTypeDescriptor.GetAttributes	(inherited from DbConnectionStringBuilder)
	ICustomTypeDescriptor.GetClassName	(inherited from DbConnectionStringBuilder)
	ICustomTypeDescriptor.GetComponentName	(inherited from DbConnectionStringBuilder)
	ICustomTypeDescriptor.GetConverter	(inherited from DbConnectionStringBuilder)
	ICustomTypeDescriptor.GetDefaultEvent	(inherited from DbConnectionStringBuilder)
	ICustomTypeDescriptor.GetDefaultProperty	(inherited from DbConnectionStringBuilder)
	ICustomTypeDescriptor.GetEditor	(inherited from DbConnectionStringBuilder)
	IEnumerable.GetEnumerator	(inherited from DbConnectionStringBuilder)
	IDictionary.GetEnumerator	(inherited from DbConnectionStringBuilder)
	ICustomTypeDescriptor.GetEvents()	(inherited from DbConnectionStringBuilder)
	ICustomTypeDescriptor.GetEvents(array<Attribute[])	(inherited from DbConnectionStringBuilder)
	ICustomTypeDescriptor.GetProperties()	(inherited from DbConnectionStringBuilder)
	ICustomTypeDescriptor.GetProperties(array<Attribute[])	(inherited from DbConnectionStringBuilder)
	ICustomTypeDescriptor.GetPropertyOwner	(inherited from DbConnectionStringBuilder)
	ICollection.IsSynchronized	(inherited from DbConnectionStringBuilder)
	IDictionary.Item	(inherited from DbConnectionStringBuilder)
	IDictionary.Remove	(inherited from DbConnectionStringBuilder)
	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