SqlProviderServices Class

This is the well-known string using in configuration files and code-based configuration as the "provider invariant name" used to specify Microsoft SQL Server for ADO.NET and Entity Framework provider services.

The Singleton instance of the SqlProviderServices type.

Set to the full name of the Microsoft.SqlServer.Types assembly to override the default selection

Get or sets a value indicating whether Decimal parameter values are truncated to the scale (number of decimal places) defined for their corresponding columns when they are sent to the database. A value of true indicates that SqlParameter objects created for Decimal columns will have their Scale properties set, which will cause the parameter values to be truncated. If set to false then the Scale properties will not be set, avoiding the truncation behavior of SqlParameter and allowing SQL Server to round values if necessary. The default value is true to prevent breaking existing applications that depend on this behavior.

Gets or sets a value indicating whether the ROW_NUMBER() function is used in sort expression passed to the ORDER BY clause when OFFSET is present in query. The default value of true is recommended to obtain query results that are stable for paging operations. The value of false can be used for compatibility with previous versions of EF and will cause the sort expression to be passed unmodified to the ORDER BY clause, which can lead to unstable results if the ordering is ambiguous.

Gets or sets a value indicating whether to use the SCOPE_IDENTITY() function to retrieve values generated by the database for numeric columns during an INSERT operation. The default value of true is recommended and can provide better performance if all numeric values are generated using IDENTITY columns. If set to false, an OUTPUT clause will be used instead. An OUTPUT clause makes it possible to retrieve values generated by sequences or other means.

Adds an IDbDependencyResolver that will be used to resolve additional default provider services when a derived type is registered as an EF provider either using an entry in the application's config file or through code-based registration in DbConfiguration.

See issue 2390 - cloning the DesignTimeVisible property on the DbCommand can cause deadlocks. So here allow sub-classes to override.

Clones the connection.

Clones the connection.

Create the default DbCommandDefinition object based on the prototype command This method is intended for provider writers to build a default command definition from a command. Note: This will clone the prototype

Create a Command Definition object given a command tree.

Creates command definition from specified manifest and command tree.

Creates a database indicated by connection and creates schema objects (tables, primary keys, foreign keys) based on the contents of storeItemCollection.

Generates a data definition language (DDL script that creates schema objects (tables, primary keys, foreign keys) based on the contents of the StoreItemCollection parameter and targeted for the version of the database corresponding to the provider manifest token.

Creates a command definition object for the specified provider manifest and command tree.

Returns a value indicating whether a given database exists on the server.

Returns a value indicating whether a given database exists on the server.

Creates a database indicated by connection and creates schema objects (tables, primary keys, foreign keys) based on the contents of a StoreItemCollection.

Generates a data definition language (DDL) script that creates schema objects (tables, primary keys, foreign keys) based on the contents of the StoreItemCollection parameter and targeted for the version of the database corresponding to the provider manifest token.

Returns a value indicating whether a given database exists on the server.

Returns a value indicating whether a given database exists on the server.

Deletes the specified database.

Gets the spatial services for the DbProviderServices.

Deletes the specified database.

When overridden in a derived class, returns an instance of a class that derives from the DbProviderManifest.

Returns provider manifest token for a given connection.

Gets the spatial data reader for the DbProviderServices.

Returns the provider manifest by using the specified version information.

Returns provider manifest token given a connection.

Called to resolve additional default provider services when a derived type is registered as an EF provider either using an entry in the application's config file or through code-based registration in DbConfiguration. The implementation of this method in this class uses the resolvers added with the AddDependencyResolver method to resolve dependencies.

Called to resolve additional default provider services when a derived type is registered as an EF provider either using an entry in the application's config file or through code-based registration in DbConfiguration. The implementation of this method in this class uses the resolvers added with the AddDependencyResolver method to resolve dependencies.

Gets the spatial data reader for the DbProviderServices.

Gets the spatial services for the DbProviderServices.

Gets the spatial services for the DbProviderServices.

Registers a handler to process non-error messages coming from the database provider.

Sets the parameter value and appropriate facets for the given TypeUsage.

Sets the parameter value and appropriate facets for the given TypeUsage.

Calls GetService(Type, Object) passing the given type argument and using null for the name argument.

Calls GetService(Type, Object) passing the generic type of the method and the given name as arguments.

Calls GetService(Type, Object) passing the generic type of the method as the type argument and null for the name argument.

Calls GetServices(Type, Object) passing the given type argument and using null for the name argument.

Calls GetServices(Type, Object) passing the generic type of the method and the given name as arguments.

Calls GetServices(Type, Object) passing the generic type of the method as the type argument and null for the name argument.