Creates and returns a SqlCommand object associated with the SqlConnection. When overridden in a derived class, creates and returns a DbCommand object associated with the current connection. Creates an object that contains all the relevant information required to generate a proxy used to communicate with a remote object.
Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources. Releases all resources used by the Component. Releases the unmanaged resources used by the DbConnection and optionally releases the managed resources.
Releases the unmanaged resources used by the Component and optionally releases the managed resources. Retrieves the current lifetime service object that controls the lifetime policy for this instance. Returns schema information for the data source of this SqlConnection. Returns schema information for the data source of this DbConnection. Returns schema information for the data source of this SqlConnection using the specified string for the schema name.
Returns schema information for the data source of this DbConnection using the specified string for the schema name. Returns schema information for the data source of this SqlConnection using the specified string for the schema name and the specified string array for the restriction values.
Returns schema information for the data source of this DbConnection using the specified string for the schema name and the specified string array for the restriction values.
This is an asynchronous version of GetSchema. Providers should override with an appropriate implementation. The cancellationToken can optionally be honored. The default implementation invokes the synchronous GetSchema call and returns a completed task. The default implementation will return a cancelled task if passed an already cancelled cancellationToken.
Exceptions thrown by GetSchema will be communicated via the returned Task Exception property. This is the asynchronous version of GetSchema String. The default implementation invokes the synchronous GetSchema String call and returns a completed task.
This is the asynchronous version of GetSchema String, String[]. The default implementation invokes the synchronous GetSchema String, String[] call and returns a completed task. Returns an object that represents a service provided by the Component or by its Container.
Gets the Type of the current instance. Creates a shallow copy of the current Object. Creates a shallow copy of the current MarshalByRefObject object. Raises the StateChange event. Opens a database connection with the property settings specified by the ConnectionString. An asynchronous version of Open , which opens a database connection with the settings specified by the ConnectionString. An asynchronous version of Open , which opens a database connection with the property settings specified by the ConnectionString.
The cancellation token can be used to request that the operation be abandoned before the connection timeout elapses. Exceptions will be propagated via the returned Task. If the connection timeout time elapses without successfully connecting, the returned Task will be marked as faulted with an Exception. The implementation returns a Task without blocking the calling thread for both pooled and non-pooled connections. This is the asynchronous version of Open.
The cancellation token can optionally be honored. The default implementation invokes the synchronous Open call and returns a completed task. Exceptions thrown by Open will be communicated via the returned Task Exception property. Do not invoke other methods and properties of the DbConnection object until the returned Task is complete.
Returns a String containing the name of the Component , if any. This method should not be overridden. Occurs when the component is disposed by a call to the Dispose method. Begins a database transaction with the specified IsolationLevel value.
Creates and returns a DbCommand object that is associated with the current connection. Skip to main content. This browser is no longer supported. Download Microsoft Edge More info.
Contents Exit focus mode. Sql Connection Class Reference Is this page helpful? Please rate your experience Yes No. Any additional feedback? Namespace: System. Query QueryAsync Execute ChangeDatabase Open ExecuteAsync BeginTransaction Insert ExecuteReader Update ExecuteScalar QueryMultiple Select CreateStoreCommand Delete Get AutoQuery ExecuteNonQuery 8.
EnlistTransaction 8. ExecuteFor 8. QueryFor 7. Create 6. ExecuteStoredProcedure 6. ExecQuery 6. ExecuteScalarAsync 6. ExecuteSingleValue 5. GetList 5. RetrieveStatistics 5. ExecuteMapperCommand 4. ExecSql 4. QueryDatatable 3. ExecuteSingleColumn 3. GetAll 3.
Dispose 3. InsertAsync 3. GetDataReader 3. QuerySingle 2. GetConversationGroupsCount 2. QuerySql 2. QuickOpen 2.
Connect 2. ResetStatistics 2. GetTable 2. Related in langs. Add new SqlParameter " id", id ; connection. Open ; GetExample command, p. ToArray ; command. ExecuteNonQuery ; command. Improve this answer. Bob Lokerse 1 1 silver badge 6 6 bronze badges.
Svek Svek 5 5 silver badges 16 16 bronze badges. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown.
The Overflow Blog. Stack Gives Back Safety in numbers: crowdsourcing data on nefarious IP addresses. Featured on Meta.
New post summary designs on greatest hits now, everywhere else eventually. Related
0コメント