Automatically generates SQL commands for SELECT/INSERT/UPDATE/DELETE queries.
Inheritance Hierarchy
NReco.Data DbCommandBuilder
NReco.Data DbBatchCommandBuilder
Namespace: NReco.Data
Assembly: NReco.Data (in NReco.Data.dll) Version: 1.0.2
Syntax
The DbCommandBuilder type exposes the following members.
Constructors
| Name | Description | |
|---|---|---|
 | DbCommandBuilder |
Initializes a new instance of the DbCommandBuilder.
|
Methods
| Name | Description | |
|---|---|---|
| Equals | (Inherited from Object.) |
 | Finalize | Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object.) |
| GetCommand | |
| GetDeleteCommand |
Gets the automatically generated IDbCommand object to delete rows by specified Query.
|
| GetHashCode | Serves as a hash function for a particular type. (Inherited from Object.) |
| GetInsertCommand |
Gets the automatically generated IDbCommand object to insert new record.
|
| GetSelectCommand |
Gets the automatically generated IDbCommand object to select rows by specified Query.
|
| GetSqlBuilder | |
| GetType | Gets the Type of the current instance. (Inherited from Object.) |
| GetUpdateCommand |
Gets the automatically generated IDbCommand object to update rows by specified Query.
|
| MemberwiseClone | Creates a shallow copy of the current Object. (Inherited from Object.) |
| SetCommandText | |
| ToString | Returns a string that represents the current object. (Inherited from Object.) |
Extension Methods
| Name | Description | |
|---|---|---|
 | GetInsertCommand(String, IDictionary String, Object ) | Overloaded. (Defined by DbCommandBuilderExtensions.) |
| GetInsertCommand(String, Object) | Overloaded. (Defined by DbCommandBuilderExtensions.) |
| GetUpdateCommand(Query, IDictionary String, Object ) | Overloaded. (Defined by DbCommandBuilderExtensions.) |
| GetUpdateCommand(Query, Object) | Overloaded. (Defined by DbCommandBuilderExtensions.) |
Properties
| Name | Description | |
|---|---|---|
 | DbFactory |
Gets DB Factory component.
|
| DeleteTemplate |
Gets or sets template for SQL DELETE query.
|
| InsertTemplate |
Gets or sets template for SQL INSERT query.
|
| SelectTemplate |
Gets or sets template for SQL SELECT query.
|
| UpdateTemplate |
Gets or sets template for SQL UPDATE query.
|
| Views |
Gets or sets view name -> DbDataView dictionary.
|
See Also