DbNetSuiteVS
CommandConfig Class
Namespaces ► DbNetLink.Data ► CommandConfig
The CommandConfig class is used to combine an SQL statment and its associated parameters into a single object
Declaration Syntax
C#Visual Basic
public class CommandConfig
Public Class CommandConfig
Members
All MembersConstructorsFields



IconMemberDescription
CommandConfig()()()
Initializes a new instance of the CommandConfig class

CommandConfig(String)
Initializes a new instance of the CommandConfig class

Params
Parameter values collection

Sql
Sql command text including any paramater placeholders

Remarks

The CommandConfig class can be used with the following methods

  • [!:DbNetLink.DbNetData.ExecuteDelete(CommandConfig)]
  • [!:DbNetLink.DbNetData.ExecuteInsert(CommandConfig)]
  • [!:DbNetLink.DbNetData.ExecuteQuery(CommandConfig)]
  • [!:DbNetLink.DbNetData.ExecuteNonQuery(CommandConfig)]
  • [!:DbNetLink.DbNetData.ExecuteSingletonQuery(CommandConfig)]
  • [!:DbNetLink.DbNetData.ExecuteDelete(CommandConfig)]
Examples
CopyC#
DbNetData Data = new DbNetData("Server=dbserver;Database=Northwind;Trusted_Connection=true;");
CommandConfig CmdConfig = new CommandConfig("select * from customers where city = @city and country = @country");
CmdConfig.Params["city"] = "London";
CmdConfig.Params["country"] = "UK";
Data.ExecuteQuery(CmdConfig);
Inheritance Hierarchy
Object
CommandConfig
 QueryCommandConfig
 UpdateCommandConfig

Assembly: DbNetLink.DbNetSuiteVS (Module: DbNetLink.DbNetSuiteVS) Version: 0.9.3317.16858 (0.9.0.0)