C# Class Clippy.Data.DbCommandExtensions

Extensions to DbCommand for building command parameters
Show file Open project: 24hr/Clippy

Public Methods

Method Description
AddParameters ( this cmd, object parameters ) : DbCommand

Convert object to SqlParameters and add to Command

GetParameter ( this cmd, object parameters, PropertyInfo propInfo ) : DbParameter

Builds a DbParameter from a reflected property on an object, reflecting it's property type

GetParameter ( this cmd, string parameterName, object parameterValue, Type parameterType ) : DbParameter

Builds a DbParameter from a reflected property on an object

ToSqlParameters ( this parameters, DbCommand cmd ) : IEnumerable

Convert an object into an IEnumerable<DbParameter>

Method Details

AddParameters() public static method

Convert object to SqlParameters and add to Command
public static AddParameters ( this cmd, object parameters ) : DbCommand
cmd this
parameters object
return System.Data.Common.DbCommand

GetParameter() public static method

Builds a DbParameter from a reflected property on an object, reflecting it's property type
public static GetParameter ( this cmd, object parameters, PropertyInfo propInfo ) : DbParameter
cmd this
parameters object
propInfo System.Reflection.PropertyInfo
return System.Data.Common.DbParameter

GetParameter() public static method

Builds a DbParameter from a reflected property on an object
public static GetParameter ( this cmd, string parameterName, object parameterValue, Type parameterType ) : DbParameter
cmd this
parameterName string
parameterValue object
parameterType System.Type
return System.Data.Common.DbParameter

ToSqlParameters() public static method

Convert an object into an IEnumerable<DbParameter>
public static ToSqlParameters ( this parameters, DbCommand cmd ) : IEnumerable
parameters this
cmd System.Data.Common.DbCommand
return IEnumerable